Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- p.id,
- p.name
- FROM
- product AS p
- JOIN
- product_option AS o1
- ON
- p.id = o1.product_id AND
- o1.option_id = 1
- JOIN
- product_option AS o2
- ON
- p.id = o2.product_id AND
- o2.option_id = 14
- JOIN
- product_option AS o3
- ON
- p.id = o3.product_id AND
- o3.option_id = 25
- SELECT p.id, p.name
- FROM product AS p
- JOIN product_option AS o
- ON p.id = o.product_id AND o.option_id in(1, 14, 25)
- GROUP BY p.id, p.name
- HAVING count(1)=3
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement