vorpal-buildbot
commented
12 months ago Exceeded slow_query limit (116.0 > 60.0) in mysql: ```
SELECT
d.id,
d.name AS original_name,
d.created_date,
d.updated_date,
SUM(CASE WHEN dm.games > IFNULL(odm.games, 0) THEN 1 ELSE 0 END) AS wins,
SUM(CASE WHEN dm.games < odm.games THEN 1 ELSE 0 END) AS losses,
SUM(CASE WHEN dm.games = odm.games THEN 1 ELSE 0 END) AS draws,
d.finish,
d.archetype_id,
d.url AS source_url,
d.competition_id,
c.name AS competition_name,
c.end_date AS competition_end_date,
c.top_n AS competition_top_n,
ct.name AS competition_type_name,
d.identifier,
LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS person,
p.id AS person_id,
p.banned,
p.discord_id,
d.decklist_hash,
d.retired,
d.reviewed,
s.name AS source_name,
IFNULL(a.name, '') AS archetype_name,
cache.normalized_name AS name,
cache.colors,
cache.colored_symbols,
cache.color_sort,
cache.legal_formats,
ROUND(cache.omw * 100, 2) AS omw,
season.season_id,
IFNULL(MAX(m.date), d.created_date) AS active_date-- MAX(q.changed_date) AS last_archetype_change FROM deck AS d -- LEFT JOIN -- deck_archetype_change AS q ON q.deck_id = d.id LEFT JOIN person AS p ON d.person_id = p.id LEFT JOIN source AS s ON d.source_id = s.id LEFT JOIN archetype AS a ON d.archetype_id = a.id
LEFT JOIN
competition AS c ON d.competition_id = c.id
LEFT JOIN
competition_series AS cs ON cs.id = c.competition_series_id
LEFT JOIN
competition_type AS ct ON ct.id = cs.competition_type_id
LEFT JOIN
deck_cache AS cache ON d.id = cache.deck_id
LEFT JOIN
deck_match AS dm ON d.id = dm.deck_id
LEFT JOIN
`match` AS m ON dm.match_id = m.id
LEFT JOIN
deck_match AS odm ON odm.deck_id <> d.id AND dm.match_id = odm.match_id
LEFT JOIN deck_cache AS season ON d.id = season.deck_id
WHERE
(d.id IN (SELECT deck_id FROM deck_card WHERE card IN ('Okiba Reckoner Raid', 'Scoured Barrens', 'Terastodon', 'Hope of Ghirapur', 'Ornithopter', 'Saffi Eriksdotter', 'Disfigure', 'Cleansing Nova', 'Commune with the Gods', 'Exquisite Firecraft', 'Hall of Oracles', 'Noxious Assault', 'Ancient Stirrings', 'Gurmag Swiftwing', 'Canyon Slough', 'Goblin Trashmaster', 'Ulcerate', 'Song-Mad Treachery', 'Vessel of Nascency', 'Tajic, Legion''s Edge', 'Tempest Djinn', 'Squirrel Nest', 'Verix Bladewing', 'Halo Scarab', 'Smuggler''s Copter', 'Sandwurm Convergence', 'Waterveil Cavern', 'Champion of the Parish', 'Winds of Rebuke', 'Sylvan Scrying', 'Firemind''s Research', 'Unburial Rites', 'Gatherer of Graces', 'Satyr Hoplite', 'Doomwake Giant', 'Blazing Rootwalla', 'Tangled Islet', 'Staunch Shieldmate', 'Geyadrone Dihada', 'Stratus Dancer', 'High Tide', 'Riddleform', 'Cabal Stronghold', 'Black Sun''s Zenith', 'Hypnotic Specter', 'Lingering Souls', 'Xathrid Necromancer', 'Skull Fracture', 'Experimental Augury', 'Child of Night', 'Traumatize', 'Greenseeker', 'Grim Haruspex', 'Firja''s Retribution', 'Obzedat, Ghost Council', 'Arc Trail', 'Mouth of Ronom', 'Galvanic Relay', 'Avacyn''s Pilgrim', 'Genesis Hydra', 'Angel of Serenity', 'Always Watching', 'Electrostatic Infantry', 'Valiant Rescuer', 'Tranquil Thicket', 'Oracle of Mul Daya', 'Nether Traitor', 'Wharf Infiltrator', 'Ravenous Squirrel', 'Yorvo, Lord of Garenbrig', 'Phyrexian Censor', 'Reflector Mage', 'Winged Portent', 'Nezahal, Primal Tide', 'Firebolt', 'Mausoleum Secrets', 'Renegade Tactics', 'Barrenton Medic', 'Vision Skeins', 'Harm''s Way', 'Fleetfoot Dancer', 'Alms of the Vein', 'Tomb Robber', 'Nightpack Ambusher', 'Cliffside Lookout', 'Eyes of the Wisent', 'Highland Lake', 'Roiling Regrowth', 'Baral''s Expertise', 'Wooded Ridgeline', 'Pianna, Nomad Captain', 'Gilded Lotus', 'Tempered Sliver', 'Chronomaton', 'Elvish Visionary', 'Mangara of Corondor', 'Lagonna-Band Trailblazer', 'Revoke Existence', 'Nine Lives', 'Wistful Thinking', 'Isshin, Two Heavens as One', 'Demon''s Disciple', 'Myrkul, Lord of Bones', 'Cerebral Vortex', 'Walking Bulwark', 'Reckless Waif', 'Ixidor, Reality Sculptor', 'Embodiment of Insight', 'Ambitious Assault', 'Fallaji Archaeologist', 'Kiora''s Follower', 'Bonesplitter', 'Kabira Takedown', 'Apostle of Purifying Light', 'Unmarked Grave', 'Temur Battle Rage', 'Witch''s Vengeance', 'Blazing Specter', 'Vindictive Flamestoker', 'Akoum Warrior', 'Archangel of Wrath', 'Boom // Bust', 'Elvish Archdruid', 'Shambling Vent', 'Glaring Spotlight', 'Brain Maggot', 'Goblin Dark-Dwellers', 'Animating Faerie', 'Hissing Quagmire', 'Chandra, Fire Artisan', 'Summary Dismissal', 'Gladecover Scout', 'Elite Arcanist', 'Raffine''s Informant', 'Lathliss, Dragon Queen', 'Woodland Cemetery', 'Foulmire Knight', 'Pilfering Imp', 'Wood Elves', 'Raffine''s Guidance', 'The Blackstaff of Waterdeep', 'Drannith Healer', 'Kavu Predator', 'Carrion Wall', 'Tournament Grounds', 'Thran Vigil', 'Glimpse of Tomorrow', 'Settle the Wreckage', 'Akki Ronin', 'Thraben Doomsayer', 'Curse of Chains', 'Tuktuk Rubblefort', 'Sky Terror', 'Jokulhaups', 'Compulsive Research', 'Sin Collector', 'Mortify', 'Empty the Warrens', 'Sleeper Dart', 'Demonic Bargain', 'Soul Snare', 'Kairi, the Swirling Sky', 'Rona''s Vortex', 'Twinferno', 'Steel Sabotage', 'Westvale Abbey', 'White Sun''s Twilight', 'Dawn of Hope', 'Taigam, Ojutai Master', 'Collateral Damage', 'Necrogen Mists', 'Stigma Lasher', 'Scathe Zombies', 'Mazemind Tome', 'Ray of Revelation', 'Falkenrath Aristocrat', 'Sickening Dreams', 'Putrid Leech', 'Midnight Clock', 'Mwonvuli Acid-Moss', 'Into the Story', 'Zombie Trailblazer', 'Memoricide', 'Gaea''s Will', 'Chatterstorm', 'Murderous Cut', 'Into the Wilds', 'Dusk Mangler', 'Undead Augur', 'Ossification', 'Doom Foretold', 'Plargg, Dean of Chaos', 'Artificer''s Assistant', 'Tarfire', 'Hero of Iroas', 'Frogtosser Banneret', 'Neutralize', 'Sky Scourer', 'Wheel of Fate', 'Lose Focus', 'Rhonas''s Last Stand', 'Cosima, God of the Voyage', 'Putrid Imp', 'Wanted Scoundrels', 'Buried Alive', 'Plague Beetle', 'Kolaghan, the Storm''s Fury', 'Joraga Warcaller', 'Eiganjo Castle', 'Life of Toshiro Umezawa', 'Ezuri, Renegade Leader', 'Demonic Dread', 'Doomskar', 'Improbable Alliance', 'Aphemia, the Cacophony', 'Ravenous Chupacabra', 'Atris, Oracle of Half-Truths', 'Ivory Tower', 'Planar Ally', 'Howlpack Piper', 'Sprouting Thrinax', 'Guardian Gladewalker', 'Izzet Boilerworks', 'Spell Pierce', 'Blood on the Snow', 'Ghalta, Primal Hunger', 'Blacksmith''s Skill', 'Barbed Batterfist', 'Eerie Interlude', 'Fast // Furious', 'Enter the Unknown', 'Ondu Inversion', 'Cloudsteel Kirin', 'Pillar of the Paruns', 'Ashen Rider', 'Harmonic Sliver', 'Quag Vampires', 'Flamekin Bladewhirl', 'Court Homunculus', 'Grim Affliction', 'Strategic Planning', 'Baird, Argivian Recruiter', 'Thopter Spy Network', 'Ghostly Flicker', 'Impostor of the Sixth Pride', 'Desperate Ritual', 'Dowsing Dagger', 'Sire of Insanity', 'Burning-Tree Emissary', 'Shivan Reef', 'Soul of the Harvest', 'Jund Hackblade', 'Mystic Snake', 'Codex Shredder', 'Rimrock Knight', 'Weakstone''s Subjugation', 'Exploding Borders', 'Midnight Reaper', 'Verdurous Gearhulk', 'Duskwatch Recruiter', 'Kitchen Finks', 'Mind Spring', 'Simic Charm', 'Empyrean Eagle', 'Sphinx''s Tutelage', 'Entrancing Melody', 'Sarkhan the Masterless', 'Spell Snuff', 'Kazuul''s Fury', 'Nephalia Academy', 'Demigod of Revenge', 'Adanto Vanguard', 'Ayli, Eternal Pilgrim', 'Elspeth Tirel', 'Goro-Goro, Disciple of Ryusei', 'Selfless Glyphweaver', 'Silverbluff Bridge', 'Jack-o''-Lantern', 'Zenith Flare', 'Boggart Ram-Gang', 'Howling Mine', 'Kami of Transience', 'Radiant Scrollwielder', 'Thassa''s Intervention', 'Nylea''s Disciple', 'Gateway Plaza', 'Obstinate Baloth', 'Fertilid', 'Illuminator Virtuoso', 'The Modern Age', 'Clear the Mind', 'Read the Bones', 'Entomber Exarch', 'Consul''s Lieutenant', 'Consuming Vapors', 'Slumbering Dragon', 'Clifftop Retreat', 'Zada''s Commando', 'Sai of the Shinobi', 'Pandemonium', 'Niv-Mizzet, the Firemind', 'Privileged Position', 'Chain Lightning', 'Myth Realized', 'Darksteel Relic', 'Eldrazi Conscription', 'Collective Effort', 'Tooth and Nail', 'Liliana Vess', 'Skymarcher Aspirant', 'Nishoba Brawler', 'Twincast', 'Choking Sands', 'Gruul Charm', 'Hammerhand', 'Gilt-Leaf Archdruid', 'Yavimaya Dryad', 'Goblin Charbelcher', 'Patch Up', 'Silent Gravestone', 'Hotshot Mechanic', 'Balustrade Spy', 'Relic Axe', 'Desolation Twin', 'Shardless Agent', 'Magister Sphinx', 'Pieces of the Puzzle', 'Frost Marsh', 'Narcomoeba', 'Jadelight Ranger', 'Ashen Ghoul', 'Glistener Elf', 'Sejiri Refuge', 'Guardian Seraph', 'Putrefax', 'Bant Charm', 'Incendiary Flow', 'Artful Dodge', 'Rishkar, Peema Renegade', 'Riveteers Overlook', 'Late to Dinner', 'Yisan, the Wanderer Bard', 'Dissolve', 'Cliffhaven Kitesail', 'Ponder', 'Bad River', 'Drowned Catacomb', 'Jukai Naturalist', 'Harmonic Prodigy', 'Curse of Exhaustion', 'Eternal Dragon', 'Opt', 'Goblin Electromancer', 'Phyrexia''s Core', 'Ajani''s Pridemate', 'Swiftwater Cliffs', 'Law-Rune Enforcer', 'Costly Plunder', 'Epiphany at the Drownyard', 'Vraska, Swarm''s Eminence', 'Blind Obedience', 'Cemetery Reaper', 'Aethermage''s Touch', 'Priest of Fell Rites', 'Ghitu Lavarunner', 'Blight Mamba', 'White Knight', 'Form of the Dragon', 'Threats Undetected', 'Rally the Ranks', 'Gatecreeper Vine', 'Shaman of the Pack', 'Bloodline Pretender', 'Skyshroud Ranger', 'Mystic of the Hidden Way', 'Ruins of Trokair', 'Recross the Paths', 'Tolarian Terror', 'Diabolic Tutor', 'Elspeth''s Nightmare', 'Rift Sower', 'Swooping Lookout', 'Sphinx of the Steel Wind', 'Infuriate', 'Vexing Devil', 'Spirit Mantle', 'Honor of the Pure', 'Karametra''s Blessing', 'Check for Traps', 'Terramorphic Expanse', 'Gonti, Lord of Luxury', 'Everflowing Chalice', 'Zirda, the Dawnwaker', 'Complicate', 'Call of the Herd', 'Venser, the Sojourner', 'Stormfist Crusader', 'Basilisk Collar', 'Reckless Reveler', 'Knight of Meadowgrain', 'Fecundity', 'Hall of the Bandit Lord', 'Blanchwood Armor', 'Boros Garrison', 'Yarok''s Fenlurker', 'Circular Logic', 'Obscuring Aether', 'Trail of Mystery', 'Shadow Prophecy', 'Oversoul of Dusk', 'Intervention Pact', 'Towashi Guide-Bot', 'Steppe Lynx', 'Drowner of Hope', 'Soul of New Phyrexia', 'Wind-Scarred Crag', 'Buried Ruin', 'Scorching Dragonfire', 'Cranial Extraction', 'Sidewinder Sliver', 'Waterfront District', 'Wilt-Leaf Liege', 'Giant Killer', 'Might of Old Krosa', 'Etherium Sculptor', 'Dinrova Horror', 'Mirri the Cursed', 'Wort, Boggart Auntie', 'Icehide Golem', 'Sylvan Primordial', 'Cloudblazer', 'Dovin Baan', 'Kor Firewalker', 'Anticipate', 'Countersquall', 'Sigarda''s Splendor', 'Vizier of Many Faces', 'Arcum''s Astrolabe', 'Kari Zev, Skyship Raider', 'Rhys the Redeemed', 'Sootstoke Kindler', 'Deprive', 'Wicked Wolf', 'Memorial to War', 'Upheaval', 'Grasp of Darkness', 'Jarad''s Orders', 'Stromkirk Noble', 'God-Pharaoh''s Gift', 'Tamiyo''s Safekeeping', 'Omen of the Hunt', 'Filigree Familiar', 'Polymorph', 'Crucible of Worlds', 'Calciform Pools', 'Silverquill Silencer', 'Lantern of the Lost', 'Restore Balance', 'Karn''s Bastion', 'Wolfbriar Elemental', 'Damn', 'Universal Automaton', 'Dwynen, Gilt-Leaf Daen', 'Necrotic Ooze', 'Mothdust Changeling', 'Thorn of Amethyst', 'Barrowin of Clan Undurr', 'Siege-Gang Commander', 'Tezzeret, Artifice Master', 'Blessed Respite', 'Never // Return', 'Strength of Lunacy', 'Enclave Cryptologist', 'Coiling Oracle', 'Game Trail', 'Elvish Pioneer', 'Runeflare Trap', 'Lightning Rift', 'Thunderous Wrath', 'Borderland Marauder', 'Haunted Plate Mail', 'Rewind', 'Kessig Wolf Run', 'Treasure Cruise', 'Crashing Drawbridge', 'Curse of Silence', 'Lucky Clover', 'Primal Order', 'Spell Burst', 'Eidolon of Countless Battles', 'Ajani Unyielding', 'Autonomous Assembler', 'Calamity Bearer', 'Soldier of the Pantheon', 'Alabaster Host Intercessor', 'Molten Monstrosity', 'Skyclave Pick-Axe', 'Stone Rain', 'Faith''s Reward', 'Easy Prey', 'Tyrant''s Choice', 'Mystifying Maze', 'Eldrazi Obligator', 'Faerie Vandal', 'Bow of Nylea', 'Pulse of Murasa', 'Kessig Wolfrider', 'Glassdust Hulk', 'Spoils of the Vault', 'Stoic Rebuttal', 'Grand Abolisher', 'Raging Ravine', 'Sejiri Shelter', 'Aviary Mechanic', 'Falkenrath Pit Fighter', 'General Ferrous Rokiric', 'Attune with Aether', 'Mana Flare', 'Blood Seeker', 'Pelt Collector', 'Dread Statuary', 'Wavebreak Hippocamp', 'Collected Conjuring', 'Skaab Ruinator', 'Vessel of Volatility', 'Cloudshift', 'Bone Saw', 'Talus Paladin', 'Prosperous Thief', 'Tireless Provisioner', 'Expedition Envoy', 'Regal Force', 'Bosh, Iron Golem', 'Zuran Orb', 'Bogardan Hellkite', 'Bronzehide Lion', 'Scrapwork Mutt', 'Razortide Bridge', 'Combat Thresher', 'Pulling Teeth', 'Violent Ultimatum', 'Phyrexian Rager', 'Time Sieve', 'The Celestus', 'Abundant Harvest', 'Silverquill Command', 'Deceiver of Form', 'Emmara, Soul of the Accord', 'Triumph of Ferocity', 'Paladin en-Vec', 'Foundry Street Denizen', 'Aetherworks Marvel', 'End-Raze Forerunners', 'Glacial Fortress', 'Molten Slagheap', 'Phyrexian Arena', 'Siren of the Silent Song', 'Fetid Pools', 'Proclamation of Rebirth', 'Vraska, Relic Seeker', 'Mishra''s Factory', 'Viashino Pyromancer', 'Chandra, Fire of Kaladesh', 'Awakened Amalgam', 'Graf Harvest', 'Desperate Ravings', 'Solitary Confinement', 'Delver''s Torch', 'Serum Snare', 'Oni-Cult Anvil', 'Firebrand Archer', 'Wayfaring Temple', 'Grafted Wargear', 'Memory''s Journey', 'Idyllic Grange', 'Gyruda, Doom of Depths', 'Bontu''s Last Reckoning', 'Changeling Outcast', 'Vault of the Archangel', 'Zulaport Cutthroat', 'Stern Lesson', 'Bloodwater Entity', 'Golgari Grave-Troll', 'Pirate''s Pillage', 'Maelstrom Pulse', 'Pack Rat', 'Flourishing Fox', 'High-Speed Hoverbike', 'Quickling', 'Artisan of Kozilek', 'Barrin, Tolarian Archmage', 'Council''s Judgment', 'Story Circle', 'Thief of Sanity', 'Knight of the Holy Nimbus', 'Prophetic Prism', 'Rampaging Ferocidon', 'Thieving Skydiver', 'Obscura Storefront', 'Augur of Bolas', 'Rosethorn Acolyte', 'Bloodline Keeper', 'Withered Wretch', 'Scute Mob', 'Spore Frog', 'Sin Prodder', 'Heartfire Immolator', 'Raven''s Crime', 'Hedron Archive', 'Master of Etherium', 'Invisible Stalker', 'Eater of Virtue', 'Fumigate', 'Sprite Dragon', 'Kalonian Behemoth', 'Braid of Fire', 'Curse of Misfortunes', 'Ionize', 'Reap and Sow', 'Phyrexian Hulk', 'Lord of the Undead', 'Infernal Plunge', 'Jace, Cunning Castaway', 'Orzhov Pontiff', 'Student of Warfare', 'Khalni Ambush', 'Unholy Heat', 'Price of Progress', 'Tithe Taker', 'Fleecemane Lion', 'Mind Sculpt', 'Jace, the Living Guildpact', 'Acquisitions Expert', 'Battle for Bretagard', 'Quirion Beastcaller', 'Starlit Sanctum', 'Ranger''s Guile', 'Grapple with the Past', 'Endless Horizons', 'Necrogen Spellbomb', 'Suffocating Fumes', 'Prologue to Phyresis', 'Keep Safe', 'Elspeth''s Smite', 'Tragic Poet', 'Temple of Mystery', 'Terrarion', 'Fraying Sanity', 'Staff of Domination', 'Hypnotic Sprite', 'Llanowar Loamspeaker', 'Arbor Elf', 'Seal of Cleansing', 'Possibility Storm', 'Kederekt Leviathan', 'Yidaro, Wandering Monster', 'Discovery // Dispersal', 'Marwyn, the Nurturer', 'Frontline Medic', 'Kazandu Blademaster', 'Ruin Raider', 'Rakdos Charm', 'Inventive Iteration', 'Hokori, Dust Drinker', 'Seekers'' Squire', 'Serrated Scorpion', 'Terminal Agony', 'Disallow', 'Destroy Evil', 'Megrim', 'Servo Exhibition', 'Akoum Hellhound', 'Experiment One', 'Captain''s Claws', 'Port Town', 'Biovisionary', 'Imperious Perfect', 'Drizzt Do''Urden', 'Bloodfire Dwarf', 'Simian Spirit Guide', 'Tamiyo, Field Researcher', 'Izzet Staticaster', 'Implement of Improvement', 'Bag of Holding', 'Debt to the Kami', 'Skyclave Shade', 'Vivien, Champion of the Wilds', 'Hazoret''s Undying Fury', 'Cover of Winter', 'Sarkhan, the Dragonspeaker', 'Platinum Angel', 'Strangleroot Geist', 'Growth-Chamber Guardian', 'Fiend Hunter', 'Foreboding Ruins', 'Riftsweeper', 'Halana and Alena, Partners', 'Detention Sphere', 'Spawning Pit', 'Wrath of God', 'Undercover Operative', 'Krovikan Mist', 'Invasion of Mercadia', 'Asylum Visitor', 'Lumengrid Sentinel', 'Sphere of the Suns', 'Mist-Cloaked Herald', 'Talisman of Resilience', 'Memory Leak', 'Reason // Believe', 'Vindicate', 'Stenn, Paranoid Partisan', 'Banishing Slash', 'Spellheart Chimera', 'Scrap Trawler', 'Impulse', 'Haze of Rage', 'Dakmor Salvage', 'Voidmage Prodigy', 'Codie, Vociferous Codex', 'Liliana''s Specter', 'Recruitment Officer', 'Kitchen Imp', 'Polukranos, World Eater', 'Primeval Bounty', 'Dive Down', 'Blighted Woodland', 'Coldsteel Heart', 'Snapback', 'Blisterpod', 'Crystal Grotto', 'Bramblewood Paragon', 'Second Wind', 'Champion of Wits', 'Gideon, Champion of Justice', 'Bone Shards', 'Diregraf Colossus', 'Garruk''s Companion', 'Goblin Arsonist', 'Banefire', 'Gryff''s Boon', 'Darkmoss Bridge', 'Wretched Banquet', 'Knight of New Alara', 'Ashenmoor Liege', 'Ensoul Artifact', 'Heliod''s Pilgrim', 'Sunscorched Desert', 'Obliterate', 'Cabal Therapist', 'Deep Analysis', 'Encroaching Wastes', 'Sword of the Meek', 'Silver Scrutiny', 'Obscura Interceptor', 'Venerable Knight', 'Bloodrite Invoker', 'Labyrinth of Skophos', 'Feather, the Redeemed', 'Malakir Rebirth', 'Llanowar Visionary', 'Goreclaw, Terror of Qal Sisma', 'Tectonic Reformation', 'Incinerate', 'Makeshift Munitions', 'Expedite', 'Outlaws'' Merriment', 'Annex Sentry', 'Smiting Helix', 'Rakdos Cackler', 'Lodestone Golem', 'Shambling Shell', 'Seismic Assault', 'Sticky Fingers', 'Linvala, the Preserver', 'Soul Warden', 'Forbid', 'Spectral Shift', 'Dread Return', 'Blacklance Paragon', 'Benevolent Bodyguard', 'Of One Mind', 'Towashi Songshaper', 'Lupine Prototype', 'Seasons Past', 'Reliquary Tower', 'Sorin, Vengeful Bloodlord', 'Demanding Dragon', 'Grave Scrabbler', 'Disrupting Shoal', 'Lightning Strike', 'Cordial Vampire', 'Mindcrank', 'Archangel Avacyn', 'Profane Command', 'Molten Blast', 'Zhur-Taa Goblin', 'Obsidian Battle-Axe', 'Visions of Phyrexia', 'Miasmic Mummy', 'Shinka, the Bloodsoaked Keep', 'Bladehold War-Whip', 'Mastermind''s Acquisition', 'Arcane Sanctum', 'Disciple of Deceit', 'Chamber Sentry', 'Pyromancer Ascension', 'Tezzeret''s Gambit', 'Invoke the Ancients', 'Vona, Butcher of Magan', 'Eldrazi Displacer', 'Chitterspitter', 'Scrabbling Claws', 'Sram''s Expertise', 'Tectonic Edge', 'Endbringer', 'Oviya Pashiri, Sage Lifecrafter', 'Forsake the Worldly', 'Mystic Reflection', 'Dread Wanderer', 'Biting-Palm Ninja', 'Skyshroud Elf', 'Darkblast', 'Evolving Adaptive', 'Twinflame', 'Sea Gate Oracle', 'Sojourner''s Companion', 'Retreat to Coralhelm', 'Sen Triplets', 'Legion''s Initiative', 'Anafenza, the Foremost', 'Flayer of the Hatebound', 'Lord of the Unreal', 'Bident of Thassa', 'Dream Trawler', 'Jadar, Ghoulcaller of Nephalia', 'Blazing Archon', 'Dungrove Elder', 'Firedrinker Satyr', 'Koth, Fire of Resistance', 'Spiritual Visit', 'Umara Mystic', 'Caldera Lake', 'Children of Korlis', 'Plated Onslaught', 'Harsh Mentor', 'Lavaball Trap', 'Meticulous Excavation', 'Loxodon Warhammer', 'Flow of Knowledge', 'Titania, Protector of Argoth', 'Angel of Despair', 'Groundswell', 'Web of Inertia', 'Tyrant of Kher Ridges', 'Angel of Sanctions', 'Wrench Mind', 'Secret Plans', 'Anax, Hardened in the Forge', 'Captivating Vampire', 'Venerable Monk', 'Deathgorge Scavenger', 'Scrapheap Scrounger', 'Scurry Oak', 'Defiler of Instinct', 'Jace, Memory Adept', 'Aria of Flame', 'Firewild Borderpost', 'Blast-Furnace Hellkite', 'Wrenn''s Resolve', 'Depala, Pilot Exemplar', 'Legion Lieutenant', 'Dauntless Bodyguard', 'Blightning', 'Shimmer of Possibility', 'Farmstead Gleaner', 'Shared Discovery', 'Commune with Spirits', 'Secure the Wastes', 'Magma Spray', 'Ajani Goldmane', 'Judith, the Scourge Diva', 'Flametongue Kavu', 'Colossal Skyturtle', 'Conspiracy Theorist', 'Scarab Feast', 'Okina, Temple to the Grandfathers', 'Sawblade Scamp', 'Roadside Reliquary', 'Foundation Breaker', 'Bala Ged Recovery', 'Malicious Malfunction', 'Palinchron', 'Mana Leak', 'Greater Tanuki', 'Grim Lavamancer', 'Blessed Alliance', 'Balefire Liege', 'Merfolk Windrobber', 'Victim of Night', 'Ancestor''s Chosen', 'Nylea''s Presence', 'Goblin Ruinblaster', 'Llanowar Wastes', 'Irencrag Pyromancer', 'Ral, Izzet Viceroy', 'Tempered in Solitude', 'Angel of Grace', 'Queen of Ice', 'Reaper King', 'Dark Ritual', 'Acidic Slime', 'Muddle the Mixture', 'Cursed Scroll', 'Raise the Alarm', 'Step Through', 'Flame Javelin', 'Frontier Bivouac', 'Deadeye Navigator', 'Weapons Trainer', 'Revitalize', 'Drowned Secrets', 'Thirst for Knowledge', 'Carnival // Carnage', 'Cystbearer', 'Avacyn''s Judgment', 'Knight Exemplar', 'Driven // Despair', 'Blazing Shoal', 'Mikokoro, Center of the Sea', 'Kor Duelist', 'Earwig Squad', 'Otherworldly Journey', 'Divest', 'Tempered Steel', 'Haunted Mire', 'Mirror Entity', 'Hanweir Garrison', 'Volt Charge', 'Astral Cornucopia', 'Persecute', 'Wildborn Preserver', 'Power Depot', 'Yahenni, Undying Partisan', 'Rune-Scarred Demon', 'Contagion Clasp', 'Ivy Lane Denizen', 'Stormchaser Mage', 'Riptide Laboratory', 'Ranger of Eos', 'Archetype of Endurance', 'Gnawing Vermin', 'Identity Crisis', 'Chief of the Foundry', 'Rakdos Headliner', 'Patchwork Automaton', 'Lesser Masticore', 'Bond of Insight', 'Light the Way', 'Zurgo Bellstriker', 'Wanderwine Hub', 'Witching Well', 'Warstorm Surge', 'Leechridden Swamp', 'Blackblade Reforged', 'Giant Growth', 'Idyllic Tutor', 'Fact or Fiction', 'Prismatic Lens', 'Prismatic Omen', 'Drift of Phantasms', 'Angel of Condemnation', 'Animate Dead', 'Thundermaw Hellkite', 'Invasion of Ergamon', 'Remorseful Cleric', 'Dismal Backwater', 'Tragic Slip', 'Blistercoil Weird', 'Goblin Piledriver', 'Obliterating Bolt', 'Blade of the Bloodchief', 'Lightning Axe', 'Aetherspouts', 'Repeal', 'Vampire Lacerator', 'Llanowar Augur', 'Jace, Architect of Thought', 'Celestial Flare', 'Savvy Hunter', 'Guild Globe', 'Longbow Archer', 'Recruit the Worthy', 'Merfolk Looter', 'Veinfire Borderpost', 'Winds of Abandon', 'Reinforced Ronin', 'Hadana''s Climb', 'Bushwhack', 'Curse of Thirst', 'Thopter Foundry', 'Anger of the Gods', 'Krosan Wayfarer', 'Glint-Sleeve Siphoner', 'Slitherhead', 'Grapeshot', 'Waking the Trolls', 'Rakdos Ragemutt', 'Morselhoarder', 'Consecrate // Consume', 'Sunlit Marsh', 'Voidwing Hybrid', 'Renewed Faith', 'Urban Evolution', 'Eruth, Tormented Prophet', 'The Underworld Cookbook', 'Cry of Contrition', 'Seal of Fire', 'Necrogoyf', 'Scryb Ranger', 'Voidslime', 'Martyr of Sands', 'Braids, Cabal Minion', 'Become Immense', 'Coalition Relic', 'Grand Arbiter Augustin IV', 'Argentum Armor', 'Wild Mongrel', 'Loxodon Hierarch', 'Elves of Deep Shadow', 'Pillar of Flame', 'Rustvale Bridge', 'Master of the Wild Hunt', 'Deep Forest Hermit', 'Force of Rage', 'Boreal Shelf', 'Cleansing Wildfire', 'Liege of the Tangle', 'Wildfield Borderpost', 'Void', 'Deny Reality', 'Bitter Reunion', 'Seed of Hope', 'Rotting Rats', 'Temple of the Dragon Queen', 'Goblin Cohort', 'Deafening Clarion', 'Inevitable Betrayal', 'Runed Halo', 'Elvish Rejuvenator', 'Trostani, Selesnya''s Voice', 'Fabricate', 'Sylvan Anthem', 'Blighted Steppe', 'Nivmagus Elemental', 'Death Baron', 'Figure of Destiny', 'Overrun', 'Creakwood Liege', 'Warden of the First Tree', 'Akroma''s Memorial', 'Rally the Peasants', 'Sanitarium Skeleton', 'Azami, Lady of Scrolls', 'Squee, Goblin Nabob', 'Phantasmagorian', 'Quest for Ula''s Temple', 'Sarkhan the Mad', 'Force of Virtue', 'Cruel Bargain', 'Golden Egg', 'Murkfiend Liege', 'Gaea''s Blessing', 'Flame Blitz', 'Cerulean Wisps', 'Assault Strobe', 'Reverent Hunter', 'Temur War Shaman', 'Vector Asp', 'Ground Seal', 'Enter the God-Eternals', 'Silence', 'Swiftblade Vindicator', 'Pick the Brain', 'Glamerdye', 'Conduit of Ruin', 'Shadow of Mortality', 'Quest for the Holy Relic', 'Lonely Sandbar', 'Slaughter Games', 'Mystic Retrieval', 'Ashes of the Abhorrent', 'Memnarch', 'Lashwrithe', 'Charge of the Mites', 'Glaring Aegis', 'Silent Departure', 'Imposing Sovereign', 'Helm of Kaldra', 'Dragon''s Disciple', 'Satyr Wayfinder', 'The Cruelty of Gix', 'Sphinx of Uthuun', 'Archon of Sun''s Grace', 'Imposing Vantasaur', 'Orcish Lumberjack', 'Rampant Growth', 'Destiny Spinner', 'Vryn Wingmare', 'Trinket Mage', 'Vivid Grove', 'Sylvan Ranger', 'Obsidian Charmaw', 'Lotleth Giant', 'Season of Growth', 'Bubbling Muck', 'Ichorid', 'Grove of the Guardian', 'Gather the Pack', 'Kjeldoran Outpost', 'Myr Servitor', 'Axebane Guardian', 'Nezumi Cutthroat', 'Leyline of Lifeforce', 'Kalonian Twingrove', 'Sultai Charm', 'Grasping Scoundrel', 'Tasigur, the Golden Fang', 'Boros Signet', 'Sudden Edict', 'Sulfuric Vortex', 'Gingerbrute', 'Extraplanar Lens', 'Tendrils of Agony', 'Bygone Bishop', 'Lay Down Arms', 'Knight of the White Orchid', 'Second Sunrise', 'Isolate', 'Nest Robber', 'Nobilis of War', 'Incendiary Command', 'Mirari''s Wake', 'Darksteel Colossus', 'Sarulf, Realm Eater', 'Reckless Charge', 'Shigeki, Jukai Visionary', 'Conqueror''s Galleon', 'Sinew Sliver', 'March of Burgeoning Life', 'Mathas, Fiend Seeker', 'Basilica Bell-Haunt', 'Blazing Hellhound', 'Samut, Tyrant Smasher', 'Horrifying Revelation', 'Ruthless Ripper', 'Oran-Rief Ooze', 'Experimental Frenzy', 'Teferi, Mage of Zhalfir', 'Startling Development', 'Wrexial, the Risen Deep', 'Omen of the Sea', 'Rakdos Guildgate', 'Striped Riverwinder', 'Hellkite Overlord', 'Ghost Quarter', 'Beckon Apparition', 'Karn, Silver Golem', 'Monoskelion', 'Training Grounds', 'Engulf the Shore', 'Windbrisk Heights', 'Feasting Troll King', 'Contaminated Aquifer', 'Regrowth', 'Vitu-Ghazi, the City-Tree', 'Bitter Ordeal', 'Thopter Mechanic', 'Haunted Dead', 'Army of the Damned', 'Izzet Guildgate', 'Rain of Revelation', 'Ancient Grudge', 'Stern Dismissal', 'Silvergill Adept', 'Goblin Chieftain', 'Peek', 'Slip Out the Back', 'Sunscour', 'Dispel', 'Choked Estuary', 'Chained to the Rocks', 'Reforge the Soul', 'Embodiment of Fury', 'Champion of the Flame', 'Yotian Frontliner', 'Zof Consumption', 'Joint Exploration', 'Primal Might', 'Myr Superion', 'Rune of Might', 'Radiant Grove', 'Ulvenwald Tracker', 'Distress', 'Protean Hulk', 'Phantasmal Image', 'Rebel Salvo', 'Maddening Cacophony', 'Windcaller Aven', 'Gruul Signet', 'Tomb of Urami', 'Plunge into Darkness', 'Faldorn, Dread Wolf Herald', 'Mishra''s Research Desk', 'Serra Ascendant', 'Temple of Plenty', 'Mortarpod', 'Cerodon Yearling', 'Cultivate', 'Maestros Theater', 'Clout of the Dominus', 'Lavinia of the Tenth', 'Research // Development', 'Bloodsoaked Champion', 'Control Magic', 'Benalish Marshal', 'Selvala, Explorer Returned', 'Leonin Relic-Warder', 'Tear Asunder', 'Forbidden Friendship', 'Wild Nacatl', 'Elvish Hexhunter', 'Mistcutter Hydra', 'Tidehollow Sculler', 'Leatherback Baloth', 'Breakthrough', 'Varis, Silverymoon Ranger', 'Augur of Skulls', 'Fiery Justice', 'Generous Patron', 'Shimmerdrift Vale', 'Unsubstantiate', 'Night of Souls'' Betrayal', 'Arasta of the Endless Web', 'Double Vision', 'Akoum Hellkite', 'Qasali Ambusher', 'Shield of Kaldra', 'Samut, the Tested', 'Chandra, Pyromaster', 'Maestros Ascendancy', 'Scour All Possibilities', 'Planebound Accomplice', 'Unstable Mutation', 'Blanchwood Prowler', 'Archfiend of Ifnir', 'Howltooth Hollow', 'Spawning Breath', 'Halimar Excavator', 'Glissa Sunseeker', 'Ertai''s Scorn', 'Rally the Ancestors', 'Thornwood Falls', 'Union of the Third Path', 'Sapseep Forest', 'Shadow-Rite Priest', 'Wastes', 'Disenchant', 'All That Glitters', 'Phylactery Lich', 'Hyena Umbra', 'Increasing Savagery', 'Titania''s Command', 'Sorin Markov', 'Cling to Dust', 'Moment of Craving', 'Frostveil Ambush', 'Trading Post', 'Glittering Wish', 'Smallpox', 'Skeletal Swarming', 'Scrying Sheets', 'Path of Discovery', 'Last-Ditch Effort', 'Sorin, Grim Nemesis', 'Thraben Inspector', 'Edge of Autumn', 'Thalia''s Lancers', 'Tishana, Voice of Thunder', 'Serra Avenger', 'Brute Suit', 'Kaho, Minamo Historian', 'Cutthroat Contender', 'Collective Defiance', 'Frantic Search', 'Drakuseth, Maw of Flames', 'Lazotep Chancellor', 'Merfolk Mistbinder', 'Guardian Idol', 'Hour of Promise', 'Viral Drake', 'Chandra, Flamecaller', 'Simian Sling', 'Silent Arbiter', 'Arcbound Shikari', 'Nantuko Cultivator', 'Rebuild', 'Scab-Clan Berserker', 'Wilt', 'Frantic Inventory', 'Gray Merchant of Asphodel', 'Shredded Sails', 'Perilous Vault', 'Cut Down', 'Rabbit Battery', 'Yavimaya Coast', 'Baffling End', 'Bloodbraid Elf', 'Field Marshal', 'Containment Construct', 'Caldera Hellion', 'Bring to Light', 'Moon-Circuit Hacker', 'Rust Goliath', 'Spatial Contortion', 'Almighty Brushwagg', 'Hopeful Eidolon', 'Ajani, Mentor of Heroes', 'The Lady of Otaria', 'Wayward Swordtooth', 'Boon-Bringer Valkyrie', 'Dreamstealer', 'Smoldering Marsh', 'Mulch', 'Cruel Ultimatum', 'Omenspeaker', 'Faerie Impostor', 'Academy Loremaster', 'Crumbling Necropolis', 'Voltage Surge', 'Revival // Revenge', 'Font of Fertility', 'Gatebreaker Ram', 'Myr Welder', 'Creeping Chill', 'Sacred Peaks', 'Tyrant of Discord', 'Increasing Ambition', 'Phantasmal Bear', 'Wing Shards', 'Fight as One', 'Exuberant Fuseling', 'Fearless Fledgling', 'Trail of Crumbs', 'Grasslands', 'Mnemonic Sphere', 'Mission Briefing', 'Infiltration Lens', 'Sunder Shaman', 'Defiler of Vigor', 'Dig Up', 'Frogmite', 'Appetite for Brains', 'Heliod, God of the Sun', 'Runo Stromkirk', 'Vraska''s Fall', 'Porphyry Nodes', 'Crash Through', 'Drannith Stinger', 'Mikaeus, the Lunarch', 'Thrill of Possibility', 'Goblin Grenade', 'Bog Wraith', 'Spinerock Knoll', 'Cerulean Drake', 'Runic Shot', 'Ajani, the Greathearted', 'Primal Beyond', 'Gruul Guildgate', 'Experimental Synthesizer', 'Mistvein Borderpost', 'Ethersworn Canonist', 'Teshar, Ancestor''s Apostle', 'Barbarian Ring', 'Greenbelt Rampager', 'Talisman of Curiosity', 'Marshal of Zhalfir', 'Cacophony Scamp', 'Halimar Depths', 'Burst Lightning', 'Fireblade Charger', 'Zendikar''s Roil', 'Mindslaver', 'Infectious Bite', 'Renegade Doppelganger', 'Steel Leaf Champion', 'Aetherling', 'Trickbind', 'Arcbound Javelineer', 'Nightveil Specter', 'Erebos''s Intervention', 'Loran''s Escape', 'Joraga Treespeaker', 'Pact of the Titan', 'Orim''s Chant', 'Lurking Chupacabra', 'Filigree Sages', 'Riftwing Cloudskate', 'Graveborn Muse', 'Chancellor of the Forge', 'Ominous Seas', 'Vivid Meadow', 'Mindlash Sliver', 'Akroan Skyguard', 'Greatbow Doyen', 'Inscribed Tablet', 'Cloudfin Raptor', 'Skullsnatcher', 'Sovereigns of Lost Alara', 'Frostwalk Bastion', 'Rakdos''s Return', 'Broodmate Dragon', 'Titan''s Strength', 'Tasigur''s Cruelty', 'Sterling Grove', 'Weird Harvest', 'March from the Tomb', 'Nyxborn Rollicker', 'Supreme Will', 'Kambal, Consul of Allocation', 'Bituminous Blast', 'Colossification', 'Shriekmaw', 'Barrier of Bones', 'Blue Sun''s Zenith', 'Daxos of Meletis', 'Marit Lage''s Slumber', 'Fanatical Firebrand', 'Crackling Doom', 'Standing Troops', 'Nether Spirit', 'Cease-Fire', 'Quest for the Nihil Stone', 'Brinebarrow Intruder', 'Yixlid Jailer', 'Aspect of Hydra', 'Kemba, Kha Regent', 'Temple of Enlightenment', 'Merrow Bonegnawer', 'Michiko''s Reign of Truth', 'Triumphant Adventurer', 'Plaza of Harmony', 'Wildwood Scourge', 'Hushwing Gryff', 'Galerider Sliver', 'Springbloom Druid', 'Snow-Covered Swamp', 'Dizzy Spell', 'Pristine Talisman', 'Darksteel Citadel', 'Expansion // Explosion', 'Mind''s Desire', 'Keldon Marauders', 'Mogg War Marshal', 'Thousand-Year Elixir', 'Panglacial Wurm', 'Archaeomancer', 'Asmodeus the Archfiend', 'Mire''s Toll', 'Arcbound Mouser', 'Reassembling Skeleton', 'Azorius Signet', 'Scroll of Griselbrand', 'Disciple of Bolas', 'Wight', 'Ravager Wurm', 'Flametongue Yearling', 'Enchantress''s Presence', 'King Macar, the Gold-Cursed', 'Tormenting Voice', 'Budoka Gardener', 'Burning Sun''s Fury', 'Angel of Glory''s Rise', 'Krosan Tusker', 'Teachings of the Kirin', 'Sigrid, God-Favored', 'Aether Spellbomb', 'Irencrag Feat', 'Karrthus, Tyrant of Jund', 'Plow Under', 'Hypnotic Siren', 'Remove Soul', 'Talisman of Impulse', 'Brute Force', 'Blade Splicer', 'Angrath, the Flame-Chained', 'Temple of Malady', 'Raiyuu, Storm''s Edge', 'Yosei, the Morning Star', 'Temple of Epiphany', 'Invigorate', 'Goblin Instigator', 'Witch''s Cottage', 'Pashalik Mons', 'Spine of Ish Sah', 'Fevered Visions', 'Goblin Gaveleer', 'Sludge Crawler', 'Fall of the Thran', 'Condemn', 'Arrester''s Zeal', 'Ral, Storm Conduit', 'Ancient Amphitheater', 'Soulflayer', 'Gideon Jura', 'Return of the Wildspeaker', 'Birds of Paradise', 'Day of Judgment', 'The Scorpion God', 'Dictate of Kruphix', 'Shock', 'Madcap Experiment', 'Samite Healer', 'Mystic Monastery', 'Blizzard Specter', 'Mistblade Shinobi', 'Siege Rhino', 'Sentinel''s Eyes', 'Seal of Primordium', 'Aethergeode Miner', 'Fierce Empath', 'Lost Legacy', 'Boros Reckoner', 'Elder Deep-Fiend', 'Wild Defiance', 'Karmic Guide', 'Yahenni''s Expertise', 'Terror of Mount Velus', 'Boartusk Liege', 'Olivia Voldaren', 'Demonlord Belzenlok', 'Aryel, Knight of Windgrace', 'Resurgent Belief', 'Garruk Wildspeaker', 'Micromancer', 'Master of Death', 'Lapse of Certainty', 'Cyclops of Eternal Fury', 'Nephalia Drownyard', 'Ashenmoor Gouger', 'Luminarch Ascension', 'Genesis Wave', 'Dakkon, Shadow Slayer', 'Painful Quandary', 'Dimir Aqueduct', 'Call of the Death-Dweller', 'Boros Guildgate', 'Stronghold Arena', 'Prismari Campus', 'Temple of Triumph', 'Forked Bolt', 'Goblin Anarchomancer', 'Rakdos Signet', 'Dead // Gone', 'Defiant Strike', 'Golden Demise', 'Ghor-Clan Rampager', 'Glass of the Guildpact', 'Shatter the Sky', 'Garruk, Caller of Beasts', 'Day of the Dragons', 'Drake Haven', 'Argivian Restoration', 'Sylvan Caryatid', 'Aegis of the Gods', 'Arlinn Kord', 'Insolent Neonate', 'Ajani, Caller of the Pride', 'Secluded Steppe', 'Stirring Wildwood', 'Thirst for Meaning', 'Ancestral Blade', 'Kruphix''s Insight', 'Chandra''s Regulator', 'Ammit Eternal', 'Goblin Ringleader', 'Ghostfire Blade', 'Ugin, the Spirit Dragon', 'Sign in Blood', 'Burnished Hart', 'Feed the Swarm', 'Spawn of Thraxes', 'Evolving Wilds', 'Tracker''s Instincts', 'Carnophage', 'Diabolic Edict', 'Genju of the Fields', 'Rootbound Crag', 'Hidetsugu, Devouring Chaos', 'You See a Guard Approach', 'Curse of Death''s Hold', 'Recommission', 'Oath of Kaya', 'Fortified Village', 'Pharika''s Libation', 'Reckoner''s Bargain', 'Quarantine Field', 'Increasing Confusion', 'Slogurk, the Overslime', 'Gifts Ungiven', 'Noose Constrictor', 'Folio of Fancies', 'Prophet of Distortion', 'Boon Satyr', 'Render Silent', 'Soul''s Attendant', 'Night Clubber', 'Oath of Gideon', 'Temporal Fissure', 'Glowspore Shaman', 'Shadowed Caravel', 'Deadeye Tracker', 'Porcelain Legionnaire', 'Altered Ego', 'Cankerbloom', 'Tribute Mage', 'True Believer', 'Fleetwheel Cruiser', 'Touch the Spirit Realm', 'Favorable Winds', 'Assemble the Legion', 'Abundant Growth', 'Swarm Shambler', 'Enigma Sphinx', 'Arcbound Worker', 'Combat Research', 'Galvanic Alchemist', 'Setessan Champion', 'Vengeful Pharaoh', 'Ash Zealot', 'Dockside Chef', 'Declaration in Stone', 'Crawling Barrens', 'Faithless Salvaging', 'Bile Blight', 'Borderland Ranger', 'Chancellor of the Tangle', 'Faerie Conclave', 'Genesis', 'Jund Charm', 'Moonsnare Prototype', 'Kaito, Dancing Shadow', 'Urza''s Factory', 'Wily Goblin', 'Vinelasher Kudzu', 'Legacy Weapon', 'Stinkweed Imp', 'Nyxborn Shieldmate', 'Weirding Wood', 'Swans of Bryn Argoll', 'Lagrella, the Magpie', 'Aven Mindcensor', 'Merrow Reejerey', 'Ghostly Pilferer', 'Vraska''s Contempt', 'Magmatic Channeler', 'Grasping Dunes', 'Malcator, Purity Overseer', 'Old Man of the Sea', 'Cabal Ritual', 'Cult Conscript', 'Moss-Pit Skeleton', 'Battlefield Forge', 'Telepathy', 'Lavabrink Venturer', 'Profane Procession', 'Blackbloom Rogue', 'Verduran Enchantress', 'Gatekeeper of Malakir', 'Mirrorshell Crab', 'River of Tears', 'Martyr''s Soul', 'Oblivion Ring', 'Forgotten Cave', 'Rivaz of the Claw', 'Pelakka Predation', 'Tranquil Cove', 'Invasion of New Capenna', 'Earthshaker Khenra', 'Alpha Authority', 'Mana Cylix', 'Battle Screech', 'Mogg Fanatic', 'Mind Rake', 'Ulamog''s Crusher', 'Goldmire Bridge', 'Selfless Samurai', 'Lead the Stampede', 'Hieroglyphic Illumination', 'Seal of Removal', 'Phoenix Chick', 'Crumbling Vestige', 'Hellrider', 'Fiendslayer Paladin', 'Hive Mind', 'Fanatic of Xenagos', 'Terisian Mindbreaker', 'Dragon Tempest', 'Isolated Chapel', 'Escape to the Wilds', 'Spectrum Sentinel', 'Stony Silence', 'Increasing Vengeance', 'Magus of the Tabernacle', 'Lotus Cobra', 'Qasali Pridemage', 'Shadow Alley Denizen', 'Precinct Captain', 'Resolute Reinforcements', 'Dragonsguard Elite', 'Tavern Scoundrel', 'Halo Forager', 'Hit // Run', 'Sheltered Thicket', 'Venser, Shaper Savant', 'Death Cloud', 'Gitaxian Probe', 'Overwhelming Stampede', 'Fauna Shaman', 'Gallia of the Endless Dance', 'Basking Rootwalla', 'Skull of Orm', 'Orzhov Guildgate', 'Curiosity', 'Trade Secrets', 'Ritual of Soot', 'Pollenbright Druid', 'Fists of Flame', 'Viridian Zealot', 'Odric, Master Tactician', 'Forced Fruition', 'Cleric Class', 'Fog', 'Slaughter Drone', 'Kaya, Intangible Slayer', 'Opulent Palace', 'Cosmos Elixir', 'Adeliz, the Cinder Wind', 'Squadron Hawk', 'Blazing Crescendo', 'Fallow Earth', 'Leeching Sliver', 'Worldgorger Dragon', 'Worship', 'Radha, Heart of Keld', 'Arrogant Wurm', 'Okiba-Gang Shinobi', 'Silumgar''s Command', 'Krenko, Tin Street Kingpin', 'The Elder Dragon War', 'Fetid Heath', 'Marauding Blight-Priest', 'Silver-Fur Master', 'Nightscape Familiar', 'Heartless Act', 'Waker of Waves', 'Hero''s Downfall', 'Endless Ranks of the Dead', 'Hallowed Burial', 'Oona''s Grace', 'Mana Bloom', 'Primal Command', 'Riveteers Charm', 'Legion Angel', 'Drana, the Last Bloodchief', 'Salvage Titan', 'Worm Harvest', 'Distortion Strike', 'Cruel Reality', 'Agonizing Remorse', 'Valley Dasher', 'Mythos of Nethroi', 'Skyknight Vanguard', 'Condescend', 'Psychatog', 'Rootborn Defenses', 'Nezumi Graverobber', 'Teetering Peaks', 'Nullpriest of Oblivion', 'Dwynen''s Elite', 'Whirlwind Denial', 'Minor Misstep', 'Inscription of Abundance', 'Demolition Field', 'Carth the Lion', 'Arcbound Ravager', 'Liliana of the Dark Realms', 'Golgari Rot Farm', 'Llanowar Elves', 'Accorder Paladin', 'Catch // Release', 'Doomed Traveler', 'Nimbus Maze', 'Bolas''s Citadel', 'Goblin Blast-Runner', 'Guided Passage', 'Chandra, Novice Pyromancer', 'Traxos, Scourge of Kroog', 'Mantis Rider', 'Selesnya Charm', 'Charix, the Raging Isle', 'Workshop Warchief', 'Salt Road Ambushers', 'Quest for the Goblin Lord', 'Lazotep Plating', 'Avacyn, Guardian Angel', 'Utter End', 'Strike It Rich', 'Oath of Liliana', 'Daring Thief', 'Kabira Evangel', 'Saproling Burst', 'Dragon''s Fire', 'Atarka, World Render', 'Opaline Sliver', 'General''s Enforcer', 'Sandsteppe Citadel', 'Golgari Guildgate', 'Tomebound Lich', 'Anoint with Affliction', 'Devoted Druid', 'Nezumi Shortfang', 'Draconic Roar', 'Blessed Breath', 'The Magic Mirror', 'Eye of Nowhere', 'Into the Roil', 'Goblin Bombardment', 'Tribal Flames', 'Malakir Blood-Priest', 'Vantress Gargoyle', 'Timeless Dragon', 'Void Snare', 'Solemnity', 'Necroplasm', 'Inkwell Leviathan', 'Stillmoon Cavalier', 'Shrieking Grotesque', 'Mnemonic Betrayal', 'Sol Talisman', 'Drownyard Behemoth', 'Mizzium Skin', 'Wooded Bastion', 'Glen Elendra Archmage', 'Blackmail', 'Akroan Crusader', 'Akoum Battlesinger', 'Divinity of Pride', 'Overgrown Battlement', 'Phyrexian Unlife', 'Elvish Promenade', 'Stun Sniper', 'Not of This World', 'Scale of Chiss-Goria', 'Dead Weight', 'Ripjaw Raptor', 'Animation Module', 'Archfiend of the Dross', 'Architects of Will', 'Elvish Mystic', 'Eternal Scourge', 'Postmortem Lunge', 'Oath of Teferi', 'Abiding Grace', 'Fieldmist Borderpost', 'Mirran Crusader', 'Last Stand', 'Triskaidekaphile', 'Ziatora''s Envoy', 'Bloodthrone Vampire', 'Quirion Dryad', 'Penumbra Wurm', 'Prey''s Vengeance', 'Kessig Prowler', 'Guul Draz Assassin', 'Vivid Creek', 'Creeping Trailblazer', 'Authority of the Consuls', 'Reconstruction', 'Simic Guildgate', 'Corpse Cur', 'Secluded Courtyard', 'Seaside Citadel', 'Honored Hydra', 'Stream of Life', 'Gideon''s Intervention', 'Fracturing Gust', 'Augury Owl', 'Crucible of Fire', 'Vapor Snag', 'Kumano Faces Kakkazan', 'Barren Moor', 'Browbeat', 'Tyrant''s Scorn', 'Banish into Fable', 'Cloudpost', 'Ojutai''s Command', 'Diregraf Ghoul', 'Tectonic Giant', 'Brave the Sands', 'Satyr''s Cunning', 'Vexing Shusher', 'Ayula''s Influence', 'Invasive Surgery', 'Crimson Wisps', 'Dragon Tyrant', 'Skymarch Bloodletter', 'King Darien XLVIII', 'Zetalpa, Primal Dawn', 'Hada Freeblade', 'Whip of Erebos', 'Epochrasite', 'Seven Dwarves', 'Goblin Warchief', 'Krosan Grip', 'Yuan-Ti Fang-Blade', 'Endless One', 'Tomik, Distinguished Advokist', 'Shrapnel Blast', 'Heartless Summoning', 'Eldrazi Mimic', 'Tocatli Honor Guard', 'Fury of the Horde', 'Sea Gate Wreckage', 'Gust of Wind', 'Virtus''s Maneuver', 'Meddling Mage', 'Bridge from Below', 'Nezumi Prowler', 'Mistveil Plains', 'Wreak Havoc', 'Psychic Possession', 'Sarcomancy', 'Lightning Stormkin', 'Kalastria Healer', 'Shimmer Dragon', 'Chimeric Coils', 'Disciple of the Vault', 'Oust', 'Risk Factor', 'Stain the Mind', 'Curious Pair', 'Slagstorm', 'Zendikar Resurgent', 'Hogaak, Arisen Necropolis', 'Search for Tomorrow', 'Sphinx''s Disciple', 'Rule of Law', 'Esper Stormblade', 'Idyllic Beachfront', 'Kappa Tech-Wrecker', 'Inscription of Ruin', 'Zombie Infestation', 'Sweltering Suns', 'Demon of Dark Schemes', 'Footfall Crater', 'Recoup', 'Merfolk Sovereign', 'Soul Diviner', 'Duskmantle Guildmage', 'Aurelia''s Fury', 'Pilfer', 'Go for Blood', 'Rites of Initiation', 'Eye of Vecna', 'Argentum Masticore', 'Elas il-Kor, Sadistic Pilgrim', 'Talara''s Battalion', 'Trade Routes', 'Mystical Teachings', 'Lotleth Troll', 'Harmonize', 'Metamorphic Alteration', 'Wayfarer''s Bauble', 'Dokuchi Silencer', 'Dawn Charm', 'Wall of Blood', 'Sylvan Advocate', 'Abbot of Keral Keep', 'Greater Good', 'Grenzo, Dungeon Warden', 'Frost Walker', 'Lone Rider', 'Froghemoth', 'Yasharn, Implacable Earth', 'Cragplate Baloth', 'Cathedral of War', 'Fire-Lit Thicket', 'Sleight of Hand', 'Nimble Obstructionist', 'Brain Freeze', 'Third Path Iconoclast', 'Acolyte of Affliction', 'Inspiring Veteran', 'Scythe Tiger', 'Scuttling Doom Engine', 'Etched Champion', 'Wasitora, Nekoru Queen', 'Reckless Rage', 'Tramway Station', 'Delver of Secrets', 'Battle of Wits', 'Chittering Rats', 'Heliod''s Intervention', 'Empyrial Plate', 'Deeproot Champion', 'Blood Artist', 'Kami of False Hope', 'Aetherblade Agent', 'Fade from Memory', 'Haunted Fengraf', 'Viridian Emissary', 'Umbral Mantle', 'Inspiring Overseer', 'Flame Slash', 'Kulrath Knight', 'Garth One-Eye', 'Slaughter Pact', 'Leonin Lightscribe', 'Gilt-Leaf Palace', 'Mist-Syndicate Naga', 'Orah, Skyclave Hierophant', 'Ruin Crab', 'Briarbridge Tracker', 'Mycosynth Wellspring', 'Kalonian Tusker', 'Den Protector', 'Chandra Nalaar', 'Pixie Illusionist', 'Kefnet the Mindful', 'Oath of Chandra', 'Fallen Shinobi', 'Radiant Fountain', 'Nylea, God of the Hunt', 'Blossoming Calm', 'Exclude', 'Boulderbranch Golem', 'Sylvan Library', 'Stone Haven Outfitter', 'Devout Chaplain', 'Elsewhere Flask', 'Mnemonic Wall', 'Liesa, Forgotten Archangel', 'Shrine of Burning Rage', 'Offalsnout', 'Balmor, Battlemage Captain', 'Guildmages'' Forum', 'Wretched Gryff', 'Silundi Vision', 'Troll Ascetic', 'Orzhov Signet', 'Electrolyze', 'Dark Salvation', 'Taurean Mauler', 'Scion of Darkness', 'Kuldotha Rebirth', 'Toolcraft Exemplar', 'Wasteland Strangler', 'Brood Birthing', 'Endless Detour', 'Scattered Groves', 'Champion of Lambholt', 'Vedalken Shackles', 'Boros Recruit', 'Essence Scatter', 'Stonybrook Angler', 'Snow-Covered Plains', 'Patriarch''s Bidding', 'Stromkirk Condemned', 'Spell Shrivel', 'It That Betrays', 'Reject Imperfection', 'Aven Heartstabber', 'Glare of Subdual', 'Mesa Enchantress', 'Ram Through', 'Vandalblast', 'Clockwork Beetle', 'Wayward Guide-Beast', 'Heir of Falkenrath', 'Barkhide Troll', 'Alchemist''s Vial', 'Rob the Archives', 'Stormblood Berserker', 'Niv-Mizzet, Parun', 'Slagwoods Bridge', 'Maze Rusher', 'Seize the Spoils', 'Cataclysmic Gearhulk', 'Seraph Sanctuary', 'Future Sight', 'Leather Armor', 'Vampiric Link', 'Dusk // Dawn', 'Dead of Winter', 'Maul of the Skyclaves', 'Tresserhorn Sinks', 'Dimir Charm', 'Natural State', 'Angel of Vitality', 'Sungold Sentinel', 'Pillage', 'Seething Song', 'Invasion of Azgol', 'Wander in Death', 'Springleaf Drum', 'Desecration Demon', 'Tomb of the Spirit Dragon', 'Simic Sky Swallower', 'Satyr Hedonist', 'Shred Memory', 'Restoration Angel', 'Phyrexian Dreadnought', 'Plague Stinger', 'Ravaging Riftwurm', 'Putrefy', 'Glorious Protector', 'Cartel Aristocrat', 'Obscura Charm', 'Consume the Meek', 'Kaervek, the Spiteful', 'Devil''s Play', 'Nest Invader', 'Destroy the Evidence', 'Wall of Omens', 'Fungal Reaches', 'Perilous Research', 'Rags // Riches', 'Stave Off', 'Etali, Primal Storm', 'Magmatic Insight', 'Lightning Spear', 'Assault // Battery', 'Brineborn Cutthroat', 'Stitch in Time', 'Gigadrowse', 'Gird for Battle', 'Wavesifter', 'Larger Than Life', 'Magma Jet', 'Ally Encampment', 'Aqueous Form', 'Hanweir Militia Captain', 'Defabricate', 'Locket of Yesterdays', 'Fire Prophecy', 'Sigil of the Empty Throne', 'Fume Spitter', 'Monument to Perfection', 'Intangible Virtue', 'Whisper of the Dross', 'Implement of Combustion', 'Squirrel Sovereign', 'Adaptive Automaton', 'Cut // Ribbons', 'Ball Lightning', 'Forging the Anchor', 'Growing Rites of Itlimoc', 'Shrieking Affliction', 'Monastery Swiftspear', 'Chandra''s Triumph', 'Invoke Calamity', 'Meeting of Minds', 'Commence the Endgame', 'Soul of Zendikar', 'Warlord''s Fury', 'Shattered Seraph', 'Bedeck // Bedazzle', 'Ichorclaw Myr', 'Gutterbones', 'Jeskai Charm', 'Jace''s Ingenuity', 'Silver Knight', 'Domri Rade', 'Ajani Steadfast', 'Kor Skyfisher', 'Dregscape Zombie', 'Kitesail Freebooter', 'Deploy the Gatewatch', 'Kogla, the Titan Ape', 'Melira, Sylvok Outcast', 'Scroll of Avacyn', 'Seedcradle Witch', 'Sky Hussar', 'Evil Twin', 'Cunning Nightbonder', 'Judge''s Familiar', 'Vampire Nighthawk', 'Deftblade Elite', 'Ultimate Price', 'Sygg, River Cutthroat', 'Ramunap Excavator', 'Shakedown Heavy', 'Azorius Chancery', 'Academy Manufactor', 'Nadaar, Selfless Paladin', 'Purify the Grave', 'Liquimetal Coating', 'Reality Heist', 'Yawgmoth''s Bargain', 'Alesha, Who Smiles at Death', 'Quiet Speculation', 'Duty-Bound Dead', 'Sakashima the Impostor', 'Burning Inquiry', 'Falkenrath Gorger', 'Unwind', 'Elspeth, Sun''s Nemesis', 'Drogskol Reaver', 'Hypergenesis', 'Ral Zarek', 'Angel of Mercy', 'Primal Rage', 'Bloodhall Ooze', 'Dragon''s Hoard', 'Archangel of Tithes', 'Spark Spray', 'Sarinth Steelseeker', 'Isamaru, Hound of Konda', 'The Birth of Meletis', 'Dire-Strain Rampage', 'Greater Gargadon', 'Drossforge Bridge', 'Thrun, Breaker of Silence', 'Myr Battlesphere', 'Dark-Dweller Oracle', 'Adventurous Impulse', 'Gudul Lurker', 'Treasure Map', 'Astral Slide', 'Mesmeric Fiend', 'Arch of Orazca', 'Phyrexian Revoker', 'Kiln Fiend', 'Negate', 'Boneyard Wurm', 'Thragtusk', 'Goblin Matron', 'Brokers Hideout', 'Zealous Persecution', 'Generous Visitor', 'Orzhov Basilica', 'Light Up the Night', 'Angelic Destiny', 'Peer Through Depths', 'Cathartic Reunion', 'Josu Vess, Lich Knight', 'Spirited Companion', 'Searing Spear', 'Thought Scour', 'Jwari Shapeshifter', 'Weaver of Harmony', 'Pride of the Clouds', 'Scrapyard Recombiner', 'Murderous Redcap', 'Word of Undoing', 'Farseek', 'Elderscale Wurm', 'Sublime Archangel', 'Herald of the Pantheon', 'Nature''s Lore', 'Rise // Fall', 'Llanowar Mentor', 'Glint Hawk', 'Bedlam Reveler', 'Prophet of Kruphix', 'Dovescape', 'Call to the Netherworld', 'Nevermore', 'Lumbering Falls', 'Valentin, Dean of the Vein', 'Vilis, Broker of Blood', 'Mistvault Bridge', 'Bone Dragon', 'Nevinyrral''s Disk', 'Heap Doll', 'Go for the Throat', 'Dissenter''s Deliverance', 'Darksteel Ingot', 'Aether Adept', 'The Flame of Keld', 'Brave the Elements', 'Abzan Charm', 'Sanctum of Ugin', 'Prohibit', 'Reveillark', 'Kunoros, Hound of Athreos', 'Mutilate', 'Dimir Guildgate', 'Nahiri, Storm of Stone', 'Sword of Kaldra', 'Walker of the Wastes', 'Jackal Pup', 'Pull from Tomorrow', 'Vineglimmer Snarl', 'Tyvar''s Stand', 'Twiddle', 'Sagu Mauler', 'Shrine of the Forsaken Gods', 'Angelfire Ignition', 'Jace Beleren', 'Tainted Indulgence', 'Ransack the Lab', 'Esper Charm', 'Resolute Archangel', 'Specter''s Shriek', 'Grand Architect', 'Gnottvold Slumbermound', 'Gleeful Demolition', 'Far // Away', 'River Serpent', 'Goldhound', 'Liquimetal Torque', 'Kaya, Ghost Assassin', 'Temple of Malice', 'Lizard Blades', 'Cleric of Life''s Bond', 'Sea-Dasher Octopus', 'Light of Hope', 'Tentative Connection', 'Kami of the Crescent Moon', 'Korlash, Heir to Blackblade', 'Dreams of Steel and Oil', 'Holdout Settlement', 'Fell Stinger', 'Palace Siege', 'Skarrgan Hellkite', 'Flooded Grove', 'Rix Maadi Reveler', 'Dragonskull Summit', 'Icefeather Aven', 'Fire Diamond', 'Chandra''s Pyreling', 'Bankrupt in Blood', 'Spider Umbra', 'Gideon''s Triumph', 'Rot Wolf', 'Steel Hellkite', 'Caves of Koilos', 'Wake Thrasher', 'Kher Keep', 'Commune with Lava', 'Recurring Nightmare', 'Primal Surge', 'Pyretic Ritual', 'Semblance Anvil', 'Cartouche of Solidarity', 'Linessa, Zephyr Mage', 'Thawing Glaciers', 'Network Disruptor', 'Crack the Earth', 'Tanglepool Bridge', 'Sheoldred''s Edict', 'Bilious Skulldweller', 'Gods Willing', 'Ingenious Infiltrator', 'Blinkmoth Infusion', 'Stasis Snare', 'Akroma, Angel of Fury', 'Sphere of Safety', 'Murmuring Bosk', 'Triskelion', 'Hagra Mauling', 'Timely Reinforcements', 'Circuit Mender', 'Fyndhorn Elves', 'Reckless Fireweaver', 'Harrow', 'Life''s Legacy', 'Wargate', 'Wildfire', 'Dimir Signet', 'Unlucky Witness', 'Thousand-Faced Shadow', 'Varragoth, Bloodsky Sire', 'Groundbreaker', 'Auramancer', 'Trostani''s Summoner', 'Boros Swiftblade', 'Grave Titan', 'Lost Auramancers', 'Bump in the Night', 'Centaur Garden', 'Bonders'' Enclave', 'Duress', 'War Falcon', 'Siren Stormtamer', 'The Antiquities War', 'Overgrowth', 'Banishing Stroke', 'Tombstalker', 'Ravenous Rats', 'Wildgrowth Walker', 'Bloodchief''s Thirst', 'Favored Hoplite', 'Golgari Charm', 'Rapid Hybridization', 'Vigor', 'Radiant Flames', 'Spark Elemental', 'Vesperlark', 'Twinshot Sniper', 'Elusive Spellfist', 'Grumgully, the Generous', 'Out of Time', 'Through the Breach', 'Preeminent Captain', 'Kalastria Highborn', 'Clawing Torment', 'Catacomb Sifter', 'Temple of Silence', 'Orchard Strider', 'Phalanx Leader', 'Shivan Wurm', 'Boros Elite', 'Combat Courier', 'Primal Bellow', 'Omen of the Sun', 'Armored Scrapgorger', 'Boomerang', 'Quiet Disrepair', 'Savage Lands', 'Defiler of Flesh', 'Undying Evil', 'Maze''s End', 'Eight-and-a-Half-Tails', 'Skycat Sovereign', 'Pelakka Wurm', 'Tranquil Garden', 'Tatsunari, Toad Rider', 'Viridian Revel', 'Gideon''s Lawkeeper', 'Approach of the Second Sun', 'Big Score', 'Needle Spires', 'Glorybringer', 'Mortuary Mire', 'Grand Coliseum', 'Genesis Ultimatum', 'Legion''s Landing', 'Nighthawk Scavenger', 'Brighthearth Banneret', 'Weathered Wayfarer', 'Rem Karolus, Stalwart Slayer', 'Squirrel Mob', 'Hinterland Harbor', 'Chandra''s Phoenix', 'Adorned Pouncer', 'Obsessive Search', 'Barbed Sextant', 'Throes of Chaos', 'Nivix Cyclops', 'Dark Petition', 'Nephalia Smuggler', 'Laboratory Maniac', 'Urabrask the Hidden', 'Crab Umbra', 'Inquisitive Puppet', 'Liliana''s Reaver', 'Nameless Inversion', 'Sleep', 'The Seedcore', 'Plated Geopede', 'Izzet Charm', 'Countervailing Winds', 'Astral Drift', 'Selesnya Sanctuary', 'Stormtide Leviathan', 'Brushfire Elemental', 'Pathrazer of Ulamog', 'Crush of Tentacles', 'Audacity', 'Grisly Salvage', 'Knight of the Reliquary', 'Mobilized District', 'Village Messenger', 'Dire Tactics', 'Geistflame', 'Midnight Haunting', 'Surge of Salvation', 'Tree of Tales', 'Explore', 'Honored Heirloom', 'Seasoned Hallowblade', 'Egon, God of Death', 'Seeker of the Way', 'Dreadhorde Butcher', 'Volcanic Spite', 'Gruul Spellbreaker', 'Crypt Incursion', 'Dread Presence', 'Sylvan Awakening', 'Scourge Wolf', 'Realm Razer', 'Gadrak, the Crown-Scourge', 'Corrupted Crossroads', 'Snow-Covered Mountain', 'Founding the Third Path', 'Terminus', 'Pyrite Spellbomb', 'Jace''s Phantasm', 'Soul Snuffers', 'Volcanic Salvo', 'Skirge Familiar', 'Turn // Burn', 'Pyroclasm', 'Shalai, Voice of Plenty', 'The Raven''s Warning', 'Peerless Samurai', 'Valiant Changeling', 'Corrupt', 'Banisher Priest', 'Adaptive Sporesinger', 'Mindsplice Apparatus', 'Angel of Jubilation', 'Altar of Dementia', 'Think Twice', 'Roar of the Wurm', 'Darksteel Forge', 'Titanoth Rex', 'Sunpetal Grove', 'Oath of Ajani', 'Nomad Outpost', 'Flame Rift', 'Hero of Precinct One', 'Hostage Taker', 'Aethersphere Harvester', 'Thunderbreak Regent', 'Magus of the Scroll', 'Fiery Temper', 'Emberstrike Duo', 'Viscera Seer', 'Skarrgan Pit-Skulk', 'Dusk Legion Zealot', 'Caustic Caterpillar', 'Xenagos, the Reveler', 'Geomancer''s Gambit', 'Animist''s Awakening', 'Slip Through Space', 'Séance', 'Dragonstorm', 'Captain of the Watch', 'Yusri, Fortune''s Flame', 'View from Above', 'Time of Need', 'Jade Mage', 'Linvala, Shield of Sea Gate', 'Enlarge', 'Raging Goblin', 'Diffusion Sliver', 'Priest of the Haunted Edge', 'Flood Plain', 'Tolsimir, Friend to Wolves', 'Call of the Conclave', 'Reckless Wurm', 'Blossoming Sands', 'Worthy Knight', 'Battlewing Mystic', 'Tamiyo, Collector of Tales', 'Mana Tithe', 'Wonder', 'Bojuka Brigand', 'Plunder', 'Blighted Agent', 'Sins of the Past', 'War Priest of Thune', 'Jungle Shrine', 'Crystalline Giant', 'Sunken Hollow', 'Silumgar, the Drifting Death', 'Tezzeret the Schemer', 'Thryx, the Sudden Storm', 'Forever Young', 'Jace, Unraveler of Secrets', 'Dreadhorde Invasion', 'Commune with Nature', 'Massacre Girl', 'Executioner''s Capsule', 'Verdant Command', 'Acclaimed Contender', 'Soaring Drake', 'Evangel of Synthesis', 'Piranha Marsh', 'Consuming Bonfire', 'Staggershock', 'Kiora, the Crashing Wave', 'Phoenix of Ash', 'Silumgar''s Scorn', 'Golgari Brownscale', 'Pulse of the Fields', 'Kemba, Kha Enduring', 'Celestial Colonnade', 'Garruk''s Harbinger', 'Foundry Helix', 'Citizen''s Crowbar', 'Flaying Tendrils', 'Power Sink', 'Dauntless Escort', 'Infinite Obliteration', 'Gather the Townsfolk', 'Iron Apprentice', 'Nissa, Worldwaker', 'Tooth of Chiss-Goria', 'Return to Dust', 'Stonehorn Dignitary', 'Wirewood Herald', 'Ghitu Encampment', 'Fae of Wishes', 'Melira, the Living Cure', 'Garruk Relentless', 'Draugr Necromancer', 'Atog', 'Pestilent Haze', 'Metalwork Colossus', 'Needle Drop', 'Tome Scour', 'Thran Portal', 'Seal from Existence', 'Nicol Bolas, Planeswalker', 'Rune Snag', 'Glimmerpost', 'Invasion of Regatha', 'Fated Retribution', 'Watcher for Tomorrow', 'Domri''s Ambush', 'Repudiate // Replicate', 'Reanimate', 'Expendable Lackey', 'Thaumatic Compass', 'Languish', 'Cloudcrest Lake', 'Memorial to Genius', 'Devastating Summons', 'Hooded Blightfang', 'Brigid, Hero of Kinsbaile', 'Unsummon', 'Bane of Bala Ged', 'Cruel Celebrant', 'Tilling Treefolk', 'Dack''s Duplicate', 'Might of Oaks', 'Dryad Militant', 'Ancient Ziggurat', 'Fertile Ground', 'Urza''s Rage', 'Jor Kadeen, First Goldwarden', 'You Find Some Prisoners', 'Colossus of Akros', 'Ratadrabik of Urborg', 'Moorland Haunt', 'Spear of Heliod', 'Blood Lust', 'Huntmaster of the Fells', 'Venser, Corpse Puppet', 'Frenetic Sliver', 'Faith''s Fetters', 'Sejiri Steppe', 'Ethereal Armor', 'Chromatic Lantern', 'Evacuation', 'Nightmare Shepherd', 'Sylvan Messenger', 'Michonne, Ruthless Survivor', 'Lurrus of the Dream-Den', 'Stubborn Denial', 'Hard Evidence', 'Elixir of Immortality', 'Fiery Impulse', 'Distorted Curiosity', 'Nekrataal', 'Planar Bridge', 'Faerie Miscreant', 'Blasphemous Act', 'Venerated Loxodon', 'Indulgent Aristocrat', 'Lochmere Serpent', 'Syr Faren, the Hengehammer', 'Steel Overseer', 'Felidar Retreat', 'Kokusho, the Evening Star', 'Arguel''s Blood Fast', 'Forbidden Alchemy', 'Shard Volley', 'Molten Tributary', 'Goldmeadow Harrier', 'Naban, Dean of Iteration', 'Night Market Lookout', 'Skylasher', 'Tail Swipe', 'Timeless Witness', 'Duergar Assailant', 'Avatar of the Resolute', 'Mephidross Vampire', 'Skirk Prospector', 'Thirsting Roots', 'Valakut Invoker', 'Ondu Cleric', 'Molten Rain', 'Willow Geist', 'Courier''s Briefcase', 'Vines of Vastwood', 'Arashin Cleric', 'Chance Encounter', 'Cloudshredder Sliver', 'Chief Engineer', 'Ghitu Fire', 'Voyaging Satyr', 'Notion Thief', 'Dispatch', 'Oran-Rief, the Vastwood', 'Marble Diamond', 'Expand the Sphere', 'Sonic Burst', 'Memory Lapse', 'Virus Beetle', 'Dragon Turtle', 'Mardu Strike Leader', 'Sentinel''s Mark', 'Eldrazi Skyspawner', 'Dregscape Sliver', 'Mizzium Mortars', 'Chandra, the Firebrand', 'Festival Crasher', 'Knight of Glory', 'Augmenter Pugilist', 'Jungle Hollow', 'Thermo-Alchemist', 'Norin the Wary', 'Bearer of Silence', 'The Mending of Dominaria', 'Shizo, Death''s Storehouse', 'Graven Cairns', 'Frost Titan', 'Mirrorweave', 'Leonin Bola', 'Sulfur Falls', 'Magister of Worth', 'Rift Bolt', 'Skyclave Cleric', 'Tangle', 'Tattermunge Maniac', 'Whispersilk Cloak', 'Dimir Guildmage', 'Battlegate Mimic', 'Early Harvest', 'Brokers Charm', 'Tendo Ice Bridge', 'Unctus, Grand Metatect', 'Lys Alana Huntmaster', 'Azorius Charm', 'Vault Skirge', 'Heartfire', 'Akroma''s Blessing', 'Anafenza, Kin-Tree Spirit', 'Mark of Eviction', 'Lantern-Lit Graveyard', 'Chandra, Flame''s Catalyst', 'Gavony Township', 'Dream''s Grip', 'Distended Mindbender', 'Tymaret, Chosen from Death', 'Bring the Ending', 'Liliana''s Caress', 'Gloomshrieker', 'Xorn', 'Despise', 'Mulldrifter', 'Kira, Great Glass-Spinner', 'Tangled Florahedron', 'Change the Equation', 'Whisperwood Elemental', 'Spirit Link', 'Terminate', 'Calibrated Blast', 'Treasure Mage', 'Loxodon Smiter', 'Quest for Pure Flame', 'Master Biomancer', 'Woodfall Primus', 'Psychic Strike', 'Wrecking Ball', 'Hateflayer', 'Hornet Queen', 'Predatory Sliver', 'Leonin Arbiter', 'Taborax, Hope''s Demise', 'Putrid Goblin', 'Neheb, Dreadhorde Champion', 'Howl of the Night Pack', 'Bolt Hound', 'Ajani, Adversary of Tyrants', 'Naru Meha, Master Wizard', 'Turnabout', 'Torens, Fist of the Angels', 'Gigantosaurus', 'Rootwater Depths', 'Pain Seer', 'Apostle''s Blessing', 'Canopy Vista', 'Hunted Nightmare', 'Krark''s Thumb', 'Vendetta', 'Ethersworn Sphinx', 'Brainstone', 'Quicken', 'Fling', 'Merciless Eviction', 'Oracle of Tragedy', 'Metallic Rebuke', 'Infest', 'Munitions Expert', 'Stitcher''s Graft', 'Search for Azcanta', 'Pore Over the Pages', 'False Summoning', 'Spikefield Hazard', 'Azorius Guildgate', 'Return to the Ranks', 'Rise and Shine', 'Torment of Scarabs', 'Drown in Ichor', 'Advent of the Wurm', 'Thornglint Bridge', 'Angel''s Grace', 'Cremate', 'Munda, Ambush Leader', 'Jaya Ballard, Task Mage', 'Ixalli''s Diviner', 'Nissa''s Renewal', 'Temple of Deceit', 'Wandering Fumarole', 'Lavaclaw Reaches', 'Wort, the Raidmother', 'Enduring Ideal', 'Wild Cantor', 'Primal Amulet', 'Essence Flux', 'Graveyard Marshal', 'Jeskai Ascendancy', 'Negan, the Cold-Blooded', 'Stormcaller''s Boon', 'Geothermal Bog', 'Ethereal Absolution', 'Infectious Inquiry', 'Fiery Gambit', 'Castigate', 'Bloodbraid Marauder', 'Ashnod''s Harvester', 'Spectral Procession', 'Spare Supplies', 'Quicksand', 'Vivid Marsh', 'Assault Formation', 'Decree of Justice', 'Gruul Turf', 'Daring Apprentice', 'Utopia Tree', 'Just the Wind', 'Selesnya Guildgate', 'Shore Up', 'Akiri, Fearless Voyager', 'Corpse Appraiser', 'Cryptic Caves', 'Braingeyser', 'Walk the Aeons', 'Erayo, Soratami Ascendant', 'Skarrg, the Rage Pits', 'Phyrexian Missionary', 'Umara Wizard', 'Llanowar Tribe', 'Energy Refractor', 'Warhost''s Frenzy', 'Aeve, Progenitor Ooze', 'Black Knight', 'Varolz, the Scar-Striped', 'Myr Enforcer', 'Soul Shatter', 'Cabaretti Courtyard', 'Painful Truths', 'Beacon of Creation', 'Artful Maneuver', 'Silhana Ledgewalker', 'Cryptolith Rite', 'Urza''s Ruinous Blast', 'Karumonix, the Rat King', 'Blood Knight', 'Sephara, Sky''s Blade', 'Dragon Fodder', 'Doom Blade', 'Blightbelly Rat', 'Kazandu Mammoth', 'Demon of Death''s Gate', 'Wheel of Sun and Moon', 'Leyline of Anticipation', 'Phantasmal Dreadmaw', 'Doomed Necromancer', 'Burning of Xinye', 'Crossbow Infantry', 'Commit // Memory', 'Labyrinth Raptor', 'Elvish Champion', 'Urban Utopia', 'Undercity Informer', 'Maze Behemoth', 'Crux of Fate', 'Vivid Crag', 'Liar''s Pendulum', 'Jwari Disruption', 'Dwarven Forge-Chanter', 'Fatestitcher'))) AND (TRUE)
GROUP BY
d.id,
d.competition_id, -- Every deck has only one competition_id but if we want to use competition_id in the HAVING clause we need this.
season.season_id -- In theory this is not necessary as all decks are in a single season and we join on the date but MySQL cannot work that out so give it the hint it needs.
HAVING
TRUE
ORDER BY
active_date DESC, d.finish IS NULL, d.finish
```[] (slow_query, 116.0, mysql)
Reported on decksite by mysql-perf
Location Hash: 22745614f2528d78225bb33e38605353e46b4d1e
Labels: decksite
-- MAX(q.changed_date) AS last_archetype_change FROM deck AS d -- LEFT JOIN -- deck_archetype_change AS q ON q.deck_id = d.id LEFT JOIN person AS p ON d.person_id = p.id LEFT JOIN source AS s ON d.source_id = s.id LEFT JOIN archetype AS a ON d.archetype_id = a.id
[](slow_query, 294.6, mysql)Reported on decksite by mysql-perf
Location Hash: 22745614f2528d78225bb33e38605353e46b4d1e