SHARE
TWEET

Untitled

a guest Jul 19th, 2019 64 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select ps1.player_id, ps1.player_name, ps2.erep_day,
  2. (ps1.sky_hero - ps2.sky_hero) as sky_heroes,
  3. (ps1.battle_hero - ps2.battle_hero) as battle_heroes,
  4. (ps1.player_exp - ps2.player_exp) as experience_gained,
  5. (ps1.true_patriot - ps2.true_patriot) as true_patriots
  6. from player_stats ps1
  7. join player_stats ps2 on ps2.player_id = ps1.player_id and ps2.erep_day = (select max(erep_day) from player_stats) - 1
  8. where ps1.erep_day = (select max(erep_day) from player_stats)
  9. group by
  10. ps1.player_id,
  11. ps1.player_name,
  12. ps2.erep_day,
  13. ps1.sky_hero - ps2.sky_hero,
  14. ps1.battle_hero - ps2.battle_hero,
  15. ps1.player_exp - ps2.player_exp,
  16. ps1.true_patriot - ps2.true_patriot
  17. order by experience_gained desc;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top