(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 = 280 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 = 10267 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 = 10815 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 = 10259 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 = 10251 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 = 10241 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 = 10232 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 = 10566 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 = 10223 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 = 10216 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 = 10209 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 = 10405 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 = 10195 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 = 9442 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 = 10161 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 = 9428 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 = 9421 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 = 9414 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 = 9407 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 = 9400 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 = 9393 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 = 9385 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 = 9377 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 = 9368 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 = 9361 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 = 9324 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 = 9268 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 = 9261 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 = 9253 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 = 6887 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 = 6366 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 = 6755 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 = 6359 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 = 6352 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 = 6345 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 = 6338 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 = 6330 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 = 6324 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 = 6310 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 = 6304 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 = 6272 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 = 6120 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 = 6114 AND pts.action = 1