Advertisement
Kalashnikov

Untitled

Jun 23rd, 2011
256
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.43 KB | None | 0 0
  1. SELECT DISTINCT this.name
  2. FROM pokemon AS this
  3. INNER JOIN pokemon_evolution AS topstage ON this.id = topstage.to_pokemon_id
  4. INNER JOIN pokemon_moves ON (
  5.     pokemon_moves.pokemon_id = this.id
  6.     OR pokemon_moves.pokemon_id = topstage.from_pokemon_id
  7.     OR pokemon_moves.pokemon_id = (
  8.         SELECT from_pokemon_id
  9.         FROM pokemon_evolution
  10.         WHERE to_pokemon_id = topstage.from_pokemon_id
  11.         LIMIT 1
  12.     )
  13. )
  14. WHERE pokemon_moves.move_id =434;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement