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

Aeodyn

Posted September 11, 2020

- Share

Posted September 11, 2020

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

Reveal hidden contents

SQL code, to use on the sqlite file:

Reveal hidden contents

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

Quote

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.

Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.

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.

Followers 1

Sign In

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

Recommended Posts

Aeodyn

Link to comment

Share on other sites

Join the conversation

Recently Browsing 0 members

Home

Activity

Reborn

Desolation

Rejuvenation

Starlight Divide