Advertisement
Kalashnikov

Untitled

Jun 21st, 2011
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.26 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. WHERE move_id =420
  8. AND pokemon_id
  9. IN (
  10.  
  11. SELECT pokemon.id
  12. FROM pokemon
  13. WHERE evolution_chain_id = this.evolution_chain_id
  14. AND pokemon.order <= this.order
  15. )
  16. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement