Advertisement
Kalashnikov

Untitled

Jun 21st, 2011
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.27 KB | None | 0 0
  1. SELECT name
  2. FROM pokemon AS this
  3. WHERE EXISTS (
  4.     SELECT DISTINCT pokemon_id
  5.     FROM pokemon_moves
  6.     WHERE move_id =420
  7.     AND pokemon_id
  8.     IN (
  9.         SELECT pokemon.id
  10.         FROM pokemon
  11.         WHERE evolution_chain_id = this.evolution_chain_id
  12.         AND pokemon.order <= this.order
  13.     )
  14. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement