Jump to content

Unique type combinations, excluding Legendaries/Mythics/Ultra-beasts


Aeodyn

Recommended Posts

I had the thought of a run using only unique typings, and thanks to Veekun's database, I got a list:

Spoiler

Normal/Ground: Diggersby
Normal/Fire: Litleo
Normal/Water: Bibarel
Normal/Grass: Deerling
Normal/Electric: Helioptile
Normal/Dragon: Drampa
Normal/Dark: Alolan Rattata
Fighting/Flying: Hawlucha
Fighting/Poison: Croagunk
Fighting/Bug: Heracross
Fighting/Steel: Lucario
Fighting/Water: Poliwrath
Fighting/Ice: Crabominable
Fighting/Dragon: Hakamo-o
Flying/Poison: Zubat
Flying/Ground: Gligar
Flying/Steel: Skarmory
Flying/Ice: Delibird
Flying/Fairy: Togetic
Poison/Ghost: Gastly
Poison/Fire: Salandit
Poison/Dragon: Dragalge
Ground/Fire: Numel
Ground/Grass: Torterra
Ground/Electric: Stunfisk
Ground/Psychic: Baltoy
Ground/Ice: Swinub
Ground/Dark: Sandile
Rock/Fire: Magcargo
Rock/Grass: Lileep
Rock/Electric: Alolan Geodude
Rock/Ice: Amaura
Rock/Dragon: Tyrunt
Rock/Dark: Tyranitar
Rock/Fairy: Carbink
Bug/Ghost: Shedinja
Bug/Fire: Larvesta
Bug/Fairy: Cutiefly
Ghost/Steel: Honedge
Ghost/Water: Frillish
Ghost/Electric: Rotom
Ghost/Ice: Froslass
Ghost/Fairy: Mimikyu
Steel/Water: Empoleon
Steel/Grass: Ferroseed
Steel/Ice: Alolan Sandshrew
Steel/Dark: Pawniard
Fire/Electric: Heat Rotom
Water/Grass: Lotad
Water/Dragon: Kingdra
Grass/Electric: Mow Rotom -
Grass/Psychic: Exeggcute
Grass/Ice: Snover
Electric/Psychic: Alolan Raichu
Electric/Ice: Frost Rotom
Electric/Dragon: Mega Ampharos
Electric/Fairy: Dedenne
Psychic/Ice: Jynx
Psychic/Dark: Inkay
Ice/Dark: Sneasel
Ice/Fairy: Alolan Ninetales
Dragon/Dark: Deino
Dragon/Fairy: Mega Altaria

 

SQL code, to use on the sqlite file:

Spoiler

SELECT s.identifier, t1.identifier AS type_one, t2.identifier AS type_two  FROM (
	SELECT *, COUNT(evolution_chain_id) AS count FROM (
		SELECT evolution_chain_id,p.identifier, type1, type2 FROM pokemon_species AS s
		LEFT JOIN pokemon AS p ON p.species_id==s.id
		LEFT JOIN pokemon_type_pairs AS tp ON p.id==tp.pokemon_id
		LEFT JOIN pokemon_abilities AS a1 ON s.id==a1.pokemon_id
		LEFT JOIN abilities AS a2 ON a1.ability_id==a2.id
		WHERE NOT (s.is_legendary OR s.is_mythical)
			AND a2.identifier != "beast-boost"
			AND s.generation_id <= 7
		GROUP BY s.evolution_chain_id,type1,type2
	)
	GROUP BY MIN(type1,type2),MAX(type1,type2)
	) AS s
LEFT JOIN types AS t1 ON MIN(type1,type2)==t1.id
LEFT JOIN types AS t2 ON MAX(type1,type2)==t2.id
WHERE count<=1

 

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...