(mysqli): SELECT id, name, city FROM location WHERE active = 1 ORDER BY name ASC
(mysqli): SELECT id, name, state FROM tournament WHERE 1 ORDER BY name ASC
(mysqli): SELECT e.id, e.date, e.time, l.default_time, e.name, e.tournament_id, e.location_id FROM event e LEFT JOIN location AS l ON e.location_id = l.id WHERE e.location_id = 503 AND e.date >= 1792713600 AND e.active = 1 ORDER BY e.date ASC LIMIT 50