Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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