Skip to content

Instantly share code, notes, and snippets.

@CatTrinket
Last active March 10, 2019 03:02
Show Gist options
  • Save CatTrinket/fac192e382f4727cdfaa to your computer and use it in GitHub Desktop.
Save CatTrinket/fac192e382f4727cdfaa to your computer and use it in GitHub Desktop.
stuff that can't hit Shedinja in ASB
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
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
wimpod
pyukumuku
cosmog
cosmoem
(79 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment