(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 = 360 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 = 14751 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 = 14605 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 = 14598 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 = 14515 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 = 14508 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 = 14342 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 = 14335 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 = 14328 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 = 14321 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 = 14235 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 = 14094 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 = 14086 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 = 14079 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 = 13863 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 = 13856 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 = 13849 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 = 13827 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 = 13750 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 = 13749 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 = 13670 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 = 13648 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 = 13604 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 = 13546 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 = 13490 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 = 13461 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 = 13162 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 = 11281 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 = 11127 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 = 11122 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 = 11055 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 = 11049 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 = 10949 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 = 10865 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 = 10859 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 = 10734 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 = 10728 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 = 10637 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 = 10631 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 = 10508 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 = 10502 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 = 10426 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 = 10420 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 = 10306 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 = 10300 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 = 10148 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 = 10142 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 = 10070 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 = 10064 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 = 9835 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 = 9829 AND pts.action = 1