(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 = 32 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 = 4360 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 = 4321 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 = 4285 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 = 4262 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 = 4223 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 = 4197 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 = 4130 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 = 4087 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 = 4053 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 = 4019 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 = 3989 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 = 3949 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 = 3911 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 = 3883 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 = 3853 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 = 3820 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 = 3789 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 = 3766 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 = 1670 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 = 1645 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 = 1628 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 = 1576 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 = 1554 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 = 1533 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 = 1510 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 = 1479 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 = 1451 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 = 1445 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 = 1414 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 = 1399 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 = 1376 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 = 1368 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 = 1345 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 = 1280 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 = 1274 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 = 1269 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 = 1264 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 = 1223 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 = 1190 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 = 1184 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 = 1178 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 = 1171 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 = 1111 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 = 1105 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 = 1055 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 = 1049 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 = 1046 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 = 975 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 = 955 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 = 933 AND pts.action = 1