SELECT prod_id, quantity
FROM OrderItems O1
WHERE quantity = 100
union
SELECT prod_id, quantity
FROM OrderItems O2
WHERE prod_id like 'BNBG%'