Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT(DISTINCT detail.id) as details_count
- FROM details detail
- JOIN akeneo_detail ad on detail.id = ad.main_detail_id
- JOIN akeneo_category ac on ad.category_id = ac.id
- LEFT JOIN detail_prices p ON detail.id = p.detail_id
- LEFT JOIN remains r on detail.id = r.detail_id
- LEFT JOIN detail_partner_prices pp ON detail.id = pp.detail_id
- LEFT JOIN partner_remains pr on detail.id = pr.detail_id
- WHERE
- detail.is_disabled = 0
- AND ac.id = 24
- AND r.storage_id NOT IN ('20', '21')
- AND ((r.id IS NOT NULL AND p.detail_id IS NOT NULL)
- OR (pr.id IS NOT NULL AND pp.detail_id IS NOT NULL))
- GROUP BY
- ac.id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement