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