| 0.0122 |
select
games.game_id GameID,
games.game_description GameDescription,
games.game_name GameName,
games.game_image GameImage,
games.game_image_small GameImageSmall,
games.game_link GameLink,
games.application_key ApplicationKey,
games.application_secret ApplicationSecret,
developers.publisher_name PublisherName
from
games
inner join developers on developers.user_id = games.publisher_user_id
where
1 = 1
and games.game_id = 76
|
| 0.0007 |
select
leaderboard_id,
leaderboards.score_criteria,
show_top,
format_prefix,
format_thousands,
format_decimal,
format_precision,
format_suffix
from
leaderboards
inner join games on games.game_id = leaderboards.game_id
where
leaderboard_key = 'Global' and
games.game_id = 76
|
| 0.0040 |
select
users.user_id UserID,
users.username Username,
users.birth_date BirthDate,
users.email_address EmailAddress,
users.gender_id GenderID,
users.country_id CountryID,
users.postal_code PostalCode,
users.unique_identifier UniqueIdentifier,
users.last_login LastLogin,
users.last_action LastAction,
users.last_game_id LastGameID,
users.is_online IsOnline,
profiles.website Website,
profiles.about_text AboutText,
profiles.avatar_image AvatarImage,
profiles.avatar_image_small AvatarImageSmall,
profiles.avatar_image_small AvatarImageTiny,
profiles.display_age DisplayAge,
profiles.display_gender DisplayGender,
profiles.location Location,
games.game_id GameID,
games.game_name GameName,
games.game_image GameImage,
games.game_image_small GameImageSmall,
games.publisher_name PublisherName,
games.publisher_user_id PublisherID,
games.game_link GameLink,
scores.score Score,
scores.score_date ScoreDate
from
scores
inner join users on scores.user_id = users.user_id
inner join games on scores.game_id = games.game_id
left outer join profiles on users.user_id = profiles.user_id
where
games.game_id = 76 and
scores.leaderboard_id = 80 and
scores.identifier_tag = ''
order by
scores.score desc,
scores.score_date desc
limit 0, 10
|
