Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT ii.incomes_items_id, i.date, mb.date_added
- FROM incomes AS i
- JOIN incomes_attributes AS ia ON ia.incomes_id = i.incomes_id
- JOIN incomes_items AS ii ON ii.incomes_attributes_id = ia.incomes_attributes_id
- JOIN marking_boxes_to_objects AS mbo ON mbo.object_id = ii.incomes_items_id
- JOIN marking_boxes AS mb ON mb.marking_boxes_id = mbo.marking_boxes_id
- WHERE i.incomes_id = 565 AND i.date > mb.date_added
- ORDER BY mb.date_added
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement