>> EASTERNPOKERTOUR.COM
(mysqli): SELECT t.id, t.name, t.state FROM tournament t WHERE t.active = 1 ORDER BY t.name ASC
(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 l.id, l.name, l.city FROM location l LEFT JOIN event e ON e.location_id = l.id LEFT JOIN tournament t ON t.id = e.tournament_id WHERE l.active = 1 AND t.active = 1 ORDER BY l.name ASC
(mysqli): SELECT opt.player_id, pp.thumb_name as thumb, CONCAT(p.first,' ',p.last) as name FROM player_opt opt LEFT JOIN player_photo pp ON opt.player_id = pp.player_id INNER JOIN player p ON p.id = opt.player_id WHERE opt.featured = 1 AND pp.dflt = 1
FEATURED
PLAYERS
