(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 = 644 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 = 45899 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 = 45866 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 = 45794 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 = 45753 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 = 45720 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 = 45685 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 = 45655 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 = 45625 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 = 45592 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 = 45542 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 = 45435 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 = 45392 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 = 45383 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 = 45374 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 = 45293 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 = 45246 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 = 45199 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 = 45170 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 = 45115 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 = 45106 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 = 45078 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 = 45002 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 = 44993 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 = 44877 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 = 44794 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 = 45005 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 = 44755 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 = 44741 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 = 44666 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 = 44594 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 = 44585 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 = 44541 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 = 44487 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 = 44438 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 = 44429 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 = 44391 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 = 44307 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 = 44258 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 = 44255 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 = 44184 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 = 44161 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 = 44063 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 = 44054 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 = 43981 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 = 43973 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 = 43904 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 = 43808 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 = 43780 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 = 43753 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 = 43634 AND pts.action = 1