(mysqli): SELECT e.*, l.name as lname, l.id as lid FROM event e LEFT JOIN location l ON l.id = e.location_id WHERE e.date >= 1792713600 AND ( e.tournament_id = 6 OR ( e.tournament_id = 24 AND l.id IN (418, 533, 619) AND e.date >= 1775779200 AND e.date <= 1806451200 ) ) ORDER BY e.date ASC