Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- asb_test=> select identifier from pokemon_forms pf where not exists (select 1 from pokemon_form_moves pfm join moves m on pfm.move_id=m.id join types t on m.type_id=t.id where pfm.pokemon_form_id=pf.id and m.damage_class_id != 3 and t.identifier in ('dark', 'fire', 'flying', 'ghost', 'rock')) order by "order";
- identifier
- -------------------
- caterpie
- metapod
- weedle
- kakuna
- oddish
- ditto
- sunkern
- sunflora
- unown-a
- unown-b
- unown-c
- unown-d
- unown-e
- unown-f
- unown-g
- unown-h
- unown-i
- unown-j
- unown-k
- unown-l
- unown-m
- unown-n
- unown-o
- unown-p
- unown-q
- unown-r
- unown-s
- unown-t
- unown-u
- unown-v
- unown-w
- unown-x
- unown-y
- unown-z
- unown-exclamation
- unown-question
- wynaut
- wobbuffet
- smeargle
- wurmple
- silcoon
- cascoon
- shroomish
- feebas
- milotic
- clamperl
- beldum
- kricketot
- burmy-plant
- burmy-sandy
- burmy-trash
- petilil
- lilligant
- klink
- klang
- klinklang
- tynamo
- scatterbug
- spewpa
- flabebe-red
- flabebe-yellow
- flabebe-orange
- flabebe-blue
- flabebe-white
- floette-red
- floette-yellow
- floette-orange
- floette-blue
- floette-white
- florges-red
- florges-yellow
- florges-orange
- florges-blue
- florges-white
- spritzee
- aromatisse
- (76 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement