Advertisement
zotov-vs

Untitled

Aug 22nd, 2017
160
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. SELECT
  2. mbo.object_id AS incomes_items_id
  3. , mb.object_id AS offline_shops_id
  4. , ia.incomes_attributes_id
  5. , ia.products_attributes_id
  6. , t.products_price
  7. FROM marking_boxes AS mb
  8. JOIN marking_boxes_to_objects AS mbo ON mbo.marking_boxes_id = mb.marking_boxes_id
  9. JOIN incomes_items AS ii ON ii.incomes_items_id = mbo.object_id
  10. JOIN incomes_attributes AS ia ON ia.incomes_attributes_id = ii.incomes_attributes_id
  11. LEFT JOIN (
  12. SELECT pp.products_attributes_id
  13. , pp.products_price
  14. , ppb.offline_shops_id
  15. FROM offline_shops_products_prices AS pp
  16. 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
  17. ) AS t ON t.products_attributes_id = ia.products_attributes_id
  18. AND t.offline_shops_id = mb.object_id
  19. WHERE
  20. mb.marking_boxes_status = 207
  21. AND mb.object_id = 1 -- только 1й магаз
  22. AND t.products_price IS NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement