AltiLadder (Aki's bot) status info

SELECT end_time
FROM matches
WHERE game_mode='tbd_5v5'
ORDER BY start_time DESC
LIMIT 1;

SELECT end_time
FROM matches
WHERE game_mode='ball_6v6'
ORDER BY start_time DESC
LIMIT 1;

SELECT game_mode, COUNT(*)
FROM matches
WHERE matches.start_time > DATE_ADD(CURDATE(), INTERVAL -1 DAY) AND matches.end_time < CURDATE()
GROUP BY game_mode
ORDER BY 1;

SELECT m.game_mode, COUNT(DISTINCT pm.vaporid)
FROM player_matches pm JOIN matches m ON m.match_id = pm.match_id
WHERE m.start_time > DATE_ADD(CURDATE(), INTERVAL -2 DAY) and
m.start_time < DATE_ADD(CURDATE(), INTERVAL -1 DAY)
GROUP BY 1
ORDER BY 1;

SELECT rhNow.game_mode, SUM(rhNow.rating-rhThen.rating) FROM ranks_history rhNow JOIN
ranks_history rhThen ON rhNow.vaporid = rhThen.vaporid AND rhNow.game_mode = rhThen.game_mode
WHERE rhThen.date = DATE_ADD(CURDATE(), INTERVAL -2 DAY) and
rhNow.date = DATE_ADD(CURDATE(), INTERVAL -1 DAY)
GROUP BY 1
ORDER BY 1;