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