Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- mbo.object_id AS incomes_items_id
- , mb.object_id AS offline_shops_id
- , ia.incomes_attributes_id
- , ia.products_attributes_id
- , t.products_price
- FROM marking_boxes AS mb
- JOIN marking_boxes_to_objects AS mbo ON mbo.marking_boxes_id = mb.marking_boxes_id
- JOIN incomes_items AS ii ON ii.incomes_items_id = mbo.object_id
- JOIN incomes_attributes AS ia ON ia.incomes_attributes_id = ii.incomes_attributes_id
- LEFT JOIN (
- SELECT pp.products_attributes_id
- , pp.products_price
- , ppb.offline_shops_id
- FROM offline_shops_products_prices AS pp
- JOIN offline_shops_products_prices_changes_bases AS ppb ON ppb.offline_shops_products_prices_changes_bases_id = pp.offline_shops_products_prices_changes_bases_id
- ) AS t ON t.products_attributes_id = ia.products_attributes_id
- AND t.offline_shops_id = mb.object_id
- WHERE
- mb.marking_boxes_status = 207
- AND mb.object_id = 1 -- только 1й магаз
- AND t.products_price IS NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement