Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT name
- FROM pokemon AS this
- WHERE EXISTS (
- SELECT DISTINCT pokemon_id
- FROM pokemon_moves
- WHERE move_id =420
- AND pokemon_id
- IN (
- SELECT pokemon.id
- FROM pokemon
- WHERE evolution_chain_id = this.evolution_chain_id
- AND pokemon.order <= this.order
- )
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement