select items.id from items join subitems on items.id = subitems.item_id where max(subitems.date) + items.interval < now() group by items.id , but using our ORM ...