BID | LID
1      2
1      5
1      8
1      11
2      5
2      7
3      11

 
SELECT bid, COUNT(*) AS lid_count
FROM TABLE
WHERE lid IN (2,8)
GROUP BY bid
HAVING lid_count > 1

 
SELECT bid
FROM TABLE
WHERE lid IN (2,8)
GROUP BY bid
HAVING COUNT(*) > 1

SELECT a
FROM bum
WHERE b IN (5, 7)
GROUP BY a
HAVING COUNT(*) > 1

SELECT *
FROM second_table
WHERE bid IN (
              SELECT bid
              FROM first_table
              WHERE lid IN (2,8)
              GROUP BY bid
              HAVING COUNT(*) > 1
             )