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