vorpal-buildbot
commented
1 year ago Exceeded slow_query limit (61.8 > 60.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 ('Tribute to Horobi', 'Tainted Indulgence', 'Reaper King', 'Vivid Creek', 'Wall of Blossoms', 'Endbringer', 'Mission Briefing', 'Arbor Elf', 'Krosan Wayfarer', 'Atarka, World Render', 'Kitesail Freebooter', 'Inkwell Leviathan', 'Putrid Goblin', 'Darkmoss Bridge', 'Sultai Charm', 'Bump in the Night', 'Myr Landshaper', 'Llanowar Stalker', 'Teachings of the Kirin', 'Maestros Theater', 'Sylvan Scrying', 'Basking Rootwalla', 'Diminish', 'Glimmer Bairn', 'Daring Buccaneer', 'Glimmerpoint Stag', 'Price of Progress', 'Grapple with the Past', 'Rustvale Bridge', 'Quicken', 'Ravaging Blaze', 'Silverbluff Bridge', 'Pollenbright Wings', 'Inscription of Ruin', 'Savage Beating', 'Chandra, Pyromaster', 'Lizard Blades', 'Eye of Nowhere', 'Barbarian Ring', 'Curse of Exhaustion', 'Rivaz of the Claw', 'Brokers Hideout', 'Venerated Loxodon', 'Devious Cover-Up', 'Gruul Spellbreaker', 'Reclamation Sage', 'Putrefy', 'Sword of Kaldra', 'Temple of Malady', 'Teferi, Mage of Zhalfir', 'Akoum Warrior', 'Praetor''s Grasp', 'Crumbling Vestige', 'Golden Wish', 'Halimar Depths', 'Into the Roil', 'Shambling Vent', 'Snow-Covered Swamp', 'Endless One', 'Kessig Wolf Run', 'Planebound Accomplice', 'Dragon Tempest', 'Notion Thief', 'Bala Ged Recovery', 'Glint Hawk', 'Boon Satyr', 'Disrupting Shoal', 'Into the North', 'Cloudpost', 'Balmor, Battlemage Captain', 'Zof Consumption', 'Nephalia Drownyard', 'Goblin Instigator', 'Night Market Lookout', 'Gigantomancer', 'Grim Initiate', 'Sheltered Thicket', 'World at War', 'Radha''s Firebrand', 'Kambal, Consul of Allocation', 'Alms of the Vein', 'Sylvan Messenger', 'Dihada''s Ploy', 'Gilded Lotus', 'Apex of Power', 'Restoration Angel', 'Mizzium Mortars', 'Spoils of the Vault', 'Broodhatch Nantuko', 'Swiftwater Cliffs', 'Boros Reckoner', 'Irencrag Feat', 'Trickbind', 'Implement of Improvement', 'Sign in Blood', 'Ertai''s Scorn', 'Bone Saw', 'Heartless Act', 'Risk Factor', 'Traverse the Ulvenwald', 'Zombie Infestation', 'Desert of the Glorified', 'Soul Stair Expedition', 'Umezawa''s Charm', 'Mist-Syndicate Naga', 'Treasure Cruise', 'Grasping Dunes', 'Naru Meha, Master Wizard', 'Kari Zev''s Expertise', 'Raging Ravine', 'Thalia, Heretic Cathar', 'Electrolyze', 'Phantasmagorian', 'Disciple of the Vault', 'Dreamtail Heron', 'Pillage', 'Thoughts of Ruin', 'Ral, Izzet Viceroy', 'Shrine of Burning Rage', 'Lava Coil', 'Oath of Teferi', 'Inquisitive Puppet', 'Barbed Spike', 'Skemfar Avenger', 'Dimir Signet', 'Domri Rade', 'Madcap Experiment', 'Slagstorm', 'Lost Auramancers', 'Riveteers Overlook', 'The Flame of Keld', 'Rite of Consumption', 'Radiant Flames', 'Skarrgan Pit-Skulk', 'Tolarian Terror', 'Reptilian Reflection', 'Slaughter Pact', 'Mishra''s Factory', 'Arlinn Kord', 'Memory Leak', 'Skyshroud Ranger', 'Exhaustion', 'Quiet Speculation', 'Radha, Heir to Keld', 'Monk Idealist', 'Retract', 'Bogardan Hellkite', 'Blackmail', 'Mystic Crusader', 'Renegade Tactics', 'Jolrael, Mwonvuli Recluse', 'Night Clubber', 'Brain Maggot', 'Jaya Ballard', 'Boon of the Wish-Giver', 'Strike It Rich', 'Sylvan Ranger', 'Renewed Faith', 'Sea-Dasher Octopus', 'Goblin Chieftain', 'Haakon, Stromgald Scourge', 'Tireless Provisioner', 'Brushfire Elemental', 'Stirring Wildwood', 'Safehold Elite', 'Balustrade Spy', 'Wasitora, Nekoru Queen', 'Eye of Vecna', 'Spring-Leaf Avenger', 'Dire Fleet Poisoner', 'Champion of Wits', 'Golgari Brownscale', 'Aegis of the Gods', 'Lightning Rift', 'Magister of Worth', 'Temple of Abandon', 'Seething Song', 'Vivid Grove', 'Oath of Gideon', 'Flamewake Phoenix', 'Aven Heartstabber', 'Master of Death', 'Vraska''s Contempt', 'Burst Lightning', 'Tenth District Legionnaire', 'Neheb, the Eternal', 'Hero''s Downfall', 'Sterling Grove', 'Shaile, Dean of Radiance', 'Glittering Wish', 'Bane of Bala Ged', 'Keldon Megaliths', 'Grumgully, the Generous', 'Hushwing Gryff', 'Captain Lannery Storm', 'Force of Virtue', 'Surrak, the Hunt Caller', 'Razortide Bridge', 'Rapid Hybridization', 'Savage Lands', 'Vryn Wingmare', 'Plaza of Harmony', 'Cultivator of Blades', 'Dance of the Manse', 'Drannith Healer', 'Lumbering Falls', 'Giant Growth', 'Arctic Flats', 'Sarkhan Vol', 'Eiganjo Castle', 'Zenith Flare', 'Fatal Grudge', 'Tibalt''s Trickery', 'Aetherspouts', 'Ghostfire Blade', 'Nicol Bolas, God-Pharaoh', 'Forbid', 'Ayara, First of Locthwain', 'Abundant Harvest', 'Memory''s Journey', 'Fog', 'Fetid Pools', 'Kogla, the Titan Ape', 'Thunderbreak Regent', 'Ominous Seas', 'Elder Mastery', 'Verix Bladewing', 'The Modern Age', 'Drowner of Hope', 'Fall of the Thran', 'Increasing Ambition', 'Divest', 'Embereth Shieldbreaker', 'Thieving Skydiver', 'Kumano Faces Kakkazan', 'Collected Conjuring', 'Diabolic Edict', 'Wilt', 'Orcish Lumberjack', 'Jaddi Offshoot', 'Vance''s Blasting Cannons', 'Slaying Fire', 'Shrapnel Blast', 'Force of Rage', 'Mass Hysteria', 'Boreal Druid', 'Great Sable Stag', 'Dismal Backwater', 'Dimir Charm', 'Lead the Stampede', 'Scout''s Warning', 'Curiosity', 'Bearer of Silence', 'Myr Superion', 'Seal of Fire', 'Fracturing Gust', 'Patchwork Automaton', 'Colossification', 'Howling Mine', 'Temple of Malice', 'Fists of Ironwood', 'Pelakka Wurm', 'Tattermunge Maniac', 'Tainted Remedy', 'Makeshift Mannequin', 'Grim Lavamancer', 'Power Depot', 'Genesis Hydra', 'Sphere of Safety', 'Hornet Nest', 'Idyllic Beachfront', 'Fire Prophecy', 'Young Wolf', 'Semester''s End', 'Sandwurm Convergence', 'Obscura Storefront', 'Chandra Nalaar', 'Blacklance Paragon', 'Village Messenger', 'Malakir Rebirth', 'Domri''s Ambush', 'Cabal Stronghold', 'Dirge Bat', 'Terrarion', 'Pelt Collector', 'Brain Freeze', 'Elixir of Immortality', 'Mind Funeral', 'Run Amok', 'Stormfist Crusader', 'Emeria, the Sky Ruin', 'Obscura Charm', 'Ivy Lane Denizen', 'Bygone Bishop', 'Joraga Treespeaker', 'Arcane Sanctum', 'Everflowing Chalice', 'Fiend Hunter', 'Doom Blade', 'Despoiler of Souls', 'Forked Bolt', 'Bloodthrone Vampire', 'Archon of Sun''s Grace', 'Raise the Alarm', 'Kor Skyfisher', 'Bone Shards', 'Scattered Groves', 'Corrupted Crossroads', 'Temple of Deceit', 'Chandra, Flamecaller', 'Dead Weight', 'Obsessive Search', 'Sarkhan, the Dragonspeaker', 'Game Trail', 'Escape to the Wilds', 'Bone Dragon', 'Oath of Chandra', 'Sprite Dragon', 'Quarantine Field', 'Silence', 'Yidaro, Wandering Monster', 'Curse of Misfortunes', 'The Underworld Cookbook', 'Ritual of Soot', 'Lost Legacy', 'Vitu-Ghazi, the City-Tree', 'Izzet Boilerworks', 'Barkhide Troll', 'Nevermore', 'Search for Tomorrow', 'Deprive', 'Possibility Storm', 'Goblin Bombardment', 'Banishing Slash', 'Priest of the Haunted Edge', 'Hard Evidence', 'Smiting Helix', 'Invigorate', 'Omen of the Sea', 'Flinthoof Boar', 'Oblivion Ring', 'Saproling Migration', 'Fanatical Firebrand', 'Kyodai, Soul of Kamigawa', 'Tasigur, the Golden Fang', 'Nightscape Familiar', 'Storm Entity', 'Crux of Fate', 'Bloodline Keeper', 'Coldsteel Heart', 'Qasali Pridemage', 'Dusk Mangler', 'Chandra, the Firebrand', 'Garruk Wildspeaker', 'Mistvault Bridge', 'Izzet Guildgate', 'Hapless Researcher', 'Treasure Map', 'Consume the Meek', 'Abrade', 'Scurry Oak', 'Hinterland Harbor', 'Haunted Mire', 'Barbed Sextant', 'Voldaren Pariah', 'King Darien XLVIII', 'Mortician Beetle', 'Villainous Wealth', 'Out of Time', 'Tendrils of Agony', 'Urza''s Rage', 'Blue Sun''s Zenith', 'The Cauldron of Eternity', 'Vraska, Relic Seeker', 'Incinerate', 'Polukranos, Unchained', 'Possessed Portal', 'Relentless Assault', 'Deathless Knight', 'Cruel Edict', 'Graven Cairns', 'Boomerang', 'Lathliss, Dragon Queen', 'Terror of Mount Velus', 'Wooded Ridgeline', 'Radiant Grove', 'Enduring Ideal', 'Gatekeeper of Malakir', 'Rhys the Redeemed', 'Ambush Viper', 'Nine Lives', 'Volcano Hellion', 'Deranged Hermit', 'Tresserhorn Sinks', 'Seasoned Hallowblade', 'Mystifying Maze', 'Skyblade''s Boon', 'Jace Beleren', 'Looming Spires', 'Braid of Fire', 'Dark Ritual', 'Nadaar, Selfless Paladin', 'The Phasing of Zhalfir', 'Goldmire Bridge', 'Tameshi, Reality Architect', 'Sickening Dreams', 'Blistercoil Weird', 'Lonely Sandbar', 'Blightning', 'Pact of the Titan', 'Devastating Summons', 'Benevolent Bodyguard', 'Ash Zealot', 'Changeling Outcast', 'Wall of Omens', 'Elvish Lyrist', 'Mizzium Skin', 'Verdant Command', 'Jokulhaups', 'Mindslaver', 'Induced Amnesia', 'Gruul Guildgate', 'Crawling Barrens', 'Ghor-Clan Rampager', 'Cloudshift', 'Shrine of the Forsaken Gods', 'Electrostatic Infantry', 'Liquimetal Coating', 'Soul''s Attendant', 'Goblin Anarchomancer', 'Orzhov Pontiff', 'Sphinx''s Tutelage', 'Bond of Flourishing', 'Strategic Planning', 'Timeless Dragon', 'Mirran Crusader', 'Doom Foretold', 'Spellbook', 'Nevermaker', 'Awakening Zone', 'Yosei, the Morning Star', 'Authority of the Consuls', 'Dark Petition', 'Collective Effort', 'Reality Acid', 'Rootbound Crag', 'Reckless Charge', 'Battle of Wits', 'Tangled Florahedron', 'Baru, Fist of Krosa', 'Sky Tether', 'Darigaaz Reincarnated', 'Prophetic Bolt', 'Rise // Fall', 'Bastion of Remembrance', 'Esper Charm', 'Nevinyrral''s Disk', 'Voidslime', 'Rampant Growth', 'Archfiend''s Vessel', 'Man-o''-War', 'Thorn of Amethyst', 'Josu Vess, Lich Knight', 'Tear Asunder', 'Sweltering Suns', 'Summoning Station', 'Perilous Research', 'Porphyry Nodes', 'Coiling Oracle', 'Colossal Might', 'Darksteel Relic', 'Burning of Xinye', 'Tamiyo''s Safekeeping', 'Invoke the Ancients', 'Ball Lightning', 'Immersturm Predator', 'Desert of the True', 'Fearless Pup', 'Stormcaller''s Boon', 'Ghitu Lavarunner', 'Crack the Earth', 'Battle Mastery', 'Waterveil Cavern', 'Temple of Enlightenment', 'Unburial Rites', 'Experimental Frenzy', 'Empty the Warrens', 'Expedite', 'Shadow-Rite Priest', 'Tangle', 'Flood Plain', 'Hazoret''s Undying Fury', 'Neutralize', 'Boros Guildgate', 'Rakdos Guildgate', 'Grazilaxx, Illithid Scholar', 'Nested Shambler', 'Scourge Devil', 'Garruk Relentless', 'Selesnya Guildgate', 'Rakdos Cackler', 'Simian Sling', 'Gavony Township', 'Honor of the Pure', 'Call the Bloodline', 'Scaled Herbalist', 'Ninth Bridge Patrol', 'Ornithopter', 'Voltage Surge', 'Dromoka''s Command', 'Smuggler''s Copter', 'Rime Tender', 'Thirst for Knowledge', 'Drannith Stinger', 'Flametongue Kavu', 'Seal of Removal', 'Vapor Snag', 'Archaeomancer', 'Merfolk Looter', 'Elas il-Kor, Sadistic Pilgrim', 'Lantern-Lit Graveyard', 'Tourach''s Canticle', 'Kolaghan, the Storm''s Fury', 'Prodigious Growth', 'Jace, Architect of Thought', 'Niv-Mizzet, Parun', 'Thopter Foundry', 'Sarkhan the Mad', 'Draconic Roar', 'Fact or Fiction', 'Hall of Oracles', 'Skymarcher Aspirant', 'Fists of Flame', 'Garruk''s Harbinger', 'Feast of Sanity', 'Momentary Blink', 'Kindle', 'Judge''s Familiar', 'Sin Collector', 'Forgotten Cave', 'Chandra''s Regulator', 'Inspiring Overseer', 'Urza''s Factory', 'Eidolon of Obstruction', 'Contaminated Aquifer', 'Salvage Titan', 'Pain Seer', 'Primal Might', 'Torrent Sculptor', 'Magus of the Scroll', 'Jace, Memory Adept', 'Ruric Thar, the Unbowed', 'Martyr of Sands', 'Maze''s End', 'Orzhov Signet', 'Domri, Anarch of Bolas', 'Agonizing Remorse', 'Regal Caracal', 'Merfolk Secretkeeper', 'Opt', 'Bedeck // Bedazzle', 'March of Swirling Mist', 'Angelic Destiny', 'Shining Shoal', 'See the Unwritten', 'Favored Hoplite', 'Fiery Temper', 'Temporal Adept', 'Crystal Grotto', 'See Beyond', 'Mana Leak', 'Imposing Vantasaur', 'Izzet Charm', 'Arguel''s Blood Fast', 'Rob the Archives', 'Cleric of Life''s Bond', 'Elemental Bond', 'Jungleborn Pioneer', 'Reap the Past', 'Disdainful Stroke', 'March of Reckless Joy', 'Mirari''s Wake', 'Thornwood Falls', 'Warped Devotion', 'Sire of Insanity', 'Crash Through', 'Sacred Peaks', 'Walking Atlas', 'Wasteland Strangler', 'Big Game Hunter', 'End-Raze Forerunners', 'Aether Adept', 'Lapse of Certainty', 'Wayward Swordtooth', 'Raking Claws', 'Chandra, Fire of Kaladesh', 'Condescend', 'Foundry Street Denizen', 'Caustic Caterpillar', 'Llanowar Tribe', 'Llanowar Elves', 'Char', 'Benalish Marshal', 'Distended Mindbender', 'Priest of Urabrask', 'Vivien, Champion of the Wilds', 'Banefire', 'Curious Pair', 'Liquimetal Torque', 'Balduvian Trading Post', 'Witherbloom Campus', 'Timeless Witness', 'Tombstalker', 'Chained to the Rocks', 'Rally the Ancestors', 'Midnight Clock', 'Drizzt Do''Urden', 'Hour of Promise', 'Clifftop Retreat', 'Panoptic Mirror', 'Gods'' Eye, Gate to the Reikai', 'Breya''s Apprentice', 'Elemental Mastery', 'Undercity Informer', 'Unholy Heat', 'Disenchant', 'Nivix Cyclops', 'Obscura Ascendancy', 'Greater Gargadon', 'Day of Judgment', 'Unearth', 'Hatching Plans', 'Illuminator Virtuoso', 'Glorybringer', 'Defiant Strike', 'Crackling Doom', 'Kitchen Imp', 'Flame Blitz', 'Experiment One', 'Mnemonic Wall', 'Walk the Aeons', 'Tectonic Edge', 'Forerunner of the Coalition', 'Nemata, Primeval Warden', 'Gallia of the Endless Dance', 'Sunlit Marsh', 'Dauntless Bodyguard', 'Protean Hulk', 'Volcanic Salvo', 'Chandra, Novice Pyromancer', 'Leonin Lightscribe', 'Azorius Charm', 'Wash Out', 'Woodland Champion', 'Draining Whelk', 'Verdurous Gearhulk', 'Chandra, Fire Artisan', 'Nimbus Maze', 'Gitaxian Probe', 'Mistveil Plains', 'Dissipate', 'Deny Reality', 'Tyrant''s Scorn', 'Blessed Respite', 'Baffling End', 'Mist-Cloaked Herald', 'Hypnotic Specter', 'Arcum''s Astrolabe', 'Locket of Yesterdays', 'Chandra''s Pyrohelix', 'Lightning Axe', 'Kazandu Refuge', 'Turnabout', 'Night of Souls'' Betrayal', 'Vivid Marsh', 'Temple of Silence', 'Beacon of Creation', 'Seaside Citadel', 'Siege Rhino', 'Stronghold Arena', 'Sylvan Library', 'Ivy, Gleeful Spellthief', 'Squee, Goblin Nabob', 'Gods Willing', 'Angel of Glory''s Rise', 'Dream Twist', 'Mikaeus, the Lunarch', 'Temple of Plenty', 'Gravelighter', 'Scalding Cauldron', 'Thassa''s Intervention', 'Jungle Hollow', 'Control Magic', 'Dwynen, Gilt-Leaf Daen', 'Astral Slide', 'Froghemoth', 'Luminarch Ascension', 'Urza Assembles the Titans', 'Spore Frog', 'Form of the Dragon', 'Stubborn Denial', 'Slaughter Games', 'Botanical Plaza', 'Gadwick, the Wizened', 'Deep Forest Hermit', 'Consult the Necrosages', 'Suture Priest', 'Countryside Crusher', 'Imperial Mask', 'Sylvan Advocate', 'Arni Slays the Troll', 'Herald of Anguish', 'Izzet Signet', 'Evolving Wilds', 'Blessed Alliance', 'Cut Down', 'Dreadhorde Invasion', 'Approach of the Second Sun', 'Sorin, Vengeful Bloodlord', 'Skybind', 'Kabira Takedown', 'Delver of Secrets', 'Profane Command', 'Boros Garrison', 'Brokkos, Apex of Forever', 'Selfless Savior', 'Anafenza, Kin-Tree Spirit', 'Death Baron', 'Cruel Reality', 'Aetherling', 'Soul Spike', 'Eldrazi Mimic', 'Pyretic Ritual', 'Harmonize', 'Reckless Fireweaver', 'Jadelight Ranger', 'Zhur-Taa Goblin', 'Immolating Souleater', 'Opulent Palace', 'Colossal Skyturtle', 'Mogg War Marshal', 'Liliana Vess', 'Valakut Exploration', 'Intervention Pact', 'Rule of Law', 'Myr Battlesphere', 'Ancient Stirrings', 'Phylath, World Sculptor', 'Shore Up', 'Leatherback Baloth', 'Dire Fleet Daredevil', 'Thaumatic Compass', 'Sorin Markov', 'Kathari Remnant', 'Earwig Squad', 'Gladecover Scout', 'Jinnie Fay, Jetmir''s Second', 'Skyclave Cleric', 'Witching Well', 'Blackbloom Rogue', 'Burning-Tree Emissary', 'Secluded Steppe', 'Spell Burst', 'Mathas, Fiend Seeker', 'Tanglepool Bridge', 'Seasons Past', 'Goblin Electromancer', 'Dovescape', 'Yavimaya Iconoclast', 'Ilysian Caryatid', 'Blood Sun', 'Story Circle', 'Tidehollow Sculler', 'Solar Blast', 'Lazotep Reaver', 'Kavu Predator', 'Double Vision', 'Ponder', 'Smallpox', 'Kargan Intimidator', 'Snapback', 'Grasslands', 'Cultivate', 'Chrome Courier', 'Veilstone Amulet', 'Braids, Cabal Minion', 'Cruel Bargain', 'Coalition Relic', 'Slagwoods Bridge', 'Diregraf Colossus', 'Snow-Covered Plains', 'Barren Moor', 'Jwari Disruption', 'Magmatic Insight', 'Nezumi Shortfang', 'Rally the Peasants', 'Staggering Insight', 'Zur the Enchanter', 'Riftwing Cloudskate', 'Sanguine Sacrament', 'Diamond Lion', 'Dennick, Pious Apprentice', 'Wild Cantor', 'Ramunap Excavator', 'Disallow', 'Cremate', 'Flame Rift', 'Oriss, Samite Guardian', 'Feather, the Redeemed', 'Thornglint Bridge', 'Figure of Destiny', 'Angel of Vitality', 'Chandra''s Triumph', 'Combat Research', 'Silundi Vision', 'Grisly Salvage', 'Filigree Familiar', 'Plaguecrafter', 'Shaman of the Pack', 'Blind Obedience', 'Explosive Welcome', 'Dovin Baan', 'Asylum Visitor', 'Pharika''s Libation', 'Tarfire', 'Ranger of Eos', 'Magmatic Channeler', 'Celestial Mantle', 'Magus of the Tabernacle', 'Primalcrux', 'Oath of Liliana', 'Gaea''s Blessing', 'Touch the Spirit Realm', 'Buried Ruin', 'Bring to Light', 'Zulaport Cutthroat', 'Virus Beetle', 'Season of Growth', 'Shriekhorn', 'Enter the God-Eternals', 'Dragonstorm', 'Abiding Grace', 'Anguished Unmaking', 'Kunoros, Hound of Athreos', 'Sanguine Bond', 'Gigadrowse', 'Decree of Justice', 'Silumgar, the Drifting Death', 'Simic Charm', 'Orim''s Chant', 'Radiant Fountain', 'Kederekt Parasite', 'Kappa Tech-Wrecker', 'Mastermind''s Acquisition', 'Spirited Companion', 'Lavaclaw Reaches', 'Sudden Death', 'Witness Protection', 'Geomancer''s Gambit', 'Realm Razer', 'Sigil of the Empty Throne', 'Ghitu Encampment', 'March of the Machines', 'Dissipation Field', 'Ominous Parcel', 'Vexing Shusher', 'Sunken Hope', 'Haze of Rage', 'Dispel', 'Tilling Treefolk', 'Martial Coup', 'Dead of Winter', 'Colossal Growth', 'Plow Under', 'Forsake the Worldly', 'Desert of the Indomitable', 'Trumpeting Gnarr', 'Search for Azcanta', 'Augur of Skulls', 'Sudden Edict', 'Auramancer''s Guise', 'Aspect of Hydra', 'Dragon''s Hoard', 'Riding the Dilu Horse', 'Inquisitor Exarch', 'Haunted Dead', 'Ojutai''s Command', 'Theater of Horrors', 'Hanweir Garrison', 'Reckoner''s Bargain', 'Sulfurous Blast', 'Famished Paladin', 'Glowstone Recluse', 'God-Pharaoh''s Gift', 'Flash of Insight', 'Deathgorge Scavenger', 'Abzan Charm', 'Elvish Scrapper', 'Tectonic Giant', 'Karrthus, Tyrant of Jund', 'Impulse', 'Marit Lage''s Slumber', 'Sram''s Expertise', 'Goblin Assault', 'Myth Realized', 'Torment of Scarabs', 'Dinrova Horror', 'Hive Mind', 'Ruin Crab', 'End Hostilities', 'Pieces of the Puzzle', 'Yavimaya Coast', 'Talisman of Creativity', 'Midnight Reaper', 'Soul Warden', 'Yeva, Nature''s Herald', 'Engulf the Shore', 'Raven''s Crime', 'Idyllic Tutor', 'Commit // Memory', 'Postmortem Lunge', 'Hieroglyphic Illumination', 'Rosethorn Acolyte', 'Shivan Reef', 'Korlash, Heir to Blackblade', 'Pelakka Predation', 'Stromkirk Noble', 'Rile', 'Radiant Scrollwielder', 'Sundial of the Infinite', 'Blighted Agent', 'Goblin Matron', 'Repeal', 'Tidespout Tyrant', 'Nivmagus Elemental', 'Desert of the Mindful', 'Fires of Yavimaya', 'Eldrazi Skyspawner', 'Venser, Shaper Savant', 'Viscera Seer', 'Bedevil', 'Mirran Spy', 'Magus of the Vineyard', 'Young Necromancer', 'Darksteel Colossus', 'Drossforge Bridge', 'Archangel of Wrath', 'Skyclave Shade', 'Academy Researchers', 'Vedalken Archmage', 'Goblin Ringleader', 'Rabbit Battery', 'Corpse Churn', 'Lose Focus', 'Cleansing Wildfire', 'Lazotep Plating', 'Revitalize', 'Labyrinth of Skophos', 'Multiple Choice', 'Ashes of the Abhorrent', 'Grave Scrabbler', 'Personal Sanctuary', 'Dreadhorde Butcher', 'Prismatic Lens', 'Waves of Aggression', 'Sea Gate Oracle', 'Laboratory Maniac', 'Glacial Fortress', 'Lingering Souls', 'In Search of Greatness', 'Bazaar Trademage', 'Prowess of the Fair', 'Trading Post', 'Angel of Despair', 'Spatial Contortion', 'Conflagrate', 'Blood Artist', 'Arcanum Wings', 'Erebos''s Intervention', 'Dakmor Salvage', 'Simian Spirit Guide', 'Blossoming Sands', 'Volcanic Geyser', 'Nomad Outpost', 'Runed Halo', 'Kiora, Master of the Depths', 'Karn, Silver Golem', 'Avacyn''s Pilgrim', 'Midnight Guard', 'Garrison Cat', 'Bloodchief''s Thirst', 'Origin Spellbomb', 'Improbable Alliance', 'Thief of Sanity', 'Orzhov Guildgate', 'Goblin Trashmaster', 'Tribute Mage', 'Abominable Treefolk', 'Legacy Weapon', 'Tyrant of Discord', 'Dawn of Hope', 'Fblthp, the Lost', 'Command the Dreadhorde', 'Strangle', 'Conduit of Ruin', 'Creeping Chill', 'Putrid Imp', 'Arc Trail', 'Broodmate Dragon', 'Manaforge Cinder', 'Dimir Aqueduct', 'Retreat to Coralhelm', 'Commune with Spirits', 'Aether Spellbomb', 'Call of the Death-Dweller', 'Flametongue Yearling', 'Pack Rat', 'Pestilent Haze', 'Fire-Lit Thicket', 'Painful Truths', 'Dragonskull Summit', 'Dream Trawler', 'Contingency Plan', 'Aria of Flame', 'Desecration Demon', 'Bolas''s Citadel', 'Birds of Paradise', 'Hurloon Battle Hymn', 'Ludevic, Necrogenius', 'Herald of the Pantheon', 'Blossoming Calm', 'Lochmere Serpent', 'Death Cloud', 'Orator of Ojutai', 'Winter''s Rest', 'Hobgoblin Captain', 'Glimmerpost', 'Foundation Breaker', 'Sarkhan the Masterless', 'Triskelion', 'Evacuation', 'Mulch', 'Ghost Quarter', 'Kessig Prowler', 'Beacon of Tomorrows', 'Rip-Clan Crasher', 'Lightning Storm', 'Gloomshrieker', 'Parallax Wave', 'Recurring Nightmare', 'Unpredictable Cyclone', 'Pollywog Symbiote', 'Talisman of Hierarchy', 'Grapeshot', 'Kaervek, the Spiteful', 'Desperate Ravings', 'Storm Herald', 'Skullscorch', 'Emeria Angel', 'Sunpetal Grove', 'Darksteel Citadel', 'Grenzo, Dungeon Warden', 'Duress', 'Silumgar''s Scorn', 'Nihil Spellbomb', 'Negate', 'Increasing Confusion', 'Shimmerdrift Vale', 'Muddle the Mixture', 'Fae of Wishes', 'Dread Return', 'Boreal Shelf', 'Mythos of Nethroi', 'Flayer of the Hatebound', 'Mesmeric Fiend', 'Hallowed Moonlight', 'Chromium, the Mutable', 'Kalonian Tusker', 'Mycosynth Lattice', 'Vampire Nighthawk', 'Open the Armory', 'Soulfire Grand Master', 'Tooth and Nail', 'Angel''s Grace', 'Invisible Stalker', 'Trace of Abundance', 'Sunscorched Desert', 'Carven Caryatid', 'Fervent Champion', 'Thrill of Possibility', 'Tamiyo''s Compleation', 'Reinforced Ronin', 'Mirrodin Besieged', 'Circuit Mender', 'Feed the Swarm', 'Bloom Tender', 'Yahenni''s Expertise', 'Acolyte of Affliction', 'Fyndhorn Elves', 'Lovestruck Beast', 'Sower of Temptation', 'Simic Signet', 'Easy Prey', 'Ayli, Eternal Pilgrim', 'Destroy Evil', 'Azami, Lady of Scrolls', 'Mystic Monastery', 'Shield of Kaldra', 'Zurgo Bellstriker', 'Solemnity', 'Okina, Temple to the Grandfathers', 'Phoenix Chick', 'Arch of Orazca', 'Apostle of Purifying Light', 'Pride Sovereign', 'Ghostly Flicker', 'Firebolt', 'Necromancer''s Stockpile', 'Jace, the Living Guildpact', 'Blood Baron of Vizkopa', 'Mystical Teachings', 'Yixlid Jailer', 'Rootwater Depths', 'Eternal Dragon', 'Orbs of Warding', 'Sudden Shock', 'Furious Bellow', 'Countersquall', 'Rift Sower', 'Orzhov Basilica', 'Boartusk Liege', 'Blazing Shoal', 'Glen Elendra Archmage', 'Auramancer', 'Sylvan Awakening', 'Flourishing Fox', 'Firewild Borderpost', 'Wheel of Fate', 'Samite Herbalist', 'Phyrexian Dreadnought', 'Founding the Third Path', 'Phyrexian Revoker', 'Enigma Sphinx', 'Take Inventory', 'Silver Myr', 'Eruth, Tormented Prophet', 'Spikefield Hazard', 'Tome Scour', 'Gruul Turf', 'Zuran Orb', 'Buried Alive', 'Woodfall Primus', 'Shipwreck Singer', 'Regal Force', 'Murderous Redcap', 'Bladewing''s Thrall', 'Summer Bloom', 'Simic Guildgate', 'Vivid Crag', 'Azorius Guildgate', 'Dictate of Kruphix', 'Hermit Druid', 'Geothermal Bog', 'Ring of Ma''rûf', 'Tempest Djinn', 'Purify the Grave', 'Springbloom Druid', 'Devilish Valet', 'Upheaval', 'Narcomoeba', 'Pashalik Mons', 'Satyr Wayfinder', 'Idyllic Grange', 'Pyromancer Ascension', 'Kaya, Ghost Assassin', 'Gaea''s Will', 'Peer Through Depths', 'Blazing Rootwalla', 'Wandering Fumarole', 'Tranquil Thicket', 'Savage Swipe', 'Tyrant''s Choice', 'Servo Exhibition', 'Mogg Fanatic', 'Garza Zol, Plague Queen', 'Fertile Ground', 'Thawing Glaciers', 'Escape Protocol', 'Blade Splicer', 'Rix Maadi Reveler', 'Frostwalk Bastion', 'Chain of Plasma', 'Salvaging Station', 'King Macar, the Gold-Cursed', 'Secluded Courtyard', 'Acidic Slime', 'Gideon Jura', 'Glacial Revelation', 'Sejiri Shelter', 'Blinkmoth Nexus', 'Tamiyo, Collector of Tales', 'Tunneling Geopede', 'Ob Nixilis Reignited', 'Burning Inquiry', 'Dire Tactics', 'Sphere of the Suns', 'Sorin, Grim Nemesis', 'Tezzeret the Schemer', 'Altar of the Brood', 'Spark Spray', 'Fauna Shaman', 'Implement of Malice', 'Vesperlark', 'Meteor Golem', 'Huatli, Radiant Champion', 'Jeskai Ascendancy', 'Merchant of the Vale', 'Fecundity', 'Timely Reinforcements', 'Oust', 'Essence Capture', 'Enlisted Wurm', 'Helm of Kaldra', 'Plea for Guidance', 'Evolutionary Leap', 'Abundance', 'Plargg, Dean of Chaos', 'Ravenous Squirrel', 'Precursor Golem', 'Cadaver Imp', 'Jace, Unraveler of Secrets', 'Jund Charm', 'Lesser Masticore', 'Padeem, Consul of Innovation', 'Canyon Slough', 'Swans of Bryn Argoll', 'Sylvan Anthem', 'Hour of Revelation', 'Solitary Confinement', 'Primal Command', 'Abbot of Keral Keep', 'Earthshaker Khenra', 'Sleight of Hand', 'Chromatic Lantern', 'Scrap Welder', 'Might of Old Krosa', 'Life Goes On', 'Pull from Tomorrow', 'Drakuseth, Maw of Flames', 'Epic Proportions', 'Ground Seal', 'Tocatli Honor Guard', 'Chandra''s Phoenix', 'Undead Augur', 'Sol Talisman', 'Squee, the Immortal', 'Blood Servitor', 'Brindle Shoat', 'Spell Pierce', 'Nicol Bolas, Planeswalker', 'Sphinx of the Steel Wind', 'Sickening Shoal', 'Black Sun''s Zenith', 'Scab-Clan Mauler', 'Thraben Inspector', 'Echoing Return', 'Ohran Viper', 'Far // Away', 'Llanowar Scout', 'Condemn', 'Reckless Waif', 'Cruel Ultimatum', 'Brazen Upstart', 'Verduran Enchantress', 'Flicker of Fate', 'Return to the Ranks', 'Growth-Chamber Guardian', 'Abandoned Sarcophagus', 'Wood Elves', 'Silverquill Silencer', 'Incubation Druid', 'Wayward Guide-Beast', 'Pyrite Spellbomb', 'Deep Analysis', 'Enchantress''s Presence', 'Chandra Ablaze', 'Desecrated Tomb', 'Experimental Synthesizer', 'The Raven''s Warning', 'Breakthrough', 'Crumbling Necropolis', 'Stillmoon Cavalier', 'Light Up the Night', 'Madrush Cyclops', 'Steel Hellkite', 'Kefnet the Mindful', 'Caves of Koilos', 'Channel the Suns', 'Gudul Lurker', 'Curse of Death''s Hold', 'Fleecemane Lion', 'Oracle of Mul Daya', 'Riveteers Charm', 'Thragtusk', 'Ransack the Lab', 'Omen of the Forge', 'Platinum Angel', 'Gray Merchant of Asphodel', 'Ayula''s Influence', 'Kuldotha Rebirth', 'Trash for Treasure', 'Vindicate', 'Silver Scrutiny', 'Scrapheap Scrounger', 'Sacred Ground', 'Skirk Prospector', 'Wild Nacatl', 'Mina and Denn, Wildborn', 'Syr Faren, the Hengehammer', 'Lotleth Troll', 'Frantic Search', 'Rotting Rats', 'Oread of Mountain''s Blaze', 'Avaricious Dragon', 'Gideon''s Intervention', 'Insatiable Hemophage', 'Release to the Wind', 'Dryad Militant', 'Elvish Mystic', 'Doomed Traveler', 'Dread Wanderer', 'Sedraxis Specter', 'Dimir Guildgate', 'Prey''s Vengeance', 'Forsaken Sanctuary', 'Jorn, God of Winter', 'Spectra Ward', 'Pentad Prism', 'Hellkite Overlord', 'Prophetic Prism', 'Terminus', 'Sandsteppe Citadel', 'Bloodsoaked Champion', 'Artisan of Kozilek', 'Geyadrone Dihada', 'Astral Drift', 'Chandra, Flame''s Catalyst', 'Marauding Blight-Priest', 'Raff, Weatherlight Stalwart', 'Cabaretti Courtyard', 'Primal Amulet', 'Lightning Strike', 'River of Tears', 'Bloodvial Purveyor', 'Shriekmaw', 'Migratory Greathorn', 'Temple of Triumph', 'Chandra''s Embercat', 'Elsewhere Flask', 'Proclamation of Rebirth', 'Leonin Relic-Warder', 'Hostage Taker', 'Reckless Rage', 'Temple of Mystery', 'Obzedat, Ghost Council', 'Isamaru, Hound of Konda', 'Slice and Dice', 'Bad River', 'Commune with the Gods', 'Cathartic Reunion', 'Nameless Inversion', 'Jukai Naturalist', 'Forbidden Alchemy', 'Parcelbeast', 'Vivid Meadow', 'Ziatora''s Envoy', 'Jungle Shrine', 'Bonders'' Enclave', 'Hornet Queen', 'Triumphant Adventurer', 'Slip Out the Back', 'Drift of Phantasms', 'Syncopate', 'Yorvo, Lord of Garenbrig', 'Rona''s Vortex', 'Jewel Thief', 'Skyclave Relic', 'Thought Scour', 'Scab-Clan Berserker', 'Orb of Dragonkind', 'Shadowborn Apostle', 'Carnage Altar', 'Ruin Raider', 'Shard Volley', 'Isolated Chapel', 'Ixalan''s Binding', 'Thryx, the Sudden Storm', 'Silversmote Ghoul', 'Ajani''s Pridemate', 'Displace', 'Faerie Vandal', 'Akoum Hellhound', 'Westvale Abbey', 'Keldon Flamesage', 'Prohibit', 'Undertaker', 'Golgari Guildgate', 'Elves of Deep Shadow', 'Ghalta, Primal Hunger', 'Pilfer', 'Snow-Covered Forest', 'Brineborn Cutthroat', 'Azusa''s Many Journeys', 'Shinka, the Bloodsoaked Keep', 'Rofellos, Llanowar Emissary', 'Oni-Cult Anvil', 'Ravenous Chupacabra', 'Memory Lapse', 'Blasphemous Act', 'Tangled Islet', 'Selesnya Sanctuary', 'Voracious Greatshark', 'Diabolic Tutor', 'Woe Strider', 'Alchemist''s Refuge', 'Prophet of Kruphix', 'Ral, Storm Conduit', 'Font of Fertility', 'Radha, Heart of Keld', 'Charge Through', 'Stoic Rebuttal', 'Molten Tributary', 'Maestros Charm', 'Elvish Visionary', 'Shakedown Heavy', 'Ad Nauseam', 'Goldhound', 'Galepowder Mage', 'Galvanic Relay', 'Privileged Position', 'Shenanigans', 'Dorothea, Vengeful Victim', 'Vines of Vastwood', 'Hanweir Battlements', 'Captured Sunlight', 'Glint-Sleeve Siphoner', 'Shatter the Sky', 'Overgrowth', 'Sever the Bloodline', 'Desert Cerodon', 'Jaxis, the Troublemaker', 'Starstorm', 'Cartel Aristocrat', 'Exclude', 'Withered Wretch', 'Melira, Sylvok Outcast', 'Terramorphic Expanse', 'Calciform Pools', 'Memoricide', 'Lab Rats', 'Augur of Bolas', 'Mistcutter Hydra', 'Bedlam Reveler', 'Psychatog', 'Taranika, Akroan Veteran', 'Warlord''s Fury', 'Drowned Catacomb', 'Obsidian Charmaw', 'Oviya Pashiri, Sage Lifecrafter', 'Silverquill Command', 'Academy Loremaster', 'Kazandu Mammoth', 'Frontier Bivouac', 'Secure the Wastes', 'Flaying Tendrils', 'Power Sink', 'Infuriate', 'Isareth the Awakener', 'Genesis', 'Mire Triton', 'Goblin Dark-Dwellers', 'Priest of Fell Rites', 'Fleetfoot Dancer'))) 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, 61.8, mysql)
Reported on decksite by mysql-perf
Location Hash: 73afdaefa95f1de32109c711ef733fe2f17decdf
Labels: decksite
[](slow_query, 65.2, mysql)Reported on decksite by mysql-perf
Location Hash: 73afdaefa95f1de32109c711ef733fe2f17decdf