SELECT * FROM orders o JOIN users u ON 1=1 JOIN items i ON i.order_id = o.id WHERE o.created_at > '2020-01-01' ORDER BY o.created_at DESC;