Advertisement
GenuineSounds

Untitled

Aug 4th, 2016
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.22 KB | None | 0 0
  1. select  distinct spawnpoint_id, count(distinct pokemon_id) as unique_pokemon, count(*) as spawn_count, latitude, longitude from pokemon where pokemon_id not in (16, 19, 46, 133, 48) group by spawnpoint_id order by 3 desc;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement