Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT this.name
- FROM pokemon AS this
- INNER JOIN pokemon_evolution AS topstage ON this.id = topstage.to_pokemon_id
- INNER JOIN pokemon_moves ON (
- pokemon_moves.pokemon_id = this.id
- OR pokemon_moves.pokemon_id = topstage.from_pokemon_id
- OR pokemon_moves.pokemon_id = (
- SELECT from_pokemon_id
- FROM pokemon_evolution
- WHERE to_pokemon_id = topstage.from_pokemon_id
- LIMIT 1
- )
- )
- WHERE pokemon_moves.move_id =434;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement