Advertisement
Kalashnikov

Untitled

Jun 21st, 2011
426
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.27 KB | None
  1. SELECT name
  2. FROM pokemon AS this
  3. WHERE EXISTS (
  4.     SELECT DISTINCT pokemon_id
  5.     FROM pokemon_moves
  6.     JOIN pokemon ON pokemon_id = pokemon.id
  7.     WHERE evolution_chain_id = this.evolution_chain_id
  8.     AND canevolve =1
  9.     AND pokemon.order <= this.order
  10.     AND move_id =92
  11.     LIMIT 1
  12. );
Advertisement
RAW Paste Data Copied
Advertisement