(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 = 23 OR ( e.tournament_id = 1 AND l.id IN (129, 196) AND e.date >= 1775779200 AND e.date <= 1806451200 ) ) ORDER BY e.date ASC