| 0.0031 |
SELECT `gs`.`grade`, count(*) as count
FROM `gamer_high_scores` as `ghs`
JOIN `song_charts` as `sc` ON `sc`.`id` = `ghs`.`song_chart_id`
JOIN `gamer_scores` as `gs` ON `gs`.`id` = `ghs`.`gamer_score_id`
WHERE (`sc`.`game_difficulty_id` = 3 or `sc`.`game_difficulty_id` = 10)
AND `sc`.`is_enabled` = 1
AND `ghs`.`private` = 0
AND `ghs`.`gamer_id` = '24869'
GROUP BY `gs`.`grade`
|
| 0.0019 |
SELECT `s`.`id` as `song_id`, `ghs`.`song_chart_id`, `s`.`title` as `title`, `s`.`artist`, `sc`.`difficulty`, `ghs`.`created_at` as `date`, `ghs`.`score`, `gs`.`flags`, `gs`.`perfect1`, `gs`.`perfect2`, `gs`.`early`, `gs`.`green`, `gs`.`yellow`, `gs`.`red`, `gs`.`late`, `gs`.`misses`, `gs`.`grade`, `s`.`game_song_id`, `sc`.`game_difficulty_id` as `difficulty_id`
FROM `gamer_high_scores` as `ghs`
JOIN `song_charts` as `sc` ON `sc`.`id` = `ghs`.`song_chart_id`
JOIN `songs` as `s` ON `sc`.`song_id` = `s`.`id`
JOIN `gamer_scores` as `gs` ON `ghs`.`gamer_score_id` = `gs`.`id`
WHERE (`sc`.`game_difficulty_id` = 3 or `sc`.`game_difficulty_id` = 10)
AND `sc`.`is_enabled` = 1
AND `sc`.`edit_key` IS NULL
AND `ghs`.`gamer_id` = '24869'
AND `ghs`.`private` = 0
|
| 0.0002 |
SELECT `id`, `first_name` as `first`, `last_name` as `last`, `username`, `country`, `picture_path`, `hex_color`, `r`.`rank` as `rank_points`
FROM `gamers` as `g`
JOIN `statmani_devel`.`ranking` as `r` ON `r`.`user_id` = `g`.`id`
WHERE `id` = '24869'
AND `r`.`name` = 'total'
|
| 3.6919 |
SELECT max(ghs.score) as score, `ghs`.`song_chart_id`, `s`.`id` as `song_id`, `sc`.`id` as `song_chart_id`, `s`.`title`, `s`.`artist`, `sc`.`game_difficulty_id` as `difficulty_id`
FROM `gamer_high_scores` as `ghs`
JOIN `song_charts` as `sc` ON `sc`.`id` = `ghs`.`song_chart_id`
JOIN `songs` as `s` ON `sc`.`song_id` = `s`.`id`
WHERE `sc`.`game_difficulty_id` = 3
AND `sc`.`is_enabled` = 1
AND `ghs`.`private` = 0
GROUP BY `ghs`.`song_chart_id`
|
