Guest User

Untitled

a guest
Aug 16th, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. The group by is getting rid of some of the rows?
  2. SELECT *, bp.product_id
  3. FROM builder_product as bp
  4. JOIN builder_step as bs
  5. ON bs.builder_id=bp.builder_id
  6. JOIN builder as b
  7. ON b.builder_id=bs.builder_id
  8. WHERE b.business_id = '60'
  9. GROUP BY product_id
  10. ORDER BY bs.step_number
  11.  
  12. SELECT
  13. bp.*,
  14. bs.name
  15. FROM
  16. builder_product bp
  17. JOIN builder_step bs ON bp.builder_step_id = bs.builder_step_id
  18. JOIN builder b ON bp.builder_id = b.builder_id
  19. WHERE b.business_id = 60
  20.  
  21. SELECT bp.*, bs.*, b.*
  22. FROM FROM builder_product as bp
  23. INNER JOIN builder_step as bs ON bs.builder_id=bp.builder_id
  24. INNER JOIN builder as b ON b.builder_id=bs.builder_id
  25. WHERE bp.product_id IN
  26. (
  27. SELECT bp1.product_id
  28. FROM builder_product as bp1
  29. JOIN builder_step as bs1 ON bs1.builder_id = bp1.builder_id
  30. JOIN builder as b1 ON b1.builder_id = bs1.builder_id
  31. WHERE b1.business_id = '60'
  32. GROUP BY bp1.product_id
  33. )
  34. AND b.business_id = '60'
  35. ORDER BY bs.step_number
Add Comment
Please, Sign In to add comment