Advertisement
Kalashnikov

Untitled

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