vorpal-buildbot
commented
1 year ago Exceeded slow_query limit (2.7 > 1.0) in mysql: ```
SELECT
d.id,
d.finish,
d.decklist_hash,
cache.active_date,
cache.wins,
cache.losses,
cache.draws,
cache.color_sort,
ct.name AS competition_type_name
FROM
deck AS d
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_cache AS season ON d.id = season.deck_id
WHERE
(d.id IN (SELECT deck_id FROM deck_card WHERE card IN ('Ondu Inversion', 'Shivan Reef', 'Abundant Growth', 'Circular Logic', 'Combat Thresher', 'Liliana Vess', 'Ally Encampment', 'Razortide Bridge', 'Shrapnel Blast', 'Tranquil Thicket', 'Pillar of the Paruns', 'Orzhov Basilica', 'Thopter Spy Network', 'Elvish Mystic', 'Favored Hoplite', 'Stromkirk Noble', 'Kuldotha Forgemaster', 'Scour All Possibilities', 'Wilt', 'Shimmerdrift Vale', 'Eternal Scourge', 'Tidespout Tyrant', 'Tribute to Horobi', 'Student of Warfare', 'Pain Seer', 'Lazotep Chancellor', 'Springleaf Drum', 'Prologue to Phyresis', 'Smuggler''s Copter', 'Apostle''s Blessing', 'Chamber Sentry', 'Nameless Inversion', 'Basking Rootwalla', 'Xerex Strobe-Knight', 'Peek', 'Vraska''s Contempt', 'Cabal Initiate', 'Barter in Blood', 'Corrupted Conviction', 'Grave Scrabbler', 'Oni-Cult Anvil', 'Consecrate // Consume', 'Assault // Battery', 'Explore', 'Kiora Bests the Sea God', 'Sin Prodder', 'Abundant Harvest', 'Talisman of Unity', 'Blightbelly Rat', 'Huatli, Radiant Champion', 'Sleight of Hand', 'Raffine''s Informant', 'Summer Bloom', 'Sylvan Primordial', 'Barren Moor', 'Woodweaver''s Puzzleknot', 'Midnight Clock', 'Marit Lage''s Slumber', 'Anger of the Gods', 'Geothermal Bog', 'Goblin Bombardment', 'Grand Arbiter Augustin IV', 'Obscura Storefront', 'Frantic Search', 'Primal Command', 'Floriferous Vinewall', 'Go for the Throat', 'Reckoner''s Bargain', 'Viridian Revel', 'Counterflux', 'Kjeldoran Outpost', 'Venser, Corpse Puppet', 'Gideon Jura', 'Ayli, Eternal Pilgrim', 'Choked Estuary', 'Gryff''s Boon', 'Valiant Changeling', 'Bring the Ending', 'Call to the Grave', 'Sinew Sliver', 'Kabira Takedown', 'Figure of Destiny', 'Commune with Spirits', 'Dimir Aqueduct', 'Spell Pierce', 'Moderation', 'Angel of Grace', 'Rally the Ancestors', 'Farhaven Elf', 'Mishra''s Self-Replicator', 'Seal of Primordium', 'Chittering Rats', 'Ghostly Flicker', 'Hornet Queen', 'Stern Dismissal', 'Invasion of Azgol', 'Koth, Fire of Resistance', 'Electrolyze', 'Declaration in Stone', 'Fae of Wishes', 'Psychatog', 'Eldrazi Skyspawner', 'Marauding Blight-Priest', 'Priest of the Haunted Edge', 'Divinity of Pride', 'Renewed Faith', 'Endbringer', 'Gnawing Vermin', 'Gallia of the Endless Dance', 'Lost Legacy', 'Leonin Lightscribe', 'Shard Volley', 'Overgrowth', 'Cliffside Lookout', 'King Darien XLVIII', 'Helm of the Host', 'Green Sun''s Twilight', 'Skyshroud Elf', 'Battle of Frost and Fire', 'Vedalken Heretic', 'Heliod''s Intervention', 'Throat Slitter', 'Curse of Exhaustion', 'Oblivion Ring', 'Tyrant''s Choice', 'Valiant Rescuer', 'Siege Rhino', 'Tocatli Honor Guard', 'Halana and Alena, Partners', 'Orcish Lumberjack', 'Midnight Guard', 'Nezumi Shortfang', 'Blessed Alliance', 'Augur of Bolas', 'Coalition Relic', 'Oust', 'Faerie Vandal', 'Stone Haven Outfitter', 'Mystical Teachings', 'Argentum Masticore', 'Shambling Vent', 'Sea Gate Wreckage', 'Vindicate', 'Impulse', 'Elas il-Kor, Sadistic Pilgrim', 'Nephalia Drownyard', 'Tangle', 'Ardent Recruit', 'Ovika, Enigma Goliath', 'Predatory Sliver', 'Augur of Skulls', 'Thrun, Breaker of Silence', 'Blade Splicer', 'Reflector Mage', 'Silverblade Paladin', 'Illuminator Virtuoso', 'Birds of Paradise', 'Orzhov Charm', 'Frenetic Sliver', 'Terminate', 'Sculpting Steel', 'Farseek', 'Nimbus Maze', 'Smallpox', 'Tomik, Distinguished Advokist', 'Battlefield Forge', 'Delver of Secrets', 'Open the Gates', 'Devil''s Play', 'Memory Lapse', 'All That Glitters', 'Master of Etherium', 'Grim Haruspex', 'Stirring Wildwood', 'Akroan Crusader', 'Artisan of Kozilek', 'Geomancer''s Gambit', 'Arcane Sanctum', 'Undercity Informer', 'Obscura Charm', 'Time of Need', 'Kiora, the Crashing Wave', 'Hard Evidence', 'Astral Drift', 'Smoldering Marsh', 'Inscribed Tablet', 'Third Path Iconoclast', 'Colossal Skyturtle', 'Westvale Abbey', 'Revitalize', 'Nimble Trapfinder', 'Murmuring Bosk', 'Jungle Hollow', 'Phyrexian Unlife', 'Leonin Relic-Warder', 'Lose Focus', 'Stinkweed Imp', 'Bump in the Night', 'Nevermore', 'Blue Sun''s Zenith', 'Bubbling Cauldron', 'Goblin Electromancer', 'Benthic Biomancer', 'Ambush Viper', 'Dark-Dweller Oracle', 'Silversmote Ghoul', 'Akoum Hellhound', 'Xenagos, the Reveler', 'Hero of Bladehold', 'Narcomoeba', 'Kalastria Healer', 'Chaotic Transformation', 'Terminus', 'Night Market Lookout', 'Psychic Possession', 'Kitchen Finks', 'Memoricide', 'Change the Equation', 'Dragon''s Hoard', 'Vapor Snag', 'Corpse Cur', 'Isolated Chapel', 'Obzedat, Ghost Council', 'Vexing Shusher', 'Mazemind Tome', 'Dakkon, Shadow Slayer', 'Wolfbriar Elemental', 'Attune with Aether', 'Arbor Elf', 'Voltage Surge', 'Gutterbones', 'Vivid Marsh', 'Unholy Heat', 'Crawling Barrens', 'Sinister Concoction', 'Varolz, the Scar-Striped', 'Icehide Golem', 'Possibility Storm', 'Champion of Wits', 'Tidehollow Sculler', 'Akiri, Fearless Voyager', 'Hooting Mandrills', 'Squadron Hawk', 'Hypnotic Specter', 'Pore Over the Pages', 'Giant Killer', 'Mothdust Changeling', 'Sculpted Perfection', 'Eerie Ultimatum', 'Dakmor Salvage', 'Banishing Slash', 'Expedition Envoy', 'Nine Lives', 'Kumano Faces Kakkazan', 'Glorybringer', 'Dismal Backwater', 'Woodland Cemetery', 'Radha, Heart of Keld', 'Sylvan Advocate', 'Engulf the Shore', 'Vadrik, Astral Archmage', 'Dross Skullbomb', 'Barbed Sextant', 'Jace Beleren', 'Hinterland Harbor', 'Bilious Skulldweller', 'Ral, Izzet Viceroy', 'Turnabout', 'Wood Elves', 'Hypergenesis', 'Myr Superion', 'Secluded Steppe', 'Laboratory Maniac', 'Conflagrate', 'Dream Trawler', 'Wrench Mind', 'Polukranos, World Eater', 'Ulvenwald Hydra', 'Invasion of New Capenna', 'Oona, Queen of the Fae', 'Elemental Masterpiece', 'Fiery Justice', 'Kitchen Imp', 'Volt Charge', 'Port Town', 'Earthquake', 'Ashen Rider', 'Dead // Gone', 'Ayara, First of Locthwain', 'Rocco, Cabaretti Caterer', 'Drown in Ichor', 'Riddleform', 'Sigil of the Empty Throne', 'Steppe Lynx', 'Soltari Priest', 'Zurgo Bellstriker', 'Graven Cairns', 'Sunscour', 'Runed Halo', 'Big Game Hunter', 'Cloudshift', 'Big Score', 'Undying Evil', 'Patchwork Automaton', 'Eldrazi Displacer', 'Scattered Groves', 'Vampire Lacerator', 'Thrash // Threat', 'Golgari Guildgate', 'Altar of the Goyf', 'Monument to Perfection', 'Yahenni''s Expertise', 'Kozilek''s Predator', 'Deep Analysis', 'Eternal Dragon', 'Vryn Wingmare', 'Nested Shambler', 'Drainpipe Vermin', 'Vraska''s Fall', 'The Seedcore', 'Caves of Koilos', 'Raven''s Crime', 'Llanowar Tribe', 'Hero''s Downfall', 'Gideon''s Intervention', 'Phalanx Leader', 'Ignite Memories', 'Mirage Mirror', 'Zur''s Weirding', 'Rune Snag', 'Snow-Covered Plains', 'Mulch', 'Mindcrank', 'Anafenza, the Foremost', 'Deafening Clarion', 'Ravenous Squirrel', 'Sultai Charm', 'Malicious Malfunction', 'Grenzo, Dungeon Warden', 'Tectonic Giant', 'Wayward Guide-Beast', 'Easy Prey', 'Thassa''s Intervention', 'Rule of Law', 'Haunted Dead', 'Nimble Obstructionist', 'Canopy Vista', 'Brokers Hideout', 'Ossification', 'Drossforge Bridge', 'Arlinn Kord', 'Divest', 'Territorial Kavu', 'Seal of Cleansing', 'Duplicant', 'Scab-Clan Berserker', 'Increasing Ambition', 'Valakut Exploration', 'Thornglint Bridge', 'Mistvault Bridge', 'Sweltering Suns', 'Lotus Cobra', 'Witching Well', 'Orzhov Guildgate', 'Jwari Shapeshifter', 'Ashenmoor Liege', 'Ghostly Pilferer', 'Knight of Glory', 'Mystic Monastery', 'Gruul Guildgate', 'Seething Song', 'Idyllic Beachfront', 'Harmonize', 'Concealing Curtains', 'Karn''s Bastion', 'Joint Exploration', 'Tocasia''s Dig Site', 'Hour of Promise', 'Touch the Spirit Realm', 'Labyrinth of Skophos', 'Rain of Tears', 'Erebos''s Intervention', 'Saproling Migration', 'Sanctum of Ugin', 'Tooth and Nail', 'Cold-Eyed Selkie', 'Rootbound Crag', 'Herd Baloth', 'Contaminated Aquifer', 'Remorseful Cleric', 'Self-Assembler', 'Drake Haven', 'Gateway Plaza', 'Dimensional Infiltrator', 'Teleportation Circle', 'Woodfall Primus', 'Frost Marsh', 'Pull from Tomorrow', 'Toolcraft Exemplar', 'Inkwell Leviathan', 'Lurrus of the Dream-Den', 'Goreclaw, Terror of Qal Sisma', 'Death Cloud', 'Cabaretti Courtyard', 'Sorin, Grim Nemesis', 'Devious Cover-Up', 'Sudden Edict', 'Mistblade Shinobi', 'Silumgar''s Scorn', 'Nekrataal', 'Invasion of Ergamon', 'Soul Warden', 'Disallow', 'Empyrial Armor', 'Urban Evolution', 'Swiftfoot Boots', 'Rishadan Dockhand', 'Aegis of the Gods', 'Ground Seal', 'Elvish Hexhunter', 'Merciless Eviction', 'Thundermaw Hellkite', 'Astral Slide', 'Felidar Cub', 'Gods Willing', 'Maze''s End', 'Odds // Ends', 'Fire Prophecy', 'The Celestus', 'Open the Armory', 'Thornwood Falls', 'Hada Freeblade', 'Scarab Feast', 'Hieroglyphic Illumination', 'Aquitect''s Will', 'Madcap Experiment', 'Goblin Charbelcher', 'Tilling Treefolk', 'Burst Lightning', 'Torens, Fist of the Angels', 'Bogbrew Witch', 'Soul''s Attendant', 'Brave the Elements', 'Barbarian Ring', 'Moon-Circuit Hacker', 'Invoke Calamity', 'Idyllic Tutor', 'Teneb, the Harvester', 'Settle the Wreckage', 'Folio of Fancies', 'Sunblade Samurai', 'Battle of Wits', 'Avacyn''s Pilgrim', 'Sheltered Thicket', 'Tezzeret''s Gambit', 'Mnemonic Sphere', 'Lightning Strike', 'Rust Goliath', 'Froghemoth', 'Thirst for Meaning', 'Sphere of Safety', 'Sunlit Marsh', 'Archaeomancer', 'Phyrexian Dreadnought', 'Shatter the Sky', 'Angel of Condemnation', 'Morsel Theft', 'Fetid Heath', 'River of Tears', 'Esper Charm', 'Fight as One', 'Wall of Omens', 'Kitesail Freebooter', 'Bloodline Keeper', 'Forging the Anchor', 'Sprite Dragon', 'Obliterate', 'Magister of Worth', 'Strike It Rich', 'Bloodchief''s Thirst', 'Selesnya Guildgate', 'Dreadhorde Butcher', 'Dragonskull Summit', 'Tomebound Lich', 'Ad Nauseam', 'Sacred Peaks', 'Kambal, Consul of Allocation', 'Herd Migration', 'Pyretic Ritual', 'Fracturing Gust', 'Ancient Ziggurat', 'Gift of Estates', 'Felidar Retreat', 'Saffi Eriksdotter', 'Solemnity', 'Bident of Thassa', 'Ghostfire Blade', 'Temple of Abandon', 'Marble Diamond', 'Glistener Elf', 'Energy Refractor', 'Doomed Traveler', 'Invasion of Mercadia', 'Murderous Redcap', 'Graveborn Muse', 'Dispatch', 'Llanowar Elves', 'Pelakka Predation', 'Karumonix, the Rat King', 'Simian Sling', 'Archpriest of Shadows', 'Desperate Ritual', 'Mindslaver', 'Zombie Infestation', 'Luminarch Ascension', 'Cleansing Wildfire', 'Lay Down Arms', 'Repeal', 'Clifftop Retreat', 'Corrupted Crossroads', 'Kami of False Hope', 'Frantic Inventory', 'Archon of Sun''s Grace', 'Search for Tomorrow', 'Dokuchi Silencer', 'Sign in Blood', 'Pharika''s Libation', 'Metalwork Colossus', 'Game Trail', 'Boreal Shelf', 'Invisible Stalker', 'Cathedral of War', 'Unmarked Grave', 'Knowledge Pool', 'Triskelion', 'Enchantress''s Presence', 'Urza''s Factory', 'Resurgent Belief', 'Ephara, God of the Polis', 'Summary Dismissal', 'Genesis Ultimatum', 'Prosperous Thief', 'Vines of Vastwood', 'Ponder', 'Izzet Boilerworks', 'Lingering Souls', 'Scrying Sheets', 'Mistcutter Hydra', 'Izzet Guildgate', 'Melira, the Living Cure', 'Yawgmoth''s Bargain', 'Sylvan Library', 'Sphinx''s Herald', 'Become Immense', 'Delay', 'Guile', 'Doomskar', 'Disenchant', 'Nullpriest of Oblivion', 'Watcher for Tomorrow', 'Viashino Pyromancer', 'Briarbridge Tracker', 'Dark Petition', 'Bituminous Blast', 'Greater Tanuki', 'Decree of Justice', 'Caldera Hellion', 'Call of the Death-Dweller', 'Armored Scrapgorger', 'Shred Memory', 'Temple of Mystery', 'Cryptic Caves', 'Ral, Storm Conduit', 'Mistveil Plains', 'Ashnod, Flesh Mechanist', 'Quicken', 'Sins of the Past', 'Hissing Quagmire', 'Launch the Fleet', 'Elvish Archdruid', 'Maestros Charm', 'Silverbluff Bridge', 'Commit // Memory', 'Gloomshrieker', 'Dead of Winter', 'Raze to the Ground', 'Dimir Guildgate', 'Lavinia of the Tenth', 'Rakdos Cackler', 'Melira, Sylvok Outcast', 'Vampire Hexmage', 'Circuit Mender', 'Venerated Loxodon', 'Yorion, Sky Nomad', 'Cut Down', 'Dawn of Hope', 'Glaring Aegis', 'Sever the Bloodline', 'Shardless Agent', 'Spectral Shift', 'Feed the Swarm', 'Distorted Curiosity', 'Lavaclaw Reaches', 'Fierce Empath', 'Phantasmagorian', 'Sterling Grove', 'Tainted Indulgence', 'Kemba, Kha Enduring', 'Quarantine Field', 'Azami, Lady of Scrolls', 'Vivid Grove', 'Aetherworks Marvel', 'Mindsplice Apparatus', 'Umara Wizard', 'Surrak, the Hunt Caller', 'Tymaret, Chosen from Death', 'Golgari Rot Farm', 'Rites of Spring', 'Rise // Fall', 'Inspiring Veteran', 'Falkenrath Pit Fighter', 'Doom Blade', 'Hyena Umbra', 'Godo, Bandit Warlord', 'Chain Lightning', 'Shrieking Affliction', 'Ammit Eternal', 'Succumb to Temptation', 'Flaying Tendrils', 'Frostwalk Bastion', 'Mystifying Maze', 'Jukai Naturalist', 'Boon-Bringer Valkyrie', 'Repudiate // Replicate', 'Minor Misstep', 'Rift Bolt', 'Gruul Spellbreaker', 'Assemble the Legion', 'Blood on the Snow', 'Tezzeret the Schemer', 'Embodiment of Fury', 'Ogre Slumlord', 'Eidolon of Blossoms', 'Agonizing Remorse', 'Makeshift Mannequin', 'Oracle of Mul Daya', 'Pariah', 'Wild Cantor', 'Slaughter Pact', 'Thrill of Possibility', 'Rakdos Charm', 'Galerider Sliver', 'Arcum''s Astrolabe', 'Honor of the Pure', 'Cosmos Elixir', 'Check for Traps', 'Ghitu Lavarunner', 'Dreams of Steel and Oil', 'Kaito, Dancing Shadow', 'Disciple of Bolas', 'Pyroclasm', 'Darksteel Colossus', 'Invasion of Zendikar', 'Silver-Fur Master', 'Into the Story', 'Wandering Fumarole', 'Scrapheap Scrounger', 'Tribal Flames', 'Terramorphic Expanse', 'Tree of Tales', 'Marwyn, the Nurturer', 'Timeless Dragon', 'Angel''s Grace', 'Gleeful Demolition', 'Arbalest Engineers', 'Graaz, Unstoppable Juggernaut', 'Alms of the Vein', 'Halimar Excavator', 'Stinkdrinker Bandit', 'Raise the Alarm', 'Duress', 'Meeting of Minds', 'Blighted Agent', 'Mirror Entity', 'Shinka, the Bloodsoaked Keep', 'Wooded Bastion', 'Incinerate', 'Tendrils of Agony', 'Graven Lore', 'Combat Research', 'Evolving Wilds', 'Gyruda, Doom of Depths', 'Elderscale Wurm', 'Spoils of the Vault', 'Oath of Kaya', 'Mastermind''s Acquisition', 'It That Betrays', 'Cloudpost', 'Kemba, Kha Regent', 'Dead Weight', 'Anafenza, Kin-Tree Spirit', 'Commune with Nature', 'Liquimetal Coating', 'Evacuation', 'Nether Spirit', 'General Ferrous Rokiric', 'Hall of Oracles', 'Wrenn''s Resolve', 'Ranger of Eos', 'Commence the Endgame', 'Vampire Nighthawk', 'Abzan Charm', 'Phantasmal Image', 'Gilt-Leaf Archdruid', 'Invigorate', 'Children of Korlis', 'Angrath, the Flame-Chained', 'Elvish Rejuvenator', 'Voidslime', 'Fearless Fledgling', 'Healer''s Hawk', 'Cultivate', 'Pieces of the Puzzle', 'Bone Shards', 'Leonin Warleader', 'Consuming Vapors', 'Knight of New Alara', 'Nature''s Lore', 'Condemn', 'Pack Rat', 'Nightscape Familiar', 'Search for Azcanta', 'Benevolent Bodyguard', 'Kruphix''s Insight', 'Hideous End', 'Yavimaya Coast', 'Network Disruptor', 'Bogardan Hellkite', 'Surge of Salvation', 'Teferi, Mage of Zhalfir', 'Cremate', 'Loxodon Smiter', 'Kor Firewalker', 'Timeless Witness', 'Staff of Domination', 'Opulent Palace', 'Brineborn Cutthroat', 'Brave the Sands', 'Murderous Cut', 'Unctus, Grand Metatect', 'Voldaren Pariah', 'Merfolk Sovereign', 'Thaumatic Compass', 'Bolas''s Citadel', 'Arch of Orazca', 'Dovin''s Acuity', 'Yasharn, Implacable Earth', 'Recurring Nightmare', 'Cartel Aristocrat', 'Thraben Inspector', 'Drowned Catacomb', 'Empyrial Plate', 'Rakdos Guildgate', 'Angel of Serenity', 'Rotting Rats', 'Day of Judgment', 'Solitary Confinement', 'Double Vision', 'Unburial Rites', 'Goldmire Bridge', 'Price of Progress', 'Reveillark', 'Sarkhan the Masterless', 'Sarkhan, the Dragonspeaker', 'Sunpetal Grove', 'Racers'' Ring', 'Mana Leak', 'Kazandu Blademaster', 'Cathartic Reunion', 'Phoenix Chick', 'Burning Sun''s Fury', 'Ancient Grudge', 'Elixir of Immortality', 'Teshar, Ancestor''s Apostle', 'Ivory Tower', 'Azorius Charm', 'Knight of the Reliquary', 'Celestial Colonnade', 'Balustrade Spy', 'Steel Overseer', 'Mausoleum Secrets', 'Ertai''s Scorn', 'Stoke the Flames', 'Unlucky Witness', 'Sandsteppe Citadel', 'Timely Reinforcements', 'Thawing Glaciers', 'Myr Kinsmith', 'Flame Rift', 'Grave Titan', 'Precursor Golem', 'Crux of Fate', 'Tear Asunder', 'Castigate', 'Aetherling', 'Kogla, the Titan Ape', 'Master of Death', 'Purify the Grave', 'Gitaxian Probe', 'Dread Return', 'Simic Guildgate', 'Quest for the Holy Relic', 'Hostage Taker', 'Squee, Goblin Nabob', 'Far // Away', 'Nimble Larcenist', 'Detention Sphere', 'Satyr Hoplite', 'Vault Skirge', 'Bala Ged Recovery', 'Vampire Neonate', 'Gravelgill Duo', 'Demigod of Revenge', 'Defiant Strike', 'Ethereal Armor', 'Flourishing Fox', 'Mina and Denn, Wildborn', 'Stoic Rebuttal', 'Fiery Temper', 'Arcbound Ravager', 'Garruk Wildspeaker', 'Chandra, Fire Artisan', 'Throne of the God-Pharaoh', 'Natural State', 'Deep Forest Hermit', 'Archangel of Wrath', 'Forked Bolt', 'Mouth of Ronom', 'Benalish Marshal', 'Heap Doll', 'Tolarian Terror', 'Worthy Knight', 'Jungle Shrine', 'Vivid Crag', 'Haunted Mire', 'Viscera Seer', 'Dread Wanderer', 'Simian Spirit Guide', 'Blood Artist', 'Gift of Immortality', 'Unstable Mutation', 'Bloodchief Ascension', 'Wanderwine Hub', 'Ash Zealot', 'Protect the Negotiators', 'White Sun''s Zenith', 'Phyrexian Censor', 'Dire-Strain Rampage', 'Coiling Oracle', 'Heartless Act', 'Swooping Lookout', 'Platinum Angel', 'Otherworldly Journey', 'Cabal Ritual', 'Frost Titan', 'Grimoire Thief', 'Lochmere Serpent', 'Sea Gate Oracle', 'Second Sunrise', 'Kefnet the Mindful', 'Tezzeret, Artifice Master', 'Kappa Tech-Wrecker', 'Ivy Lane Denizen', 'Blightning', 'Fetid Pools', 'Shriekmaw', 'Halo Forager', 'Basilisk Collar', 'Sunken Hollow', 'Boros Guildgate', 'Smother', 'Triumphant Adventurer', 'Glamerdye', 'Shape Anew', 'Diabolic Tutor', 'Ethersworn Sphinx', 'Snow-Covered Mountain', 'Restoration Angel', 'Bubbling Muck', 'Wizard''s Retort', 'Reckless Charge', 'Flametongue Kavu', 'Putrefy', 'Vessel of Nascency', 'Lizard Blades', 'Diffusion Sliver', 'Hope of Ghirapur', 'Inevitable Betrayal', 'Glimpse of Tomorrow', 'Llanowar Mentor', 'Geyadrone Dihada', 'Vindictive Flamestoker', 'Slagwoods Bridge', 'Unsubstantiate', 'Argentum Armor', 'Temple of Malady', 'Angel of Glory''s Rise', 'Always Watching', 'Vigor', 'Martyr of Sands', 'Glimmerpost', 'Twinshot Sniper', 'Exclude', 'Malcator, Purity Overseer', 'Hero of Oxid Ridge', 'Terastodon', 'Bitter Reunion', 'Festering Newt', 'Elvish Visionary', 'Temple of Silence', 'Bloodvial Purveyor', 'Oracle of Tragedy', 'Nezumi Informant', 'Universal Automaton', 'Woe Strider', 'Elspeth Conquers Death', 'Approach of the Second Sun', 'Mulldrifter', 'Sylvan Scrying', 'Spirited Companion', 'Invasion of Amonkhet', 'Stave Off', 'Greater Gargadon', 'Ulcerate', 'Into the Roil', 'Fireblade Charger', 'Llanowar Augur', 'Chandra, Pyromaster', 'Knight Exemplar', 'Eiganjo Castle', 'Sin Collector', 'Sigrid, God-Favored', 'Cloudshredder Sliver', 'Fallaji Archaeologist', 'Jokulhaups', 'Ghost Quarter', 'Sunder Shaman', 'Cauldron Familiar', 'Gather the Pack', 'Myr Battlesphere', 'Aetherblade Agent', 'Seal of Removal', 'Gnat Miser', 'Pardic Miner', 'Stir the Grave', 'Rise and Shine', 'Talisman of Impulse', 'Burning of Xinye', 'Changeling Outcast', 'Mephidross Vampire', 'Temple of Triumph', 'Drowned Rusalka', 'Duneblast', 'Mikokoro, Center of the Sea', 'Mortuary Mire', 'Artistic Refusal', 'Silundi Vision', 'Zephyr Singer', 'Lotleth Giant', 'Obstinate Baloth', 'Commune with the Gods', 'Trace of Abundance', 'Acidic Slime', 'Heliod''s Pilgrim', 'Wrath of God', 'Dryad Militant', 'Syphon Life', 'Tangled Islet', 'Blackbloom Rogue', 'Devout Chaplain', 'Herald of the Pantheon', 'Midnight Reaper', 'Hanweir Garrison', 'Aether Spellbomb', 'Supreme Will', 'Chief of the Foundry', 'Experimental Synthesizer', 'Archangel Avacyn', 'Serra Ascendant', 'Stupor', 'Shizo, Death''s Storehouse', 'Needle Spires', 'Evangel of Synthesis', 'Slogurk, the Overslime', 'Goblin Dark-Dwellers', 'Spirit Mantle', 'Ishkanah, Grafwidow', 'Discovery // Dispersal', 'Tendo Ice Bridge', 'Early Harvest', 'Sol Talisman', 'Late to Dinner', 'Ancient Amphitheater', 'Blight Mamba', 'Annex Sentry', 'Darksteel Citadel', 'Thragtusk', 'Plated Geopede', 'Curiosity', 'Founding the Third Path', 'Wonder', 'Faeburrow Elder', 'Sandwurm Convergence', 'Merfolk Mistbinder', 'Snow-Covered Swamp', 'Harrow', 'Pyrite Spellbomb', 'Council''s Judgment', 'Upheaval', 'Stone Rain', 'Tide Shaper', 'Endless Horizons', 'Ajani''s Pridemate', 'World Shaper', 'Experimental Augury', 'Deprive', 'Earthshaker Khenra', 'Pilfer', 'See Beyond', 'The Underworld Cookbook', 'Nomad Outpost', 'Ensoul Artifact', 'Ruric Thar, the Unbowed', 'The Flame of Keld', 'Chandra, Flamecaller', 'Cabal Therapist', 'Etherium Sculptor', 'Winds of Abandon', 'Jwari Disruption', 'Dissolve', 'Bloodsoaked Champion', 'Kunoros, Hound of Athreos', 'Zof Consumption', 'Temple of Enlightenment', 'Chief Engineer', 'Kessig Wolf Run', 'Voyaging Satyr', 'Kor Skyfisher', 'Genesis Hydra', 'Misery Charm', 'Maelstrom Pulse', 'Oona''s Grace', 'Rakdos''s Return', 'Buried Ruin', 'Cataclysmic Gearhulk', 'Skarrg, the Rage Pits', 'Encroaching Wastes', 'Tempest Djinn', 'Flooded Grove', 'Elite Inquisitor', 'Seal of Fire', 'Faerie Conclave', 'Pharika''s Cure', 'Victim of Night', 'Grand Abolisher', 'Forsake the Worldly', 'Judge''s Familiar', 'Temple of Deceit', 'Rix Maadi Reveler', 'Altar of the Brood', 'Oona''s Prowler', 'Tyrant of Discord', 'Demonic Bargain', 'Tresserhorn Sinks', 'Lonely Sandbar', 'Scrapwork Mutt', 'Yisan, the Wanderer Bard', 'Angel of Despair', 'Seeker of the Way', 'Notorious Throng', 'Riveteers Overlook', 'Gird for Battle', 'Voidwing Hybrid', 'Collected Conjuring', 'Forbidden Alchemy', 'Realm Razer', 'General''s Enforcer', 'Kaya, Ghost Assassin', 'Nezahal, Primal Tide', 'Presence of Gond', 'Whispersilk Cloak', 'Dying to Serve', 'Fyndhorn Elves', 'Venerable Knight', 'Drowner of Hope', 'Hedron Archive', 'Krosan Grip', 'Executioner''s Capsule', 'Grolnok, the Omnivore', 'Scuttling Doom Engine', 'Orim''s Chant', 'Aetherspouts', 'Destiny Spinner', 'Ancient Stirrings', 'Venser, Shaper Savant', 'Wasteland Strangler', 'Riveteers Charm', 'Nezumi Graverobber', 'Rampant Growth', 'Dissipate', 'Scrabbling Claws', 'Molten Tributary', 'Vraan, Executioner Thane', 'Abyssal Persecutor', 'Treasure Cruise', 'Union of the Third Path', 'Vampiric Rites', 'Dregscape Zombie', 'Crawling Chorus', 'Canyon Slough', 'Mishra''s Factory', 'Lantern-Lit Graveyard', 'Skyclave Shade', 'Blanchwood Prowler', 'Brain Freeze', 'Satyr Wayfinder', 'Faith''s Reward', 'Mesmeric Fiend', 'Nissa, Steward of Elements', 'Pulse of the Fields', 'Draugr Necromancer', 'Careful Cultivation', 'Think Twice', 'The Birth of Meletis', 'Sea-Dasher Octopus', 'Jace, Architect of Thought', 'Distended Mindbender', 'Sire of Insanity', 'Nissa, Worldwaker', 'Ramunap Excavator', 'Dark Ritual', 'Forgotten Cave', 'Grafted Butcher', 'Dauntless Bodyguard', 'Radiant Grove', 'Bloodbraid Elf', 'Lodestone Golem', 'Bontu''s Last Reckoning', 'Sulfur Falls', 'Reinforced Ronin', 'Audacity', 'Secluded Courtyard', 'Sylvan Caryatid', 'Destroy Evil', 'Myth Realized', 'Abiding Grace', 'Night of Souls'' Betrayal', 'Temple of Plenty', 'Hesitation', 'Progenitor Exarch', 'The Scorpion God', 'Stubborn Denial', 'Rabbit Battery', 'Mirran Crusader', 'Moorland Haunt', 'Quiet Speculation', 'Consult the Necrosages', 'Fruit of Tizerus', 'Carven Caryatid', 'Verduran Enchantress', 'Mesa Enchantress', 'Sorin, Vengeful Bloodlord', 'Gigadrowse', 'Neutralize', 'Disrupting Shoal', 'Kher Keep', 'Weapons Trainer', 'Baneful Omen', 'Calciform Pools', 'Porphyry Nodes', 'Stasis Snare', 'Sheoldred''s Edict', 'Worship', 'Seismic Assault', 'Lightning Spear', 'Spell Burst', 'Tribute to Hunger', 'Consume the Meek', 'Negate', 'Control Magic', 'Norn''s Inquisitor', 'Leonin Arbiter', 'Rustvale Bridge', 'Lagrella, the Magpie', 'Ancestral Blade', 'Sunstrike Legionnaire', 'Gruul Turf', 'Tanglepool Bridge', 'Epic Experiment', 'Black Sun''s Zenith', 'Demolition Field', 'Faerie Miscreant', 'Shimmer Dragon', 'Dusk // Dawn', 'Silumgar, the Drifting Death', 'Mycosynth Golem', 'Anguished Unmaking', 'Malakir Rebirth', 'Gaea''s Will', 'Blazing Rootwalla', 'Silent Gravestone', 'Frontier Bivouac', 'Gadrak, the Crown-Scourge', 'Fleecemane Lion', 'Ornithopter', 'Research // Development', 'Altered Ego', 'Spatial Contortion', 'Brainstone', 'Yavimaya Iconoclast', 'Azorius Guildgate', 'Glacial Fortress', 'Putrid Imp', 'Fumigate', 'Jor Kadeen, First Goldwarden', 'Spikefield Hazard', 'Prophetic Prism', 'Ichorclaw Myr', 'Mind''s Desire', 'Vault of the Archangel', 'Out of Time', 'Elves of Deep Shadow', 'Groundswell', 'Zuran Orb', 'Glint-Sleeve Siphoner', 'Fact or Fiction', 'Fade from Memory', 'Servo Exhibition', 'Tectonic Edge', 'Expedite', 'Botanical Plaza', 'Necrogen Spellbomb', 'Venser, the Sojourner', 'Crack the Earth', 'Might of Old Krosa', 'Loran''s Escape', 'Liquimetal Torque', 'Titania, Protector of Argoth', 'Talisman of Curiosity', 'Utter End', 'Grand Architect', 'Arguel''s Blood Fast', 'Merrow Reejerey', 'Glissa Sunseeker', 'Waking the Trolls', 'Reckless Rage', 'Rites of Initiation', 'Haunted Fengraf', 'Izzet Charm', 'Return to the Ranks', 'Phyrexian Revoker', 'Weathered Wayfarer', 'Acclaimed Contender', 'Invasion of Regatha', 'Fertile Ground', 'Forbid', 'Raging Ravine', 'Slagstorm', 'Knight of the White Orchid', 'Seedcradle Witch'))) 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, 2.7, mysql)
Reported on decksite by mysql-perf
Location Hash: 06c3803cc2b9f219a83e956ba3c4440c64270e11
Labels: decksite
[](slow_query, 2.6, mysql)Reported on decksite by mysql-perf
Location Hash: 06c3803cc2b9f219a83e956ba3c4440c64270e11