(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 = 14 ) OR ( e.date < 1792713600 AND e.tournament_id = 1 AND l.id IN (533) AND e.date >= 1775779200 AND e.date <= 1806451200 ) ORDER BY e.date DESC