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