0.0020 |
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` = '434' 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` = '434' AND `r`.`name` = 'total'
|