Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- - #rank (user's position in the leaderboard)
- - user_fk
- - won games count
- - lost games count
- - #rank (user's position in the leaderboard)
- - user_fk
- - won games count
- - lost games count
- Select users ordered by number of won games DESC, lost games ASC,
- where date_created <= 24h AND againts = OpponentPlayer AND zone_id = ZONE LIMIT 250
- Select users ordered by XP DESC, won games DESC, lost games ASC
- where updated_at <= 90 days and zone_ID LIMIT 999
Add Comment
Please, Sign In to add comment