Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- The group by is getting rid of some of the rows?
- SELECT *, bp.product_id
- FROM builder_product as bp
- JOIN builder_step as bs
- ON bs.builder_id=bp.builder_id
- JOIN builder as b
- ON b.builder_id=bs.builder_id
- WHERE b.business_id = '60'
- GROUP BY product_id
- ORDER BY bs.step_number
- SELECT
- bp.*,
- bs.name
- FROM
- builder_product bp
- JOIN builder_step bs ON bp.builder_step_id = bs.builder_step_id
- JOIN builder b ON bp.builder_id = b.builder_id
- WHERE b.business_id = 60
- SELECT bp.*, bs.*, b.*
- FROM FROM builder_product as bp
- INNER JOIN builder_step as bs ON bs.builder_id=bp.builder_id
- INNER JOIN builder as b ON b.builder_id=bs.builder_id
- WHERE bp.product_id IN
- (
- SELECT bp1.product_id
- FROM builder_product as bp1
- JOIN builder_step as bs1 ON bs1.builder_id = bp1.builder_id
- JOIN builder as b1 ON b1.builder_id = bs1.builder_id
- WHERE b1.business_id = '60'
- GROUP BY bp1.product_id
- )
- AND b.business_id = '60'
- ORDER BY bs.step_number
Add Comment
Please, Sign In to add comment