Advertisement
Guest User

Untitled

a guest
Apr 30th, 2016
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. SELECT
  2. p.id,
  3. p.name
  4. FROM
  5. product AS p
  6. JOIN
  7. product_option AS o1
  8. ON
  9. p.id = o1.product_id AND
  10. o1.option_id = 1
  11. JOIN
  12. product_option AS o2
  13. ON
  14. p.id = o2.product_id AND
  15. o2.option_id = 14
  16. JOIN
  17. product_option AS o3
  18. ON
  19. p.id = o3.product_id AND
  20. o3.option_id = 25
  21.  
  22. SELECT p.id, p.name
  23. FROM product AS p
  24. JOIN product_option AS o
  25. ON p.id = o.product_id AND o.option_id in(1, 14, 25)
  26. GROUP BY p.id, p.name
  27. HAVING count(1)=3
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement