(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, COUNT(pts.player_id) as player_count FROM event e INNER JOIN player_pts pts ON pts.event_id = e.id LEFT JOIN location AS l ON e.location_id = l.id WHERE e.location_id = 66 AND pts.action = 'CHECK_IN' GROUP BY pts.event_id ORDER BY e.date DESC LIMIT 50
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 2174 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 2161 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 2134 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 2113 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 2098 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 2062 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 2032 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 2000 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 1994 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 1917 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 1899 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 1889 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 1877 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 1857 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 1830 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 1826 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 1809 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 1789 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 1775 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 1766 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 1753 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 1726 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 1716 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 1715 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 1687 AND pts.action = 1
(mysqli): SELECT CONCAT(p.first,' ',p.last) as wname, p.id as wid FROM player_pts pts INNER JOIN player p ON p.id = pts.player_id WHERE pts.event_id = 1681 AND pts.action = 1