Advertisement
zotov-vs

Untitled

Aug 23rd, 2017
142
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. SELECT ii.incomes_items_id, i.date, mb.date_added
  2. FROM incomes AS i
  3. JOIN incomes_attributes AS ia ON ia.incomes_id = i.incomes_id
  4. JOIN incomes_items AS ii ON ii.incomes_attributes_id = ia.incomes_attributes_id
  5. JOIN marking_boxes_to_objects AS mbo ON mbo.object_id = ii.incomes_items_id
  6. JOIN marking_boxes AS mb ON mb.marking_boxes_id = mbo.marking_boxes_id
  7. WHERE i.incomes_id = 565 AND i.date > mb.date_added
  8. ORDER BY mb.date_added
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement