vorpal-buildbot
commented
4 years ago Exceeded slow_query limit (11.9 > 10.0) in mysql: ```
SELECT
d.id,
d.name AS original_name,
d.created_date,
d.updated_date,
SUM(CASE WHEN dm.games > IFNULL(odm.games, 0) THEN 1 ELSE 0 END) AS wins,
SUM(CASE WHEN dm.games < odm.games THEN 1 ELSE 0 END) AS losses,
SUM(CASE WHEN dm.games = odm.games THEN 1 ELSE 0 END) AS draws,
d.finish,
d.archetype_id,
d.url AS source_url,
d.competition_id,
c.name AS competition_name,
c.end_date AS competition_end_date,
c.top_n AS competition_top_n,
ct.name AS competition_type_name,
d.identifier,
LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS person,
p.id AS person_id,
p.banned,
p.discord_id,
d.decklist_hash,
d.retired,
d.reviewed,
s.name AS source_name,
IFNULL(a.name, '') AS archetype_name,
cache.normalized_name AS name,
cache.colors,
cache.colored_symbols,
cache.color_sort,
cache.legal_formats,
ROUND(cache.omw * 100, 2) AS omw,
season.id AS season_id,
IFNULL(MAX(m.date), d.created_date) AS active_date
FROM
deck AS d
LEFT JOIN
person AS p ON d.person_id = p.id
LEFT JOIN
source AS s ON d.source_id = s.id
LEFT JOIN
archetype AS a ON d.archetype_id = a.id
LEFT JOIN
competition AS c ON d.competition_id = c.id
LEFT JOIN
competition_series AS cs ON cs.id = c.competition_series_id
LEFT JOIN
competition_type AS ct ON ct.id = cs.competition_type_id
LEFT JOIN
deck_cache AS cache ON d.id = cache.deck_id
LEFT JOIN
deck_match AS dm ON d.id = dm.deck_id
LEFT JOIN
`match` AS m ON dm.match_id = m.id
LEFT JOIN
deck_match AS odm ON odm.deck_id <> d.id AND dm.match_id = odm.match_id
LEFT JOIN
(
SELECT
`start`.id,
`start`.code,
`start`.start_date AS start_date,
`end`.start_date AS end_date
FROM
season AS `start`
LEFT JOIN
season AS `end` ON `end`.id = `start`.id + 1
) AS season ON season.start_date <= d.created_date AND (season.end_date IS NULL OR season.end_date > d.created_date)
WHERE
(d.id IN (64779, 64778, 64649, 64312, 64547, 64557, 64085, 64255, 64053, 64083, 64040, 64024, 63766, 63687, 63749, 63693, 63642, 63014, 63650, 63634, 63491, 63277, 63349, 63366, 63315, 63331, 63055, 63139, 63183, 62980, 62924, 62898, 62840, 62462, 62766, 62764, 62687, 62680, 63062, 62549, 62136, 62571, 62576, 62441, 62485, 62338, 62418, 62356, 62194, 62182, 62170, 62166, 62155, 62130, 62124, 62108, 62103, 62013, 61786, 61924, 61873, 61845, 61735, 61745, 61659, 61681, 63080, 61623, 61513, 61549, 61544, 61448, 61403, 63083, 61357, 61331, 61326, 61321, 61245, 61211, 61209, 61205, 61225, 61231, 61090, 61127, 61116, 61142, 61134, 61141, 61140, 61099, 61064, 60674, 60765, 60953, 60861, 60810, 60740, 60738, 60737, 60751, 60581, 60471, 60630, 60656, 60644, 60563, 60605, 60604, 60531, 60549, 60548, 60436, 60284, 60304, 60214, 60138, 60042, 60132, 60149, 60153, 60033, 60014, 60005, 60004, 60015, 60003, 59956, 59958, 59957, 59928, 59882, 59899, 59902, 59906, 59912, 59903, 59420, 59745, 59751, 59681, 59487, 59605, 59581, 59538, 59541, 59540, 59512, 59499, 59452, 59367, 59379, 59360, 59356, 59354, 56925, 59353, 59348, 59303, 56962, 59316, 59322, 59331, 59225, 59285, 59291, 59289, 59277, 58728, 59265, 59016, 59246, 59241, 59236, 59157, 59181, 59226, 59211, 59182, 59172, 59126, 59141, 59152, 59074, 59111, 59123, 59104, 59092, 59088, 58852, 59081, 59077, 59073, 58914, 59067, 59033, 59025, 58530, 58995, 57393, 59003, 58989, 58990, 58999, 58987, 58948, 58847, 58921, 58272, 58862, 58859, 58858, 58837, 58801, 58841, 58838, 58736, 58832, 58767, 58787, 58765, 58769, 58761, 58755, 58749, 58737, 58699, 58572, 58182, 58635, 58627, 58520, 58560, 58630, 58621, 58554, 58591, 58489, 58566, 58546, 58479, 58396, 58501, 58382, 58470, 58471, 58354, 58444, 58333, 58415, 58019, 58406, 58398, 58397, 58347, 58362, 58295, 56786, 58335, 58338, 58300, 58302, 58303, 58294, 58094, 58229, 58173, 58141, 58278, 58273, 58270, 58277, 57959, 58240, 58265, 58179, 58221, 58222, 58039, 58122, 58143, 58188, 58158, 58169, 58089, 58001, 58119, 58113, 58095, 58103, 58101, 58092, 58037, 58024, 57304, 58080, 58067, 58025, 58017, 58008, 57994, 57991, 58003, 57948, 57984, 57603, 57726, 57950, 57897, 57870, 57893, 57889, 57664, 57880, 57832, 57723, 56836, 57767, 57783, 57755, 57766, 57756, 57751, 57671, 57681, 57736, 57623, 57689, 57575, 57653, 57660, 57610, 57656, 57524, 57628, 57622, 57520, 57560, 57522, 57546, 57512, 57509, 57352, 57481, 57474, 57416, 57421, 57418, 57310, 57294, 57394, 57344, 57325, 57407, 57363, 57387, 57375, 57337, 57138, 57327, 57324, 57288, 57282, 57299, 57260, 57281, 57231, 57015, 57024, 57233, 57253, 57085, 57239, 57082, 57222, 57023, 57163, 57165, 57162, 56952, 57086, 57150, 57144, 57139, 57088, 57106, 56949, 57194, 57077, 57068, 57064, 57021, 57059, 57066, 56783, 57040, 57042, 57039, 57031, 56961, 57026, 57018, 57010, 57003, 57005, 56993, 56999, 56996, 57197, 56940, 56989, 56958, 56911, 56821, 56939, 56894, 56917, 56912, 56880, 56883, 56884, 56875, 56872, 56778, 56845, 57200, 56840, 56803, 56818, 56830, 56823, 56807, 56649, 56787, 56813, 56731, 56782, 56776, 56759, 56774, 56742, 56772, 56767, 56749, 56753, 56662, 56741, 56739, 56694, 56610, 56704, 56708, 56650, 56616, 56636, 56627, 56637, 56621, 56624, 56603, 56589, 56599, 56573, 56584, 56570, 56578, 56571, 56576, 56558, 56529, 56549, 55965, 56541, 56537, 56535, 56518, 56525, 56530, 56314, 56491, 56389, 56453, 56447, 56422, 56375, 56165, 56275, 56394, 56459, 56457, 56415, 56452, 56423, 56299, 56405, 56399, 56388, 55906, 56291, 56311, 56326, 57204, 57203, 56335, 56355, 56359, 56356, 56338, 56303, 56313, 56286, 56283, 56281, 56280, 56263, 56254, 56253, 56127, 56241, 56230, 56180, 56177, 56143, 56166, 56168, 56200, 56190, 56202, 56194, 56162, 56153, 56044, 56075, 55952, 56056, 56140, 56134, 56139, 56107, 57208, 57206, 56004, 56066, 56070, 56089, 56096, 56095, 56053, 56010, 55792, 56012, 55980, 55878, 55709, 55995, 57209, 57211, 55999, 55981, 55971, 55905, 55957, 55807, 55322, 55844, 55935, 55853, 55928, 55932, 57217, 57218, 55924, 55917, 55918, 55874, 55884, 55830, 55838, 55851, 55835, 55833, 55828, 55620, 55805, 55540, 55765, 55782, 55774, 55330, 55724, 55753, 55445, 55737, 55733, 55717, 55722, 55719, 55695, 55697, 55693, 55691, 55543, 55464, 55589, 55630, 55645, 55642, 55648, 55636, 55590, 54885, 55311, 55569, 55457, 55550, 55477, 55137, 55526, 55454, 55463, 55514, 55508, 55489, 55510, 55488, 55436, 55115, 55426, 55258, 55233, 55412, 55416, 55383, 55391, 55359, 55357, 55348, 55347, 55343, 55340, 55368, 55371, 55364, 55319, 55222, 55301, 55235, 55227, 55226, 55243, 55247, 55208, 55206, 55007, 55204, 55182, 54972, 55194, 55181, 55187, 55143, 57186, 55034, 55044, 55122, 55120, 55151, 55088, 54673, 54739, 55100, 55047, 55060, 57188, 55070, 55069, 55017, 54974, 54918, 55020, 54996, 54999, 54961, 54927, 54963, 54924, 54861, 54865, 54939, 54931, 54928, 54758, 54880, 54881, 54836, 54869, 54714, 54848, 54741, 54761, 54832, 54822, 54816, 54817, 54801, 54745, 54683, 54738, 54767, 54785, 54769, 54795, 54771, 54797, 54773, 54796, 54701, 54503, 54594, 54709, 54691, 54596, 54562, 54654, 54516, 54651, 54427, 54619, 54623, 57187, 54604, 54590, 54556, 54507, 54613, 54439, 54598, 54541, 54542, 54554, 54551, 54561, 54557, 54553, 54513, 54495, 54532, 54441, 54579, 54574, 54576, 54582, 54575, 54453, 54464, 54486, 54329, 54462, 54288, 54467, 54470, 54477, 54472, 54478, 54473, 54443, 54444, 54435, 54251, 54421, 54408, 54244, 54416, 54414, 54377, 54256, 54364, 54299, 54351, 54320, 54360, 54234, 54390, 54397, 54404, 54106, 54143, 54260, 54250, 54252, 54230, 54206, 54236, 54155, 54162, 54112, 54186, 54152, 54147, 54160, 54127, 54115, 54105, 54111, 54102, 54056, 54089, 54078, 53452, 53994, 53990, 53988, 53959, 53968, 53956, 53941, 53882, 53716, 53910, 53876, 53888, 53763, 53834, 53833, 53822, 53813, 53687, 53807, 53805, 53772, 53799, 53769, 53745, 53570, 53621, 53672, 53669, 53706, 53705, 53684, 53670, 53662, 53588, 53485, 53473, 53638, 53582, 53484, 53625, 53573, 53526, 53449, 53549, 53542, 53516, 53502, 53497, 53501, 53499, 53297, 53480, 53211, 53433, 53451, 53440, 53321, 53372, 53414, 53395, 53375, 53397, 53154, 53303, 53252, 53308, 53306, 53300, 53289, 53148, 53283, 53235, 53239, 53238, 53236, 52617, 53230, 53226, 53192, 53220, 53151, 53186, 53107, 53070, 53124, 53139, 53081, 53083, 51435, 53002, 53100, 52927, 52952, 53058, 52947, 52818, 52980, 52820, 53026, 52993, 52996, 52959, 52957, 52881, 52576, 52972, 52971, 52970, 52941, 52930, 52765, 52913, 52827, 52902, 52629, 52870, 52866, 52876, 52476, 52850, 52793, 52840, 52220, 52778, 52783, 52747, 52771, 52754, 52762, 52729, 52703, 52641, 52654, 52630, 52611, 52562, 52560, 52566, 52556, 52503, 52539, 52518, 52449, 52495, 52472, 52460, 52459, 52431, 52428, 52424, 52321, 52416, 52243, 52366, 52178, 52375, 52305, 52349, 52309, 52311, 52192, 52212, 52230, 52200, 52206, 52211, 51377, 52059, 52143, 52108, 51808, 52101, 51909, 52089, 51882, 52050, 52021, 52045, 51955, 51897, 51870, 51811, 51798, 51838, 51837, 51676, 51791, 51370, 51713, 51708, 51573, 51519, 51633, 51629, 51659, 51612, 51579, 51565, 51568, 51558, 51516, 51549, 51554, 51517, 51508, 51472, 51440, 51497, 51468, 51485, 51482, 51486, 51447, 51361, 51356, 51420, 51414, 51263, 51170, 51307, 51184, 51289, 48072, 51041, 51114, 51038, 51247, 51244, 51246, 51245, 51211, 51206, 51199, 51185, 51069, 51054, 51109, 51045, 51115, 51103, 51113, 51058, 51010, 51087, 50986, 50549, 51032, 51028, 57190, 51027, 50889, 50932, 50941, 50824, 50963, 50969, 50968, 50726, 50909, 50927, 50920, 50916, 50836, 50914, 50908, 50880, 50737, 50854, 50595, 50620, 50763, 50790, 50815, 50777, 50450, 50756, 50738, 50732, 50752, 50751, 50694, 50681, 50680, 50623, 50524, 50676, 50677, 50668, 50629, 50606, 50607, 50322, 50554, 50474, 50552, 50411, 49948, 50293, 49714, 50497, 50449, 50130, 50279, 50402, 50379, 50281, 50361, 50354, 50286, 50216, 50147, 50273, 50264, 50159, 50205, 48762, 50209, 50019, 50200, 50076, 50085, 50080, 50059, 50072, 49927, 49981, 50021, 50041, 49763, 49590, 49939, 48271, 49964, 49965, 49966, 49922, 49923, 49106, 49832, 49913, 49553, 49842, 49844, 49776, 49800, 49803, 49812, 49814, 49792, 49771, 49764, 49675, 49759, 49760, 49755, 49754, 49750, 49743, 49751, 49674, 49469, 49493, 47844, 49669, 49693, 49687, 49686, 49685, 49583, 49645, 49636, 49604, 49315, 49311, 49503, 49083, 49579, 49529, 49477, 49533, 49299, 49497, 49481, 49351, 49470, 49350, 49430, 49429, 49330, 49342, 49339, 49346, 49364, 49312, 49280, 49306, 49207, 49307, 49303, 49154, 48903, 49127, 49189, 49246, 49215, 49200, 49234, 49147, 48197, 49145, 48527, 49124, 49021, 48949, 49046, 49059, 49024, 48979, 48809, 48846, 48676, 48917, 48775, 48810, 48717, 48847, 48607, 48728, 48814, 48834, 48832, 48707, 48395, 48606, 48446, 48673, 48710, 48425, 48226, 48640, 48445, 48581, 48280, 48600, 48585, 48565, 48537, 48525, 48511, 48102, 47990, 48475, 48433, 48451, 48454, 48452, 48457, 48320, 47851, 48397, 48290, 48368, 48381, 48376, 48180, 48361, 48341, 48331, 48295, 47754, 48289, 48285, 48113, 48269, 48231, 48175, 48201, 48171, 48182, 48244, 48115, 48031, 48025, 48090, 48073, 48075, 48067, 48051, 48061, 48033, 48013, 47795, 47950, 47824, 47873, 47875, 47857, 47827, 47826, 47766, 47776, 47745, 47736, 47701, 47583, 47317, 45824, 47522, 47523, 47508, 47498, 47495, 47458, 47313, 47044, 47362, 47442, 47415, 47434, 47338, 47282, 46877, 47123, 47083, 47180, 47199, 47175, 47177, 46970, 47028, 47120, 47117, 46843, 46910, 46999, 46864, 46956, 46806, 46809, 46863, 46905, 46846, 46897, 46891, 46893, 46888, 46688, 46813, 46832, 46778, 46801, 46772, 46147, 46771, 46786, 46785, 46760, 46741, 46302, 46726, 46725, 46644, 46598, 46540, 46595, 46561, 46550, 46465, 46543, 46482, 46439, 45618, 46524, 46523, 46507, 46411, 46395, 46475, 46090, 46443, 46448, 46442, 46440, 46400, 46266, 46007, 46372, 46101, 46301, 44867, 46253, 46034, 45799, 45972, 45687, 46008, 46040, 45973, 45385, 45600, 45917, 45905, 45788, 45777, 45443, 45535, 45524, 45269, 45169, 45223, 44833, 45079, 44930, 44770, 44767, 44430, 44649, 44616, 44108, 44005, 44133, 44107, 43966, 44017, 43877, 44010, 43936, 43971, 44009, 42795, 43982, 43976, 43929, 43970, 43967, 43991, 43973, 43949, 43951, 43736, 43899, 43486, 43782, 43685, 43868, 43927, 43882, 43911, 43910, 43772, 43790, 43781, 43776, 43762, 43769, 43760, 43755, 43747, 43746, 43743, 43838, 43801, 43669, 43731, 43712, 43705, 43841, 43809, 43681, 43676, 43819, 43843, 43639, 43540, 43650, 43834, 43832, 43827, 43593, 43635, 43602, 43608, 43626, 43455, 43609, 43541, 43848, 43611, 43592, 43597, 43543, 43580, 43591, 43586, 43528, 43563, 43481, 43571, 43569, 43496, 43522, 43524, 43472, 43520, 43512, 43508, 43510, 43467, 43462, 43497, 43495, 42748, 43493, 43492, 43484, 43483, 43480, 43450, 43471, 43477, 43375, 43432, 43461, 43065, 43328, 43444, 43446, 43421, 43420, 43418, 43417, 43415, 43412, 43409, 43424, 43382, 43379, 43362, 43356, 43326, 43357, 43354, 43315, 43284, 43331, 43330, 43341, 43295, 43302, 43301, 43314, 43311, 43272, 43282, 42286, 43264, 43324, 43261, 43257, 43248, 43250, 43201, 43223, 43202, 42962, 43185, 43183, 42490, 43161, 43168, 43177, 43115, 42055, 43154, 43147, 43143, 43127, 43120, 43096, 42978, 43079, 43073, 43088, 43066, 43024, 42988, 42958, 43047, 43046, 42976, 42890, 42969, 42933, 42967, 42882, 42941, 42935, 42904, 42898, 42799, 42911, 42894, 42390, 42885, 42832, 42876, 42872, 42856, 42863, 42649, 42858, 42857, 42847, 42837, 42688, 42840, 42810, 42841, 42836, 42828, 64173, 64167, 42824, 42777, 42822, 42812, 42775, 42651, 42660, 42791, 42801, 42746, 42538, 42761, 42739, 42638, 42737, 42734, 42650, 42659, 42275, 42707, 42687, 42684, 42599, 42604, 42642, 42235, 42667, 42451, 42588, 42582, 42609, 42619, 42622, 42621, 42620, 42626, 42548, 42597, 42630, 42501, 42581, 42557, 42532, 42528, 42455, 42565, 42567, 42537, 42494, 42514, 42465, 42475, 42436, 42445, 42453, 42452, 42446, 42422, 42526, 42520, 42362, 42398, 42391, 42389, 42678, 42383, 42340, 42318, 42296, 42282, 42347, 42344, 42346, 42679, 42320, 42294, 42313, 42303, 42196, 42207, 42278, 42269, 42261, 42250, 42208, 42117, 42215, 42170, 42224, 42227, 42104, 42187, 42167, 42156, 42121, 42123, 42081, 42101, 42059, 42022, 42038, 41989, 41998, 41999, 42005, 42007, 41933, 38754, 41971, 41972, 41798, 41957, 41961, 41953, 41952, 41898, 41938, 41935, 41931, 41925, 41755, 41788, 41908, 41883, 41886, 41881, 41673, 41875, 41804, 41609, 41823, 41860, 41858, 41868, 41859, 41832, 41833, 41732, 41827, 41826, 41820, 41801, 41784, 41785, 41786, 41762, 41767, 41782, 41768, 41769, 41774, 41770, 41727, 33196, 41734, 41736, 41717, 41713, 40756, 41677, 41672, 41542, 41670, 41628, 41669, 41571, 41680, 41683, 41682, 41688, 41324, 41665, 41092, 41644, 38738, 41656, 41631, 41562, 41623, 41629, 41560, 41613, 41608, 41586, 41598, 41605, 41599, 41602, 41594, 41585, 41575, 41567, 41559, 41551, 41550, 41549, 41521, 41526, 41532, 41163, 41529, 41528, 41125, 41520, 41511, 41509, 41325, 41299, 41311, 41257, 41256, 41150, 41110, 41227, 40743, 41137, 41124, 41095, 41093, 40984, 41056, 41080, 41513, 41036, 41010, 40937, 40586, 40887, 39647, 40768, 40862, 40731, 40801, 40802, 41395, 40627, 40702, 40689, 40673, 40676, 40661, 40646, 40630, 40561, 40585, 40408, 40560, 40611, 40523, 40524, 40448, 40277, 40396, 40357, 40330, 40363, 40225, 39915, 40226, 40186, 40108, 34530, 40188, 40189, 40199, 40200, 40079, 39802, 40021, 40017, 40022, 39661, 39723, 39126, 41401, 38750, 39631, 39572, 41408, 41406, 41409, 39194, 39179, 38609, 38800, 38423, 41411, 38767, 38751, 38711, 38687, 38596, 38582, 38570, 38424, 38533, 38525, 38524, 38407, 38405, 38379, 38271, 38283, 38258, 38180, 37986, 37808, 38097, 38146, 38059, 37987, 37939, 35576, 37665, 37823, 37696, 37668, 37480, 37695, 37760, 37765, 37477, 37569, 37301, 36927, 37314, 36928, 37025, 37098, 36453, 36954, 36952, 36823, 36713, 36541, 36583, 36677, 36632, 36570, 36506, 41423, 36334, 36195, 35772, 36181, 35786, 35167, 36214, 36218, 36215, 36095, 35966, 36067, 41431, 41432, 35680, 35418, 35499, 35802, 35805, 35620, 35547, 35515, 35483, 35330, 35479, 35401, 34592, 34881, 35345, 35346, 35048, 34054, 35448, 35443, 35060, 34995, 34325, 34797, 34812, 34816, 41439, 34696, 34716, 34733, 34620, 34712, 34555, 34622, 34607, 34605, 34473, 34505, 34416, 34411, 34267, 34118, 41441, 34340, 34293, 34152, 34165, 34146, 34134, 34116, 34087, 33376, 33624, 34073, 33898, 33676, 34019, 33971, 34006, 33806, 33293, 33924, 33596, 33885, 33859, 33743, 33741, 33132, 33749, 33751, 33242, 33403, 33646, 33642, 33625, 33558, 33492, 33437, 33449, 33134, 33391, 32587, 33374, 32854, 33147, 41450, 33259, 33214, 33244, 33180, 33302, 33305, 32997, 32510, 32979, 33151, 33166, 33150, 33135, 33061, 32733, 32852, 32794, 41460, 32822, 32780, 32691, 32893, 32882, 32883, 32884, 32894, 32765, 32704, 32718, 32689, 32648, 32546, 32600, 32483, 41467, 32466, 32412, 32415, 32395, 32373, 32390, 32355, 32335, 32306, 32182, 31296, 31302, 31252, 31282, 31268, 41482, 31209, 31207, 31089, 31181, 31125, 41346, 31104, 31102, 31062, 31066, 30997, 30943, 30988, 30903, 30895, 30780, 30706, 30831, 30809, 30784, 30334, 30782, 30774, 30611, 30768, 30648, 30752, 30662, 30700, 30686, 30685, 30563, 30624, 30617, 30618, 30612, 30594, 30595, 30609, 30490, 30587, 30586, 30274, 30575, 30043, 30546, 30512, 30534, 30540, 30506, 30501, 30496, 30505, 30449, 30473, 30109, 30355, 30375, 30401, 30360, 30257, 30335, 30316, 30327, 30340, 30313, 30281, 30297, 30293, 30333, 30173, 30261, 30246, 30239, 30273, 30272, 30282, 30271, 30238, 30222, 30194, 30142, 30179, 30138, 30159, 30144, 30100, 30127, 30128, 30107, 30097, 30051, 30063, 30075, 30053, 30035, 30034, 29980, 30029, 30000, 30039, 29946, 29987, 29984, 29982, 29972, 29938, 29997, 29297, 29954, 29973, 29955, 29976, 29868, 29700, 29930, 29423, 29912, 29905, 29907, 29656, 29815, 29810, 29853, 29871, 29845, 29898, 29900, 29855, 29651, 29848, 29846, 29843, 29791, 29784, 29832, 29416, 29447, 29806, 29764, 29507, 29746, 29748, 29736, 29721, 29723, 29722, 29756, 29751, 29556, 29448, 29675, 29639, 29653, 29695, 29661, 29674, 29672, 29301, 29629, 29646, 29598, 29631, 29628, 29568, 29655, 29543, 29579, 29356, 29383, 29553, 29526, 29421, 29518, 29517, 29437, 28509, 29492, 29498, 29316, 29425, 29358, 29229, 29381, 29400, 29401, 29387, 29411, 29407, 29406, 29380, 29378, 29366, 29352, 29348, 29114, 29617, 29325, 29324, 29275, 29336, 29310, 29217, 29281, 28781, 29287, 29205, 29224, 29272, 29271, 29220, 29239, 29227, 28941, 29208, 29138, 29197, 29190, 28989, 29161, 29159, 29143, 29141, 28711, 29113, 29103, 29097, 29078, 29071, 28991, 29077, 29023, 29041, 29051, 29047, 29079, 29010, 29019, 29008, 29004, 28840, 28980, 28841, 28975, 28944, 28854, 28935, 28957, 28956, 28933, 28608, 28930, 28929, 28859, 28782, 28660, 28887, 28866, 28862, 28787, 28465, 28850, 28848, 28822, 28763, 28583, 28826, 28823, 28816, 28703, 28814, 28785, 28803, 28729, 28799, 28808, 28788, 28771, 28786, 28779, 28768, 28758, 28790, 28726, 28477, 28685, 28701, 28693, 28262, 28674, 28664, 28663, 28610, 28650, 28646, 28651, 28627, 28617, 28522, 28575, 28618, 28597, 28589, 28600, 28611, 28563, 28544, 28551, 28540, 28532, 28506, 28529, 28421, 28510, 28370, 28502, 28316, 28464, 28472, 28490, 28485, 28463, 28253, 28460, 28462, 28458, 28442, 28456, 28455, 28451, 28449, 28448, 28384, 28358, 28299, 28467, 28334, 28327, 28357, 28347, 28344, 28261, 28260, 28314, 28303, 28294, 28285, 28210, 28271, 28268, 28263, 28259, 28277, 28258, 28203, 28200, 27088, 28202, 28183, 28165, 28154, 28161, 28144, 28136, 28129, 28104, 27974, 26905, 28172, 28170, 28040, 28091, 28031, 28030, 28058, 26749, 28082, 28038, 28029, 26708, 27401, 28015, 26457, 28175, 26994, 27971, 27972, 27983, 27856, 27851, 27435, 27853, 27842, 27841, 27836, 27826, 27818, 27239, 27811, 27780, 27213, 27778, 27779, 27772, 27756, 27508, 27507, 27415, 27502, 27501, 27499, 27495, 27333, 28180, 27485, 27452, 27227, 27431, 27342, 27423, 27420, 27416, 27390, 27418, 27204, 27400, 27398, 27393, 27258, 27385, 27218, 27383, 27379, 27357, 27355, 27365, 26586, 27354, 27352, 27350, 27347, 27345, 27264, 27237, 27301, 27308, 27260, 27293, 27290, 27196, 27259, 27274, 27284, 27250, 26033, 26963, 27236, 27230, 27214, 27203, 27219, 27073, 27168, 27192, 27160, 27534, 27165, 27150, 27179, 27145, 27065, 27128, 27014, 27126, 27102, 27103, 27120, 27095, 27081, 27063, 26853, 26858, 27030, 27055, 27026, 26878, 26072, 26760, 27007, 26987, 26950, 26957, 26956, 26945, 26938, 26933, 26902, 26931, 26926, 26929, 26868, 26862, 26831, 26770, 26530, 26795, 26782, 26783, 26602, 26764, 26761, 26758, 26740, 26741, 26643, 26734, 26722, 26633, 26445, 26659, 26630, 26681, 26679, 26690, 26692, 26571, 26583, 26620, 26410, 26447, 26596, 26296, 26521, 26523, 26306, 26514, 26407, 26552, 26548, 26553, 26507, 26400, 26467, 26481, 26487, 26461, 25421, 26227, 26385, 25820, 26313, 26435, 26433, 26396, 26383, 26370, 26364, 26292, 26353, 26350, 26106, 26343, 26337, 26345, 26299, 25917, 26295, 26271, 26288, 26263, 26267, 26266, 26180, 26202, 26253, 25882, 26247, 26226, 26244, 25895, 26239, 26186, 26104, 25931, 26042, 26094, 26073, 26071, 26062, 26057, 25918, 26029, 26007, 26008, 26003, 26010, 25903, 25998, 25949, 25965, 25946, 25836, 25924, 25912, 25848, 25909, 25910, 25907, 25906, 25987, 25891, 25737, 25888, 25756, 25864, 25870, 25862, 25855, 25754, 25852, 25845, 25532, 25761, 25718, 25778, 25608, 27564, 25669, 25635, 25723, 25743, 25740, 25712, 25705, 25719, 25710, 25678, 25670, 25550, 25652, 25658, 25655, 25682, 25684, 25689, 25701, 25456, 25641, 25618, 25628, 25615, 25574, 25612, 25567, 25522, 25525, 25547, 25530, 25557, 25460, 25542, 25423, 25362, 25457, 25459, 25472, 25476, 25350, 25465, 25464, 25441, 25414, 25424, 25380, 25399, 25388, 25382, 25379, 27577, 27570, 25352, 25336, 25333, 25261, 25320, 25298, 25303, 25301, 25281, 25251, 27579, 27578, 25234, 25241, 25227, 25223, 25160, 25193, 25194, 25181, 25140, 24713, 25001, 25028, 25150, 25144, 25035, 25148, 27588, 25014, 25062, 25105, 27590, 24845, 25075, 25033, 25057, 24829, 24954, 24854, 24840, 24998, 25023, 24975, 24997, 25004, 25003, 24711, 24999, 24936, 24990, 24984, 24974, 24953, 24856, 24970, 27594, 24968, 24961, 24926, 24833, 24913, 24512, 24443, 24424, 24910, 24922, 24911, 24800, 27597, 24832, 24904, 24901, 24906, 24409, 24588, 24816, 24795, 24656, 24625, 24773, 24778, 24527, 24641, 24698, 24681, 24533, 24652, 27787, 27798, 24474, 24631, 24622, 24582, 23623, 24523, 24170, 24513, 24489, 24504, 24479, 23721, 24461, 24462, 24412, 24448, 24444, 24418, 24425, 24422, 24354, 23108, 24349, 24302, 24395, 24281, 24387, 24300, 24283, 24367, 24377, 24289, 24043, 24266, 24260, 24050, 24261, 24051, 24208, 24247, 24242, 24249, 24202, 23951, 24162, 27616, 24111, 23923, 24059, 24123, 24017, 23981, 24015, 23976, 23848, 23920, 23990, 23987, 23973, 23969, 23948, 23899, 23915, 27623, 27625, 23913, 23886, 23586, 23884, 23881, 23869, 23606, 23861, 23867, 27626, 23831, 23674, 27630, 23825, 23820, 27794, 23777, 27631, 23713, 23714, 23707, 23684, 23678, 23512, 23251, 23624, 23629, 23621, 23575, 23569, 23562, 23516, 23592, 23519, 23570, 23543, 23518, 23462, 23466, 23535, 23478, 23431, 23473, 23458, 23413, 23452, 23443, 27645, 23438, 23436, 23270, 23409, 23385, 23402, 23401, 23382, 27646, 23301, 23371, 23369, 23361, 23273, 23327, 23260, 23319, 23343, 23344, 23198, 23299, 23283, 23295, 23290, 23286, 23280, 23282, 23271, 23264, 23278, 23272, 23267, 23246, 23238, 27648, 23129, 23200, 23225, 23235, 23233, 23144, 23065, 23083, 23138, 23182, 23133, 23142, 27654, 23097, 23064, 23157, 25461, 23078, 23082, 23079, 21452, 22982, 27655, 23012, 22950, 22981, 22835, 27658, 27657, 22966, 22953, 22919, 22932, 22918, 22924, 22853, 22430, 22844, 27661, 22863, 22817, 22764, 22839, 22792, 22501, 22374, 22748, 22765, 22760, 22714, 22757, 22787, 22562, 22716, 22690, 27665, 22369, 22661, 22653, 22642, 22683, 22614, 22572, 22605, 22547, 22634, 22636, 22625, 22541, 22371, 27668, 21957, 22488, 22540, 22429, 22462, 22469, 22458, 22433, 22391, 22335, 27671, 22450, 22395, 22357, 22297, 22400, 22356, 22280, 22087, 22408, 22392, 22399, 22380, 22310, 22351, 22349, 22239, 22345, 22346, 22342, 22334, 22235, 22279, 22294, 22281, 22269, 22218, 22236, 22263, 22258, 22222, 22194, 21559, 22173, 22193, 21960, 22181, 21907, 22093, 21932, 22118, 22126, 22160, 22168, 22165, 22169, 22053, 22080, 22072, 22078, 22074, 22025, 22064, 21378, 22052, 22020, 22010, 21963, 22000, 21457, 21999, 21991, 21992, 21952, 21956, 21955, 21511, 21944, 21875, 21939, 21826, 21937, 21534, 21864, 21921, 21913, 21914, 21922, 21893, 21029, 21793, 27684, 21822, 21820, 21816, 21815, 21812, 21073, 21730, 21786, 21767, 21412, 21651, 21644, 21645, 27692, 27691, 21177, 21308, 21001, 21635, 21533, 21577, 21578, 21570, 21540, 21532, 21481, 21489, 21491, 21486, 21440, 21387, 21428, 21460, 21439, 21423, 21395, 21276, 21086, 21167, 21067, 21219, 21220, 21162, 21214, 21165, 21038, 21123, 21032, 21193, 21070, 21170, 21037, 21139, 20910, 21085, 27711, 20886, 21025, 20712, 21018, 21017, 21016, 21013, 20977, 20972, 20996, 20951, 20947, 20939, 20908, 20646, 20681, 27717, 20806, 20850, 20799, 20858, 20873, 20876, 20841, 20833, 20824, 20819, 20760, 20798, 20726, 20639, 20638, 20769, 20700, 20676, 20753, 20751, 20692, 20682, 20683, 20674, 20666, 20655, 20653, 20619, 20615, 20606, 20612, 20348, 20214, 20561, 20581, 20552, 20483, 20544, 20462, 20528, 20459, 20266, 20471, 20477, 20427, 20447, 20448, 20290, 20438, 20372, 20376, 20337, 20327, 20354, 20339, 20323, 20295, 20296, 20243, 20279, 20222, 20237, 20133, 20183, 20215, 20082, 20206, 20035, 20194, 19875, 20177, 20099, 20165, 20073, 20120, 19317, 20031, 20066, 20076, 19767, 20025, 27726, 19956, 20022, 20014, 20053, 20002, 19744, 19943, 19982, 19967, 19991, 19952, 19911, 19907, 19903, 19749, 19890, 19770, 19916, 19931, 19882, 19855, 19862, 19771, 19723, 19680, 19772, 19674, 27729, 19753, 19663, 19740, 19697, 19721, 19657, 19619, 19113, 19593, 19620, 19594, 19540, 19571, 19588, 19552, 19384, 19554, 18901, 19497, 19436, 19306, 19102, 19244, 19482, 19477, 19220, 19318, 19314, 19282, 19225, 19274, 18961, 19136, 19198, 27735, 19101, 19254, 19255, 19257, 19034, 19202, 19177, 19164, 19160, 18985, 19145, 19135, 19078, 19055, 19119, 19074, 19065, 18917, 19097, 19090, 18904, 19047, 18967, 19028, 19020, 18866, 18975, 18963, 18848, 18949, 18932, 18930, 18919, 18907, 18886, 18857, 18808, 18845, 18835, 18843, 18753, 18818, 18688, 18807, 18811, 18812, 18552, 18713, 18460, 18752, 18766, 18658, 18751, 18748, 18720, 18553, 18545, 18659, 18673, 18473, 18506, 18530, 18317, 18503, 18489, 18581, 18582, 18365, 18461, 18454, 18433, 18395, 18293, 18374, 18427, 18373, 18362, 18376, 18375, 18367, 18360, 18340, 18345, 18331, 18335, 18320, 18321, 18319, 17454, 18232, 17820, 18170, 18247, 18240, 18248, 18218, 18226, 18186, 18210, 18213, 27752, 27753, 18652, 18646, 18173, 17753, 17587, 17554, 17823, 17811, 18169, 16519, 17645, 17699, 17756, 17839, 17739, 17745, 17646, 17647, 17556, 17841, 17560, 17658, 17518, 17221, 17611, 17597, 17564, 17845, 17585, 16552, 17581, 17415, 17417, 17437, 17507, 17424, 17489, 17519, 17510, 17505, 17503, 17119, 17449, 17418, 17461, 17429, 17481, 17388, 17852, 17849, 17467, 17476, 17472, 17384, 17398, 17224, 17332, 17365, 16762, 17338, 17226, 17345, 17358, 17310, 17178, 17198, 17303, 17267, 17861, 17863, 17862, 17091, 17087, 17864, 16858, 17868, 17869, 16910, 16808, 17872, 17876, 18159, 18158, 17884, 17878, 16662, 17893, 17894, 17902, 17899, 17905, 17909, 16268, 17910, 16143, 16182, 16154, 17919, 17921, 15817, 15722, 15717, 17930, 15647, 15529, 15465, 15253, 14895, 14636, 14541, 14440, 17963, 17965, 14312, 17968, 17969, 17971, 17970, 17974, 17975, 14100, 14099, 13803, 13830, 17986, 17985, 13814, 13811, 22519, 17989, 17990, 17992, 17991, 13680, 18008, 13625, 18012, 18023, 18025, 22889, 12939, 18036, 18034, 12822, 12803, 12841, 12851, 12849, 12847, 12842, 12843, 12799, 12816, 12775, 12730, 12804, 12777, 12781, 18044, 18043, 12545, 12792, 12795, 12786, 12785, 12789, 12771, 12737, 12747, 12770, 12517, 18047, 12764, 12762, 12765, 12733, 12714, 12717, 12710, 12546, 12705, 12702, 12668, 12693, 12656, 12684, 12445, 12593, 12675, 12575, 12669, 12632, 12666, 12664, 12663, 12658, 12657, 12650, 12448, 12633, 12636, 12638, 12639, 12482, 12454, 12597, 12569, 12543, 12629, 12615, 12622, 12611, 12624, 12614, 12613, 12554, 12476, 12550, 12552, 12463, 12542, 12541, 12490, 12540, 12537, 12442, 12534, 12533, 12524, 12519, 12522, 12433, 18050, 12491, 12502, 12506, 12494, 12504, 12464, 12418, 12430, 12428, 12240, 12307, 12404, 12402, 12200, 12401, 12374, 12367, 12381, 12389, 12379, 12383, 12390, 12393, 12385, 12396, 12358, 12285, 12346, 12310, 12348, 12217, 12344, 12304, 12318, 12137, 12206, 12234, 12335, 12331, 12319, 12320, 12337, 12322, 12333, 12290, 12295, 12289, 12218, 12232, 11906, 11976, 12268, 12269, 12279, 12208, 12060, 12170, 11821, 12210, 12044, 12204, 12165, 12175, 12185, 18162, 12164, 12173, 12166, 12169, 12120, 12131, 12106, 12140, 18059, 18057, 12043, 12116, 12107, 12053, 11793, 11767, 12047, 11518, 11975, 12079, 12086, 12075, 12012, 11970, 11980, 11756, 11911, 12001, 12026, 12027, 12013, 12028, 12015, 11985, 11990, 12029, 11995, 11999, 11942, 11969, 11934, 11830, 11968, 11960, 11963, 11961, 11953, 11967, 11949, 11910, 11901, 11914, 11182, 11886, 11710, 11877, 11724, 11826, 11814, 11834, 11601, 11853, 11844, 11843, 11815, 11806, 11791, 11752, 11780, 18074, 18073, 18071, 11760, 11116, 11737, 11722, 11705, 11711, 11714, 11651, 11643, 11702, 11691, 11698, 11687, 11685, 11330, 11633, 11644, 11075, 11575, 11626, 11624, 11629, 11591, 11618, 11622, 11627, 11532, 11190, 11554, 11555, 11556, 11549, 11560, 11538, 11507, 11505, 11504, 11414, 11497, 11452, 11474, 11477, 11335, 11417, 11438, 11028, 11368, 11380, 18094, 18095, 11063, 11359, 11353, 10838, 11013, 11041, 11177, 11073, 18100, 11138, 11257, 11277, 11276, 11275, 11291, 11254, 11250, 11224, 11197, 18102, 11179, 11202, 11209, 11204, 11203, 11205, 11160, 11153, 11157, 11150, 11146, 10739, 11143, 11136, 11133, 11139, 11135, 11129, 27759, 27758, 11034, 11107, 11101, 10983, 11100, 11017, 11070, 10939, 10929, 11097, 11076, 11087, 11050, 11038, 11040, 10932, 11023, 11016, 11012, 11003, 10990, 10923, 10951, 10979, 10942, 10927, 10865, 18110, 10859, 10925, 10915, 10909, 10869, 10850, 10826, 10886, 10885, 10879, 18112, 10783, 10833, 10854, 10851, 10830, 10827, 10628, 10818, 10815, 10792, 10778, 10772, 10624, 10776, 10795, 10796, 10766, 10797, 10765, 10771, 10770, 10798, 10812, 10777, 10698, 10749, 10674, 10645, 10709, 10721, 10672, 10654, 18121, 10597, 10578, 10640, 10570, 10633, 10625, 10595, 10614, 10612, 10615, 10585, 10573, 18128, 18125, 10464, 18131, 10442, 10476, 10471, 18133, 10420, 10429, 10417, 10427, 10416, 10348, 10335, 10325, 10309, 10310, 10237, 10239, 10227, 10225, 10091, 10110, 10108, 10111, 10106, 10022, 27769, 10034, 10023, 10035, 10036, 10044, 10042, 10025, 9993, 18142, 18141, 9925, 9923, 9946, 9926, 9932, 9934, 9930, 9896, 18145, 18143, 18147, 9837, 9838, 9845, 9841, 9731, 18151, 9713, 9668, 9688, 9686, 9609, 9617, 9616, 9571, 9561, 9569, 9627, 9625, 9619, 9462, 9634, 9534, 9777, 9416, 9415, 8927, 8926, 8767, 8626, 8549, 8180, 9379, 8076, 7882, 7798, 7804, 7805, 7721, 7611, 7194, 7110, 6957, 7078, 7027, 7127, 7084, 7055, 7041, 7042, 7021, 6991, 6986, 7005, 7006, 6611, 6970, 6866, 6770, 6887, 6492, 6910, 6876, 6781, 6814, 6762, 6719, 6634, 6683, 6534, 6626, 6538, 6495, 6513, 6514, 6496, 6471, 6429, 6467, 6377, 6288, 6342, 6345, 6267, 6113, 6084, 6064, 5911, 6005, 5945, 5904, 5854, 5894, 5807, 5224, 5682, 5674, 5696, 5670, 5667, 5533, 5600, 5527, 5450, 5421, 6473, 5234, 5377, 5218, 5252, 5247, 5244, 5240, 5232, 5231, 5228, 5205, 5192, 5176, 5111, 5171, 5172, 5115, 5129, 5131, 5132, 5067, 5102, 5016, 5018, 5038, 4965, 5031, 4970, 4950, 4904, 4939, 4930, 4890, 4802, 4387, 4719, 4663, 4671, 4675, 4558, 4587, 4609, 4592, 4536, 4513, 4504, 4477, 4460, 4462, 4407, 4388, 4438, 4439, 4405, 4334, 4362, 4346, 4328, 4330, 4290, 4289, 4256, 4267, 4255, 4216, 4242, 4241, 4210, 4225, 4227, 4226, 4147, 4202, 4203, 4173, 4169, 4157, 4102, 4089, 4123, 4137, 4136, 4125, 4124, 4114, 4116, 4064, 4083, 4081, 4085, 4082, 4018, 4022, 4017, 4048, 4020, 4045, 4041, 4034, 4027, 4035, 4019, 3979, 4006, 3998, 3987, 3990, 3991, 3967, 3976, 3973, 3930, 3923, 3916, 3921, 3876, 3919, 3838, 3914, 3910, 3904, 3890, 3884, 3885, 3888, 3886, 3866, 3599, 3844, 3826, 3839, 3860, 3849, 3791, 3782, 3825, 3822, 3606, 3745, 3793, 3779, 3812, 3814, 3809, 3815, 3784, 3743, 3755, 3765, 3772, 3726, 3729, 3741, 3680, 3704, 3652, 3690, 3683, 3576, 3660, 3667, 3650, 3610, 3620, 3630, 3607, 3577, 5440, 3570, 3588, 3500, 3567, 3554, 3556, 3446, 3497, 3526, 3533, 3534, 3470, 3471, 3479, 3480, 3449, 3468, 3472, 3788, 3452, 3444, 3319, 3420, 3429, 3398, 3391, 3368, 3384, 3399, 3407, 3416, 3419, 3357, 3375, 3378, 3350, 3349, 3296, 3331, 3330, 3321, 3309, 3307, 3305, 3297, 3290, 3248, 3256, 3272, 3249, 3252, 3244, 2658, 3156, 3226, 3200, 3176, 3104, 3153, 3122, 3138, 3108, 3107, 2661, 3068, 3065, 3042, 3040, 2511, 2486, 2506, 2505, 2439, 2514, 2450, 2425, 2458, 2365, 2463, 2355, 2522, 2338, 2523, 2310, 2334, 2199, 2314, 2668, 2311, 2268, 2298, 2301, 2193, 2671, 2213, 2173, 2142, 2140, 2190, 2676, 2675, 2678, 2169, 2160, 2139, 2121, 2134, 2094, 2681, 2045, 2092, 2084, 2078, 2685, 2066, 2060, 2052, 2056, 1956, 2021, 2028, 2020, 2026, 2002, 1983, 1950, 1945, 2690, 2691, 1916, 1874, 1878, 2700, 1843, 2708, 1786, 1836, 1833, 2714, 2713, 1799, 2716, 1765, 1767, 1768, 1750, 1665, 1741, 1737, 1720, 1652, 2550, 1664, 1659, 1628, 1647, 2552, 2554, 1614, 1611, 1621, 1623, 1593, 1589, 1590, 1577, 1572, 2468, 1530, 1549, 1546, 2758, 1515, 1494, 1470, 1377, 1370, 1338, 1327, 1328, 1317, 1263, 1265, 1266, 1280, 1204, 1172, 1173, 1149, 1157, 1150, 1135, 1107, 1108, 1075, 1061, 1060, 1034, 1019, 1021, 987, 988, 1002, 989, 826, 2833, 952, 950, 926, 927, 2835, 899, 877, 871, 862, 873, 2840, 839, 2843, 808, 809, 822, 2858, 2857, 755, 766, 720, 751, 736, 748, 731, 2866, 694, 702, 696, 697, 712, 710, 703, 715, 689, 632, 681, 674, 670, 660, 659, 658, 629, 656, 1094, 2876, 2618, 623, 625, 607, 605, 532, 585, 584, 530, 593, 2619, 2884, 545, 565, 579, 557, 576, 563, 582, 567, 2888, 535, 519, 503, 516, 507, 504, 506, 523, 509, 510, 505, 522, 665, 2892, 497, 324, 490, 494, 495, 489, 340, 486, 452, 451, 454, 470, 455, 480, 477, 476, 432, 2896, 441, 500, 435, 431, 2899, 2900, 424, 423, 2902, 380, 420, 410, 399, 415, 400, 403, 405, 408, 370, 377, 373, 2912, 336, 348, 357, 360, 341, 366, 344, 350, 338, 2922, 337, 2924, 335, 333, 303, 331, 317, 314, 311, 2931, 102, 101, 119, 109, 104, 105, 136, 110, 108, 129, 103, 121, 128, 2936, 66, 306, 299, 274, 253, 2945, 296, 1, 24, 6, 5, 3, 30, 29, 2641, 2955, 2954, 291, 2961, 2964, 2962, 292, 288, 2968, 2972, 264, 2981, 2982, 56, 47, 50, 53, 57, 44, 61, 2986, 276, 275, 278, 2995, 272, 263, 261, 269, 252, 258, 257, 254, 256, 248, 3003, 242, 243, 234, 233, 224, 84, 221, 83, 211, 213, 187, 193, 198, 192, 85, 180, 161, 182, 160, 173, 172, 175, 166, 147, 142, 144, 141, 150, 3020, 3021)) 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.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, 11.9, mysql)
Reported on decksite by mysql-perf
Location Hash: 44495120dd602ac898d6f366ac3d3f3347f795fb
Labels: decksite
[](slow_query, 14.6, mysql)Reported on decksite by mysql-perf
Location Hash: 44495120dd602ac898d6f366ac3d3f3347f795fb