Exceeded slow_query limit (6.6 > 5.0) in mysql: ```

[vorpal-buildbot]

    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 (64402, 64366, 63922, 63706, 61874, 63587, 63550, 63446, 63342, 63144, 63103, 63005, 63096, 62969, 62867, 62811, 62689, 62658, 62583, 62006, 62305, 62303, 62250, 62241, 62191, 62167, 61893, 62097, 62122, 62114, 62055, 63075, 61906, 61877, 61865, 61856, 61846, 61840, 61842, 61836, 61839, 61824, 61822, 61769, 61753, 61699, 61688, 60842, 61644, 61564, 61591, 61504, 61529, 61495, 61506, 61458, 61246, 61409, 61405, 61374, 61347, 61356, 61351, 61256, 60993, 61145, 61303, 61282, 61279, 61200, 61048, 61238, 61146, 61185, 59438, 61129, 61035, 61130, 61112, 61051, 61011, 61003, 60983, 60985, 60971, 60880, 60894, 60876, 60807, 60855, 60815, 60844, 60414, 60394, 60728, 60715, 60268, 60635, 60619, 60574, 60508, 60485, 60460, 60377, 60343, 60210, 60197, 59721, 60207, 60280, 60137, 60231, 59976, 60050, 60046, 59895, 60020, 60128, 60104, 60000, 59993, 60036, 59935, 59990, 59979, 59964, 59757, 59930, 59876, 59845, 59821, 59800, 59829, 59796, 59789, 59396, 59779, 59639, 59579, 59764, 59742, 59743, 59685, 59710, 59676, 59564, 59701, 59693, 59688, 59631, 59641, 59455, 59557, 59545, 59514, 59492, 59424, 59439, 59478, 59426, 59413, 59345, 59293, 59296, 59253, 59230, 59223, 59190, 59125, 59056, 59013, 59010, 58932, 58974, 58937, 58918, 58733, 58879, 58822, 58824, 58582, 58659, 58420, 58304, 58307, 57564, 58125, 58115, 58035, 57907, 57232, 56747, 56656, 56592, 56620, 56409, 56445, 56334, 56172, 56304, 56143, 56064, 56017, 55989, 55968, 55891, 55596, 55698, 55762, 55758, 55741, 55608, 55460, 55446, 55447, 55323, 55305, 55280, 55273, 55110, 55205, 55024, 55015, 54968, 54867, 54829, 54856, 54753, 54837, 54661, 54610, 54656, 54483, 54500, 54319, 54349, 54113, 54337, 54274, 54293, 54287, 54219, 54226, 54227, 54169, 54145, 54050, 53976, 53954, 53957, 53953, 53867, 53862, 53863, 53830, 53827, 53797, 53791, 53792, 53698, 53700, 53545, 53455, 53461, 53458, 53456, 53460, 53346, 53423, 53388, 53383, 53320, 53271, 53281, 53273, 53231, 53168, 53169, 53092, 52869, 51373, 53056, 52896, 52828, 52648, 52649, 52574, 52606, 52533, 52543, 52434, 52455, 52189, 52345, 52084, 51991, 51966, 51956, 51950, 51834, 51833, 51650, 51364, 51543, 51544, 51493, 51492, 51479, 51480, 51399, 51419, 51418, 50693, 51276, 51241, 51237, 51238, 50966, 50814, 50747, 50748, 50503, 50647, 50674, 50362, 50490, 50491, 50195, 49164, 49739, 49692, 49528, 49442, 49598, 49566, 49391, 49224, 49137, 48677, 49017, 48141, 48830, 48831, 48629, 48426, 48514, 48490, 48461, 48460, 48394, 48352, 48145, 48136, 48121, 48014, 47960, 47937, 47887, 47926, 47880, 47867, 47853, 47832, 47797, 47760, 47714, 47713, 47677, 47629, 47472, 47520, 47524, 47521, 46337, 47465, 47469, 47426, 47428, 47427, 47382, 47340, 47341, 47328, 47277, 47195, 47185, 46921, 46915, 47217, 47218, 47223, 46847, 47057, 47079, 47060, 47053, 46883, 47039, 46993, 46994, 46962, 46940, 46920, 46800, 46868, 46884, 46885, 46831, 46795, 44793, 46761, 46780, 46695, 46651, 46642, 46641, 46589, 46519, 45313, 45477, 46036, 46037, 45898, 45899, 45903, 45774, 45408, 44997, 44755, 44120, 44382, 44008, 44006, 43959, 43756, 43908, 43909, 43821, 43823, 43830, 42750, 43393, 43395, 43396, 43339, 43336, 43335, 43252, 43253, 43254, 43169, 43170, 42854, 43034, 43035, 42897, 42908, 42771, 42423, 42735, 42719, 42624, 42122, 42585, 42575, 42558, 42559, 42333, 42527, 42677, 42399, 42292, 42337, 42310, 42306, 42301, 42201, 42194, 42217, 42095, 42163, 42165, 42141, 42142, 42061, 42009, 41924, 41912, 41882, 36595, 41809, 41811, 41789, 41286, 41733, 41778, 41777, 41737, 40343, 41689, 41641, 41582, 41578, 41574, 41546, 41518, 40628, 40474, 40359, 40174, 40080, 40136, 40093, 40092, 40053, 37390, 40014, 39573, 38843, 34715, 39462, 38712, 32912, 38786, 37651, 38149, 38029, 37778, 37736, 37669, 37667, 36359, 37041, 37182, 37081, 36840, 36853, 36805, 36809, 36747, 36760, 34355, 36729, 36493, 35787, 36335, 36253, 36194, 36209, 36210, 36224, 36219, 36114, 36081, 36069, 36040, 35978, 35894, 35614, 35821, 35588, 35804, 35655, 35485, 35517, 35433, 34908, 35435, 35436, 34909, 34765, 35098, 34811, 34279, 34529, 34699, 34486, 34822, 34826, 34414, 34621, 34398, 34252, 34240, 34147, 34053, 34292, 34369, 34192, 34132, 34025, 33530, 33923, 32705, 33787, 33644, 33788, 33661, 33689, 33759, 33754, 33745, 33747, 33658, 33638, 33480, 33341, 33462, 33342, 33243, 33197, 33288, 33165, 33296, 33297, 33298, 32764, 33093, 32977, 32960, 32650, 32931, 32929, 32747, 32876, 32878, 32890, 32338, 32746, 32731, 32734, 32560, 32651, 32632, 32629, 32512, 32563, 32564, 32478, 32582, 32334, 32542, 32496, 32377, 32481, 32450, 32428, 32465, 32449, 32290, 32448, 32442, 32393, 32409, 32396, 32272, 32356, 32371, 32353, 32336, 32333, 32319, 32273, 31504, 31329, 31317, 31264, 31256, 31251, 31148, 31189, 31192, 31205, 30924, 31067, 31034, 31021, 30995, 30888, 30957, 30292, 30810, 30798, 41376, 30794, 30747, 30669, 30642, 30590, 30358, 30492, 30264, 30301, 30460, 30359, 30416, 30391, 30376, 30363, 30368, 30369, 30318, 30317, 30062, 30310, 30302, 30295, 30262, 30255, 30241, 30202, 30227, 30183, 30148, 30157, 30124, 30125, 30105, 30091, 30061, 30027, 29981, 29977, 29916, 29884, 29887, 29876, 29847, 29817, 29828, 29796, 29236, 29714, 29627, 29678, 29662, 29397, 29172, 29612, 29613, 29523, 29350, 29370, 29360, 29303, 29308, 29288, 29156, 29242, 29181, 29168, 29148, 29014, 29101, 29061, 29049, 28853, 28990, 28927, 28947, 28948, 28888, 28917, 28874, 28875, 28797, 28829, 28798, 28765, 28727, 28704, 28565, 28537, 28457, 28422, 28411, 28452, 28393, 28126, 27868, 27812, 27500, 27488, 27464, 27341, 26874, 26771, 26773, 26811, 26743, 26402, 26608, 26216, 26551, 26449, 26438, 26324, 26380, 26207, 26217, 26236, 26166, 26097, 26148, 26076, 25963, 25997, 26001, 25839, 25927, 25819, 25904, 25893, 25765, 25729, 25665, 25642, 25717, 25632, 25383, 25534, 25391, 25449, 25297, 25266, 25267, 25268, 25203, 25224, 25154, 25207, 25153, 25090, 25171, 25083, 25017, 24561, 24982, 24921, 24980, 24834, 24617, 24863, 24894, 24885, 24893, 24888, 24890, 24708, 24744, 24738, 24807, 24809, 24790, 24721, 24727, 24722, 24639, 24532, 24590, 24592, 24591, 24517, 24307, 24389, 23108, 24295, 24384, 24381, 24385, 24340, 24103, 24369, 24356, 24361, 24362, 24039, 24271, 24267, 24218, 24160, 24265, 24254, 24166, 24174, 24004, 23906, 24061, 23790, 23773, 23852, 23832, 23725, 23758, 23636, 23447, 23746, 23718, 23678, 23690, 23641, 23394, 23635, 23642, 23595, 23483, 23521, 23412, 23410, 23403, 23392, 23325, 23333, 23318, 23334, 23337, 23336, 23242, 23253, 23256, 23245, 23222, 23197, 23176, 23177, 23099, 23095, 27652, 23096, 23085, 23147, 23146, 23070, 22976, 23021, 22973, 22985, 22988, 22998, 22899, 22898, 22866, 22864, 22839, 27662, 22809, 22712, 22737, 22774, 22777, 22735, 22571, 22475, 22487, 22642, 22641, 22670, 22643, 22614, 22371, 22542, 22579, 22575, 22481, 22472, 22421, 22437, 22438, 22405, 22385, 22302, 22229, 22320, 22306, 22119, 22200, 22213, 22206, 22182, 22141, 22162, 22097, 21972, 21994, 22002, 21962, 21948, 21737, 21890, 21901, 21909, 21912, 21184, 21783, 21751, 21616, 21478, 20704, 21607, 21625, 21590, 21501, 21557, 21471, 21439, 21372, 21357, 21358, 21212, 21236, 21230, 21221, 21194, 21150, 21093, 21074, 21078, 21097, 21096, 21101, 21027, 21077, 20987, 20899, 20728, 20828, 20868, 20869, 20870, 20784, 20803, 20718, 20756, 20742, 20754, 20648, 20618, 20608, 20556, 20261, 20564, 19759, 20574, 20573, 20576, 20450, 20523, 20524, 20422, 20488, 20405, 20329, 20414, 20385, 20167, 20341, 20286, 20322, 20312, 20209, 20268, 20212, 20000, 20181, 20114, 20155, 20081, 20141, 20142, 20126, 20113, 19894, 20075, 19900, 20044, 20043, 20045, 19755, 19989, 19957, 19856, 18974, 19922, 19930, 19928, 19892, 19860, 19869, 19864, 19728, 19754, 19729, 19670, 19774, 19752, 19689, 19659, 19639, 19597, 19498, 19546, 19377, 19532, 19204, 19346, 19437, 19463, 19328, 19391, 19233, 19224, 19240, 19211, 19149, 19247, 19252, 19251, 19178, 19115, 19105, 19191, 19139, 18914, 18982, 19132, 19107, 18935, 19014, 19079, 19092, 19082, 18942, 19006, 18909, 18908, 18958, 18897, 18894, 18870, 18851, 18815, 18827, 18828, 18829, 18830, 18831, 18833, 18330, 18824, 18722, 18806, 18524, 18769, 18761, 18657, 18738, 18736, 18678, 18716, 18428, 18711, 18680, 18662, 18665, 18549, 18528, 18540, 18510, 18467, 18429, 18508, 18441, 18574, 18573, 18572, 18483, 18486, 18450, 18466, 18443, 18436, 18405, 18396, 18384, 18370, 18589, 18588, 18325, 18307, 18603, 18604, 18290, 18619, 18624, 18627, 18233, 18217, 17716, 17202, 18638, 18640, 18639, 18641, 18178, 17761, 17608, 17827, 17834, 17826, 17781, 17707, 17722, 17734, 17735, 17526, 17704, 17638, 17598, 17683, 17649, 17664, 17667, 17642, 17621, 17620, 17626, 17606, 17535, 17567, 17570, 17569, 17571, 17572, 17550, 17508, 17539, 17533, 17441, 17528, 17521, 17520, 17513, 17477, 17498, 17502, 17495, 17462, 17464, 17463, 17442, 17405, 17292, 17341, 17342, 17305, 17276, 17300, 17266, 17188, 17281, 17264, 17251, 17249, 17231, 17228, 17229, 16757, 17150, 17151, 17152, 17075, 17082, 16562, 17048, 17052, 17012, 16987, 16993, 16876, 16959, 16867, 16923, 16924, 16761, 16869, 16728, 16801, 16793, 16764, 16709, 16755, 16714, 16633, 16658, 16419, 16653, 16626, 16520, 16573, 17895, 16611, 16491, 16560, 16529, 16517, 16417, 17898, 16298, 16454, 16469, 16437, 16284, 16283, 16270, 16274, 16244, 16242, 16243, 16223, 16071, 15991, 16060, 16044, 16039, 16012, 15974, 15965, 15964, 15815, 15850, 15869, 15870, 15858, 15629, 15743, 15585, 15287, 15157, 15695, 15697, 15733, 15719, 15713, 15707, 15689, 15520, 15657, 15623, 15608, 15602, 15587, 15554, 15553, 15556, 15530, 15436, 15435, 15482, 15392, 15229, 15307, 15364, 15366, 15258, 15290, 15222, 15250, 14858, 15176, 15150, 15106, 15074, 15086, 14672, 15014, 14738, 14987, 14997, 15000, 14998, 14999, 14965, 14945, 14848, 14749, 14902, 14855, 14822, 14601, 14739, 14733, 14716, 14685, 14686, 14653, 14643, 14634, 14640, 14615, 14590, 14431, 14549, 14550, 14551, 14554, 14555, 14552, 14556, 14523, 14520, 14487, 14497, 14498, 14499, 14501, 14500, 14429, 14388, 14383, 14441, 14443, 14319, 14179, 14365, 14349, 14356, 14005, 14284, 14287, 14285, 14273, 14244, 13722, 14203, 14197, 14227, 14132, 14086, 14075, 14121, 14115, 14064, 14083, 14072, 14012, 13950, 13953, 13931, 13971, 13972, 13973, 22516, 22517, 13665, 13701, 13677, 13685, 13651, 13531, 18011, 13610, 13618, 13631, 13632, 13599, 18013, 13593, 13580, 13030, 13566, 13575, 13514, 13551, 13523, 13548, 13553, 13490, 13547, 13533, 13538, 13535, 13534, 13458, 13424, 13495, 13508, 13498, 13426, 13469, 13481, 13473, 13454, 13437, 13443, 13438, 13401, 13397, 13345, 13412, 13419, 13418, 13349, 13380, 13385, 13289, 13359, 12738, 13335, 13308, 22893, 22880, 22885, 13306, 13205, 13252, 13234, 12951, 13209, 13253, 13254, 13255, 13230, 13213, 13216, 13195, 13168, 13084, 13128, 13122, 13120, 13088, 13094, 13092, 13046, 13058, 13055, 13049, 13053, 13025, 12855, 12995, 13024, 12943, 13009, 12985, 12924, 12972, 12819, 12934, 12486, 12825, 12906, 12905, 12694, 12809, 12848, 12840, 12732, 12793, 12751, 12756, 12752, 12753, 12716, 12691, 12659, 12678, 12672, 12643, 12576, 12646, 12551, 12631, 12628, 12602, 12532, 12557, 12553, 12477, 12515, 12510, 12449, 12436, 12425, 12426, 12492, 12501, 12419, 12440, 12413, 12340, 12373, 12366, 12302, 12377, 12338, 12298, 12323, 12327, 12326, 12293, 11972, 12235, 18163, 12246, 12247, 12272, 12263, 12207, 12215, 12134, 12202, 12128, 12133, 12195, 11827, 11775, 12149, 12110, 12129, 12058, 12066, 12099, 12100, 12069, 12090, 12077, 12084, 12055, 12038, 12040, 11919, 12009, 11939, 12037, 11986, 11992, 11987, 11935, 11925, 11945, 11924, 11950, 11907, 11888, 11913, 11864, 11899, 11897, 11429, 11786, 11869, 11808, 11860, 11831, 11839, 11807, 11782, 11774, 11787, 11785, 11754, 11768, 11742, 11730, 11746, 11750, 11727, 11728, 11653, 11662, 11337, 11500, 11686, 11701, 11688, 11690, 11650, 11600, 11604, 11193, 11585, 11594, 11540, 11528, 11396, 11536, 11559, 11558, 11530, 11486, 11430, 11488, 11455, 11451, 11450, 11419, 11441, 11440, 11390, 11002, 11348, 11270, 11346, 11366, 11351, 11309, 11301, 10978, 11256, 11248, 11285, 11162, 10968, 11206, 11207, 11164, 11163, 11149, 10735, 11103, 10601, 11054, 11022, 10744, 11096, 11092, 11018, 10992, 10947, 10980, 10941, 10974, 10950, 10952, 10948, 10944, 10831, 10782, 10704, 10877, 10659, 10822, 18117, 10750, 10802, 10801, 10737, 10722, 10723, 10661, 10608, 10610, 10609, 10402, 10457, 10478, 10477, 10210, 10435, 10447, 10242, 18134, 10312, 10313, 10093, 18135, 9847, 10158, 10187, 9809, 10234, 10193, 10191, 10171, 10146, 10133, 9988, 10090, 10113, 9790, 10062, 10056, 10047, 10013, 9885, 9795, 9998, 9979, 9981, 9949, 9907, 9863, 9827, 9830, 9791, 9711, 9656, 9679, 9614, 9556, 9557, 9539, 9492, 9498, 9465, 9152, 9423, 9015, 8876, 9262, 9273, 9271, 9259, 9172, 9167, 9176, 9190, 9068, 9162, 9105, 9334, 9336, 9124, 9131, 9092, 8971, 8869, 9017, 9004, 8974, 8875, 8935, 8793, 8209, 8748, 8850, 8807, 8787, 8780, 8725, 8717, 8763, 8753, 8754, 8682, 8703, 8704, 8656, 8702, 8698, 8694, 8650, 8573, 8595, 8590, 8612, 8610, 8566, 8564, 8524, 8495, 8496, 9361, 8516, 8513, 8500, 8507, 8487, 8435, 8465, 8545, 8534, 8407, 8452, 8402, 8404, 8382, 8400, 8396, 8129, 8366, 8355, 8332, 8243, 8221, 8146, 7960, 8021, 8170, 8124, 8132, 8079, 8013, 8052, 8054, 7975, 7986, 7941, 7925, 7922, 7724, 7870, 7766, 7858, 7829, 7725, 7793, 7788, 7722, 7707, 7638, 7688, 7634, 7631, 7260, 7592, 7600, 7507, 7570, 7452, 7478, 7284, 7254, 7220, 7140, 6277, 7159, 7148, 7109, 7094, 7112, 7113, 7114, 6996, 6997, 6998, 7000, 7001, 6949, 6968, 6962, 6966, 6848, 6893, 6906, 6894, 6819, 6703, 6810, 6782, 6738, 6750, 6753, 6716, 6705, 6725, 6649, 6691, 6699, 6665, 6149, 6690, 6687, 6679, 6661, 6642, 6629, 6627, 6545, 6529, 6318, 6470, 6395, 6453, 6353, 6378, 6379, 6386, 6362, 6348, 6307, 6356, 6352, 6316, 6293, 6227, 6210, 6159, 6144, 6133, 6134, 6120, 6109, 6093, 6026, 6052, 6053, 6062, 6036, 6020, 5951, 5846, 5919, 5903, 5829, 5830, 5819, 5381, 5657, 5595, 5487, 5345, 5338, 5364, 5312, 5330, 5298, 5281, 5051, 5143, 4906, 4979, 4981, 4964, 4951, 4948, 4642, 4922, 4934, 4905, 4895, 4810, 4829, 4564, 4633, 4630, 4538, 4524, 4485, 4526, 4508, 4492, 4452, 4418, 4392, 4353, 4351, 4340, 4326, 4275, 4293, 4297, 4246, 4291, 4281, 4282, 4219, 4262, 4260, 4221, 4222, 4224, 4209, 4190, 4162, 4164, 4145, 4023, 4104, 4105, 4098, 4047, 4075, 4076, 4049, 4059, 4039, 3980, 4002, 3983, 3960, 3941, 3926, 3900, 3746, 3845, 3846, 3824, 3829, 3795, 3801, 3792, 3811, 3756, 3760, 3759, 3762, 3678, 3712, 3711, 3713, 3714, 3722, 3439, 3699, 3691, 3647, 3640, 3651, 3661, 3662, 3430, 3637, 3639, 3627, 3613, 3582, 3583, 3549, 3446, 3537, 3520, 3421, 3394, 3395, 3390, 3385, 3356, 3353, 3354, 3326, 3303, 3255, 3269, 3218, 3228, 3219, 3221, 3137, 3056, 3058, 3057, 3055, 3033, 3034, 3037, 3035, 3048, 3036, 2366, 2489, 2502, 2490, 2503, 2491, 2414, 2428, 2415, 2416, 2383, 2386, 2387, 2388, 2389, 2349, 2357, 2343, 2331, 2323, 2666, 2291, 2209, 2200, 2195, 2150, 2156, 2159, 2083, 1840, 1977, 1955, 1931, 1934, 1939, 1909, 1816, 1818, 1828, 2546, 1774, 1691, 1631, 2731, 1558, 1540, 1522, 1475, 1463, 1445, 1446, 1416, 1388, 1382, 1376, 1366, 1344, 1340, 1322, 1307, 1234, 1240, 1247, 1258, 1216, 1227, 1195, 1197, 1208, 1186, 1143, 1119, 2817, 1111, 1098, 970, 1086, 1074, 1067, 1043, 1042, 1007, 1031, 1035, 1009, 985, 999, 976, 972, 878, 969, 965, 942, 963, 944, 943, 917, 939, 933, 879, 880, 901, 882, 872, 858, 805, 801, 800, 803, 807, 806, 2851, 791, 835, 792, 793, 790, 788, 795, 759, 764, 761, 765, 724, 746, 725, 726, 727, 708, 617, 532, 553, 566, 608, 550, 517, 464, 396, 2908, 2914, 334, 117, 2949, 2974, 39, 249, 228, 210, 86, 91)) 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, 6.6, mysql)

Reported on decksite by mysql-perf

Location Hash: 18c5c3781d5caa776872a2c02ee1d7b3ca46acda

[vorpal-buildbot]

Exceeded slow_query limit (15.0 > 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 (64717, 64618, 64555, 64612, 64554, 64308, 64197, 64138, 63983, 63980, 63927, 63950, 63839, 63629, 63764, 63761, 63726, 63640, 63530, 63706, 61874, 62256, 63587, 63549, 63426, 63260, 63605, 63592, 63536, 63487, 63533, 63534, 63525, 63289, 63456, 62912, 63382, 63433, 63429, 63418, 63369, 63351, 62902, 62235, 63230, 62605, 63192, 63170, 63144, 63142, 63103, 63020, 63005, 62986, 62881, 63096, 63053, 62853, 63012, 62993, 62990, 62973, 62508, 62976, 62977, 62969, 62962, 62919, 62736, 62861, 62916, 62521, 62899, 62374, 62666, 62867, 62819, 62801, 62775, 62425, 63061, 62703, 62684, 62499, 62706, 62272, 62667, 62636, 62628, 62658, 62389, 62557, 62609, 62600, 62559, 62543, 62591, 62583, 63062, 62542, 62538, 62526, 62493, 62511, 62519, 62436, 63064, 62410, 62394, 62335, 62006, 62305, 62372, 62127, 62356, 62320, 62175, 62247, 62303, 62283, 62276, 62269, 62195, 62163, 62224, 62179, 62125, 62176, 62171, 62147, 62053, 62141, 62058, 62016, 62122, 62046, 62094, 63074, 62055, 62018, 62037, 61905, 61851, 61991, 61977, 61978, 61971, 61909, 63075, 61910, 61906, 61881, 61856, 61845, 61846, 61844, 61836, 61839, 61824, 61818, 61793, 61797, 61778, 61769, 61753, 61699, 61723, 61702, 61686, 61688, 61649, 60842, 61633, 61644, 61375, 61525, 61564, 61591, 61504, 61529, 61495, 61508, 61506, 61458, 59556, 60966, 61081, 61454, 61246, 61424, 61409, 61365, 61405, 61374, 61362, 61347, 61350, 61356, 61351, 61323, 61256, 61336, 61339, 60993, 61304, 60234, 61307, 61145, 61303, 61280, 61282, 61279, 61200, 61048, 61238, 61190, 61191, 61196, 61120, 61146, 61185, 61176, 59438, 61129, 61035, 61130, 61122, 61112, 61109, 61034, 61051, 61011, 61003, 60983, 61008, 60887, 60985, 60971, 60945, 60927, 60915, 60911, 60908, 60631, 60880, 60894, 60876, 60807, 60855, 60815, 60844, 60847, 60414, 60822, 60394, 60800, 60702, 60714, 60774, 60756, 60728, 60722, 60715, 60457, 60684, 60698, 60268, 60695, 60635, 60620, 60491, 60619, 60625, 60611, 60591, 60551, 60574, 60559, 60508, 60482, 60534, 60485, 59842, 60462, 59987, 60314, 60460, 60445, 60309, 60442, 60449, 60443, 59988, 60343, 60210, 60367, 60197, 60319, 59721, 60207, 60280, 60269, 60220, 60137, 60066, 60231, 60248, 60029, 60212, 60200, 59976, 60050, 59895, 60046, 60020, 60128, 60130, 60118, 60105, 60104, 59974, 60000, 59993, 60025, 60036, 60028, 59723, 59935, 59990, 59979, 59715, 59964, 59972, 59757, 59930, 59876, 59845, 59821, 59872, 59871, 59863, 59844, 59800, 59856, 59773, 59829, 59796, 59789, 59396, 59785, 59779, 59639, 59579, 59764, 59740, 59731, 59716, 59685, 59710, 59676, 59564, 59701, 59693, 59688, 59631, 59641, 59417, 59549, 59455, 59522, 59504, 59557, 59524, 59514, 59508, 59429, 59492, 59496, 59424, 59439, 59478, 59434, 59426, 59404, 59413, 59392, 59345, 59358, 59192, 59293, 58893, 59311, 58377, 59305, 59296, 59299, 59287, 59271, 59217, 59253, 59230, 59223, 59190, 59186, 58950, 59178, 59125, 58581, 59085, 59122, 59059, 59100, 59051, 59056, 58930, 59013, 57770, 59068, 58666, 59049, 59050, 58891, 59034, 59015, 59027, 59026, 59022, 59018, 59010, 58932, 58809, 58692, 58942, 58970, 58973, 58974, 58972, 58938, 58937, 58939, 58918, 58910, 58850, 58733, 58876, 58886, 58880, 58879, 58816, 58713, 58826, 58821, 58823, 58822, 58824, 58730, 58785, 58786, 58760, 58770, 58776, 58772, 58775, 58771, 58781, 58539, 58233, 58734, 58725, 58410, 58710, 58645, 58582, 58681, 58646, 58408, 58345, 58659, 58633, 58615, 58574, 58603, 58597, 57306, 58586, 58577, 58562, 58564, 58548, 58518, 58556, 58482, 58535, 58386, 58532, 58491, 58225, 58462, 58384, 58405, 58350, 58411, 58375, 58341, 58427, 58420, 58434, 58431, 58426, 58419, 58390, 58388, 57345, 58175, 58269, 58352, 58367, 58130, 58348, 58337, 58064, 58331, 58329, 58236, 57940, 58315, 58304, 58326, 58306, 58305, 58316, 58307, 58323, 58266, 58187, 58264, 58261, 58084, 58255, 57564, 58031, 58220, 58217, 58120, 58172, 58195, 58211, 58197, 58198, 58203, 58205, 58212, 58176, 58138, 58044, 57466, 58150, 58097, 58109, 58125, 58115, 57624, 58093, 58035, 58098, 57559, 57990, 57902, 58042, 58021, 58056, 58048, 58058, 58061, 58023, 58016, 57970, 58014, 57998, 57965, 57963, 57881, 57929, 57935, 57907, 57890, 57884, 57876, 57793, 57873, 57852, 57841, 56664, 57830, 57836, 57727, 57784, 57369, 57820, 57815, 57819, 57813, 57814, 57376, 57558, 57765, 57662, 57693, 57618, 57682, 57700, 57701, 57702, 57714, 57713, 57648, 57572, 57498, 57553, 57582, 57596, 57583, 57586, 57587, 57595, 57597, 57585, 57525, 57491, 57555, 57550, 57482, 57539, 57543, 57540, 57464, 57414, 57506, 57501, 57495, 57485, 57341, 57472, 57477, 57227, 57424, 57459, 57456, 57445, 57429, 57431, 57432, 57430, 57389, 57402, 57408, 57271, 57372, 57366, 57097, 57355, 57328, 57284, 57333, 57329, 57308, 57291, 57142, 57276, 57172, 57232, 57193, 57054, 57051, 57159, 57143, 57137, 57102, 57089, 57113, 57114, 57109, 57120, 57112, 57119, 57111, 57115, 57083, 57087, 57071, 57016, 57198, 56963, 56980, 56972, 56978, 56981, 56945, 56881, 56882, 56747, 56902, 56901, 56887, 56801, 56854, 56851, 56613, 56568, 56784, 56748, 56732, 56656, 56745, 56743, 56592, 56711, 56660, 56680, 56681, 56628, 56620, 56608, 56605, 56531, 56519, 56509, 56240, 56467, 56409, 56445, 56434, 55261, 56216, 56391, 56369, 56412, 56406, 55890, 56330, 56334, 56383, 56172, 56376, 56273, 56325, 56353, 56354, 56352, 56351, 56357, 56304, 56178, 56030, 56258, 56170, 56248, 56211, 56236, 55847, 56228, 56224, 56215, 56212, 56018, 57205, 56167, 56201, 56186, 56203, 56188, 56193, 56100, 56064, 56128, 56138, 56131, 56104, 56101, 56105, 56099, 56041, 56072, 56091, 56093, 56092, 56059, 56001, 56017, 56008, 56036, 56023, 55997, 55989, 56009, 57215, 55968, 55675, 55801, 55908, 55898, 57216, 55910, 55922, 55911, 55921, 55912, 55822, 55891, 55875, 55596, 55865, 55862, 55868, 55735, 55824, 55820, 55814, 55809, 55816, 55796, 55622, 55754, 55785, 55660, 55771, 55698, 55762, 55758, 54429, 55741, 55714, 55715, 55558, 55700, 55591, 54876, 55681, 55671, 55665, 55664, 55621, 55608, 55560, 55544, 55637, 55649, 55638, 55600, 55588, 55583, 55478, 55554, 55398, 55528, 55525, 55520, 55471, 55432, 55460, 55493, 55506, 55504, 55503, 55513, 55502, 55505, 55446, 55447, 55012, 55427, 55441, 55430, 54921, 55423, 55404, 55320, 54917, 55384, 55263, 55346, 55337, 55323, 55196, 55367, 55316, 55265, 55309, 55310, 55305, 55298, 55010, 55257, 55284, 55280, 55278, 55268, 55273, 55248, 55242, 55252, 55245, 54952, 54494, 55110, 55217, 55219, 55210, 55008, 55205, 55189, 55195, 55199, 55184, 55136, 55171, 54810, 54731, 55104, 55154, 55155, 55157, 55165, 55024, 55101, 55083, 55056, 55035, 55074, 55051, 55046, 55002, 55015, 55019, 54985, 54920, 54968, 54965, 54867, 54948, 54964, 54882, 54829, 54750, 54942, 54941, 54894, 54628, 54905, 54897, 54631, 54890, 54878, 54824, 54755, 54723, 54800, 54859, 54856, 54862, 54846, 54840, 54753, 54837, 54827, 54830, 54821, 54678, 54819, 54765, 54356, 54735, 54798, 54786, 54784, 54789, 54788, 54696, 54689, 54657, 54692, 54688, 54625, 54608, 54684, 54679, 54643, 54633, 54661, 54663, 54610, 54656, 54512, 54108, 54483, 54635, 54460, 54622, 54586, 54500, 54452, 54543, 54546, 54331, 54580, 54572, 54498, 54502, 54344, 54487, 54485, 54310, 54451, 54471, 54480, 54436, 54319, 54434, 54375, 54257, 54413, 54324, 54294, 54343, 54359, 54261, 54352, 54349, 54406, 54378, 54380, 54391, 54384, 54381, 54379, 54382, 54386, 54402, 54401, 54385, 54113, 54316, 54337, 54243, 54122, 54302, 54309, 54097, 54295, 54274, 54280, 54293, 54282, 54290, 54287, 54285, 54267, 54233, 54259, 54164, 54241, 54248, 54229, 54219, 54221, 54226, 54227, 54150, 54209, 54215, 54203, 54207, 54212, 54199, 54183, 54169, 54145, 54087, 54081, 54088, 54050, 54049, 54013, 53976, 54018, 53995, 53853, 53909, 53878, 53844, 53954, 53957, 53953, 53923, 53916, 53875, 53862, 53867, 53863, 53683, 53819, 53830, 53827, 53781, 53797, 53791, 53792, 53743, 53775, 53727, 53707, 53698, 53700, 53699, 53599, 53623, 53609, 53596, 53578, 53445, 53552, 53545, 53401, 51379, 53453, 53436, 53455, 53461, 53458, 53456, 53457, 53460, 53262, 53346, 52736, 53426, 53423, 53214, 53374, 53393, 53388, 53384, 53383, 53363, 53218, 53341, 53270, 53320, 53301, 53137, 53269, 53271, 53281, 53273, 53272, 53219, 53231, 53243, 53209, 53207, 53152, 53068, 53142, 52822, 53168, 53164, 53174, 53169, 53144, 53092, 53097, 53106, 52869, 53096, 53065, 52990, 53067, 53051, 52707, 51373, 53057, 53056, 53055, 53063, 53023, 52933, 52978, 52903, 52896, 52883, 52885, 52748, 52861, 52791, 52852, 52828, 52842, 52829, 52589, 52682, 52719, 52723, 52699, 52693, 52627, 52674, 52648, 52649, 52656, 52659, 52662, 52657, 52574, 52613, 52606, 52533, 52535, 52552, 52551, 52505, 52523, 52544, 52543, 52474, 52448, 52493, 52434, 52420, 52455, 52453, 52463, 52405, 52397, 52278, 52210, 52189, 52382, 52231, 52371, 52296, 52367, 52328, 52196, 52345, 52344, 52347, 52227, 52262, 52256, 52213, 52152, 52190, 52173, 52106, 52124, 52139, 52063, 51688, 52035, 52033, 52043, 52047, 52007, 51989, 51997, 51995, 51991, 51912, 51966, 51974, 51959, 51777, 51781, 51956, 51950, 51952, 51899, 51918, 51847, 51891, 51885, 51615, 51839, 51834, 51833, 51408, 51733, 51718, 51646, 51701, 51703, 51667, 51697, 51692, 51663, 51643, 51405, 51632, 51636, 51650, 51623, 51567, 51561, 51514, 51364, 51543, 51544, 51461, 51489, 51492, 51494, 51479, 51480, 51484, 51458, 51452, 51443, 51383, 51399, 51419, 51418, 51230, 51332, 51126, 51323, 51306, 50693, 51292, 51288, 51276, 51165, 51258, 51254, 51228, 51149, 51156, 51216, 51052, 51241, 51237, 51238, 51243, 51195, 50847, 51144, 51140, 51132, 50931, 51061, 50975, 51009, 51018, 50849, 51005, 50881, 50384, 50966, 50960, 50957, 50961, 50935, 50912, 50907, 50782, 50872, 50840, 50825, 50835, 50839, 50826, 49994, 50832, 50821, 50270, 50807, 50808, 50816, 50814, 50711, 50619, 50758, 50749, 50747, 50748, 50646, 50637, 50617, 50662, 50515, 50684, 50503, 50651, 50647, 50633, 50674, 50614, 50592, 50527, 50558, 50564, 50533, 50540, 50518, 50362, 50495, 50490, 50491, 50456, 50009, 50398, 50079, 50356, 50363, 50393, 50346, 48543, 47900, 50308, 50299, 50166, 50246, 50183, 49610, 49817, 50196, 50192, 50201, 50195, 49240, 50006, 50038, 50035, 50005, 49999, 49864, 49970, 49952, 49918, 49866, 49870, 49164, 49869, 49909, 49912, 49851, 49713, 49756, 49765, 49653, 49739, 49668, 49665, 49692, 49689, 49688, 49654, 49603, 49528, 49442, 49015, 49373, 49597, 49486, 48276, 49566, 49559, 49490, 48697, 49473, 49474, 49460, 49448, 49437, 48789, 49320, 49391, 49420, 49349, 49400, 49297, 48842, 49355, 49356, 49362, 49363, 49016, 49326, 49288, 49268, 49179, 49201, 49250, 49252, 49184, 49208, 49211, 49073, 48850, 49099, 49163, 49018, 49205, 49176, 49183, 49094, 49231, 49228, 49224, 49223, 49171, 48950, 49022, 49138, 48677, 48963, 49014, 49017, 48908, 49033, 49050, 49058, 49051, 48986, 48982, 48941, 48785, 48783, 48940, 48615, 48936, 48931, 48928, 48756, 48788, 48141, 48779, 48671, 48828, 48830, 48836, 48839, 48831, 48802, 48191, 48716, 48648, 48645, 48692, 48629, 48682, 48063, 48598, 48630, 48661, 48660, 48337, 48609, 48626, 48583, 48478, 48569, 48282, 48406, 48556, 48539, 48514, 48535, 48532, 48391, 48187, 48502, 48490, 48486, 48474, 48469, 48439, 48432, 48455, 48453, 48458, 48456, 48461, 48460, 48416, 48390, 48362, 48383, 48304, 48275, 48350, 48357, 48352, 48356, 48353, 48221, 48342, 48286, 48329, 48321, 48312, 48232, 48229, 48057, 48224, 48211, 48203, 48078, 48154, 48145, 48251, 48234, 48239, 48236, 48235, 48240, 48241, 48242, 48246, 48149, 47946, 47957, 48136, 48018, 48130, 48129, 48103, 48121, 48124, 48120, 48082, 48012, 48079, 47920, 48074, 48032, 48030, 48027, 48000, 48014, 47985, 47912, 48010, 48009, 47960, 48039, 48040, 48045, 47996, 47936, 47847, 47937, 47887, 47926, 47918, 47788, 47880, 47906, 47910, 47889, 47867, 47866, 47853, 47768, 47850, 47835, 47832, 47797, 47794, 47805, 47790, 47765, 47793, 47764, 47760, 47750, 47714, 47713, 47710, 47715, 47716, 47677, 47630, 47608, 47629, 47590, 47536, 47599, 47516, 47472, 47445, 47487, 47520, 47524, 47521, 47525, 47526, 47528, 46337, 47303, 47354, 47466, 47465, 47469, 47450, 47464, 47003, 47425, 47071, 47436, 47426, 47428, 47427, 47432, 47433, 47299, 47382, 47390, 47384, 47086, 47252, 47266, 47347, 47340, 47341, 47348, 47345, 47344, 47328, 47167, 47277, 47066, 47278, 47158, 47195, 47185, 47263, 46921, 47150, 47184, 46915, 47216, 47217, 47225, 47218, 47223, 47228, 46842, 46847, 47189, 47057, 47165, 47035, 47082, 47042, 47141, 46707, 47063, 47079, 47060, 47053, 46883, 47039, 46683, 46939, 46993, 46994, 47000, 46997, 46996, 46962, 46940, 46634, 46468, 46938, 46920, 46800, 46901, 46767, 46869, 46750, 46868, 46884, 46885, 46890, 46896, 46894, 46895, 46755, 46422, 46831, 46835, 46826, 46827, 46792, 44793, 46795, 46770, 46761, 46779, 46780, 46749, 46481, 46684, 46690, 46699, 46695, 46628, 46616, 46564, 46652, 46643, 46651, 46642, 46641, 46650, 46649, 46629, 46597, 46589, 46529, 46031, 46544, 46384, 46520, 46526, 46508, 46466, 46449, 46506, 45616, 46210, 46158, 46453, 46433, 46460, 46335, 45313, 46211, 45477, 45476, 46036, 46038, 46037, 45664, 45489, 45442, 45928, 45876, 45898, 45899, 45902, 45903, 45900, 45641, 44953, 45676, 45775, 45766, 45767, 45774, 45454, 45615, 45488, 45357, 45408, 45536, 45558, 45205, 45360, 45074, 45078, 45302, 45271, 45192, 45226, 45227, 45157, 44997, 45101, 44795, 45063, 45076, 44821, 44769, 44892, 44891, 44797, 44755, 44809, 44771, 44768, 44603, 44409, 44555, 44028, 44604, 44306, 44485, 44543, 44463, 44451, 44195, 44206, 44120, 44382, 44387, 44249, 43969, 44014, 43898, 43891, 44096, 44083, 44018, 43975, 43767, 43765, 43977, 43955, 43902, 43956, 44007, 43292, 43944, 43974, 43983, 43958, 43922, 43965, 43959, 43574, 43756, 43886, 43786, 43751, 43787, 43628, 43915, 43913, 43908, 43909, 43770, 43773, 43768, 43271, 43865, 43867, 43866, 43730, 43860, 43857, 43784, 43853, 43778, 43764, 43757, 43721, 43754, 43718, 43595, 43739, 43840, 43803, 43795, 43796, 43726, 43729, 43724, 43523, 43715, 43674, 43624, 43614, 43807, 43811, 43683, 43521, 43647, 43665, 42339, 43816, 43817, 43847, 43632, 43821, 43823, 43822, 43825, 43615, 43627, 43589, 43616, 43607, 43598, 43585, 43587, 43465, 43565, 42327, 43562, 43561, 43544, 43582, 43475, 43557, 43554, 43559, 43549, 43547, 43545, 43005, 43391, 43519, 43532, 43525, 43534, 43526, 43513, 43504, 43459, 43454, 43502, 43361, 43494, 43408, 43488, 42068, 42750, 43499, 43500, 43505, 43388, 43431, 42866, 43447, 43386, 43101, 43239, 43342, 43352, 43437, 43413, 43430, 43370, 43298, 43393, 43406, 43395, 43407, 43396, 43355, 43191, 43365, 42437, 43358, 43353, 43316, 43322, 43345, 43325, 43240, 43273, 43337, 43339, 43329, 43338, 43336, 43335, 43268, 43293, 43296, 43288, 43057, 43290, 43289, 43286, 43277, 43229, 43281, 43309, 43310, 43208, 43274, 43103, 43262, 43237, 43241, 43245, 43236, 43238, 43139, 43252, 43253, 43247, 43249, 43254, 43218, 43214, 43243, 43205, 43203, 42916, 43193, 42961, 43137, 42923, 43162, 43121, 43169, 43180, 43170, 43173, 43174, 43181, 42957, 42854, 43159, 43058, 43148, 42968, 43145, 43028, 43136, 43116, 43129, 42928, 42793, 43100, 43064, 43017, 43090, 43092, 43085, 43006, 43077, 43068, 43056, 43055, 42971, 43030, 43029, 43027, 43025, 43022, 43050, 43049, 43034, 43041, 43044, 43035, 43037, 43023, 43018, 43004, 42996, 43001, 42998, 42993, 42732, 42881, 42859, 42956, 42964, 42930, 42952, 42896, 42951, 42945, 42946, 42899, 42831, 42897, 42887, 42903, 42901, 42908, 42893, 42825, 42608, 42870, 42797, 42852, 42853, 42838, 42813, 42665, 42846, 42835, 42798, 42803, 42829, 42809, 42769, 64175, 64172, 64168, 42783, 42726, 42767, 42802, 42778, 42751, 42792, 42790, 42782, 42819, 42773, 42771, 42423, 42731, 42757, 42724, 42700, 42762, 42729, 42735, 42694, 42685, 42574, 42572, 42723, 42719, 42686, 42713, 42616, 42712, 42701, 42703, 42702, 42690, 42666, 42658, 42613, 42664, 42367, 42652, 42727, 42612, 42554, 42606, 42624, 42623, 42602, 42591, 42598, 42592, 42573, 42550, 42534, 42122, 42631, 42629, 42585, 42549, 42580, 42575, 42671, 42411, 42553, 42499, 42558, 42564, 42559, 42566, 42544, 42507, 42533, 42529, 42478, 42511, 42509, 42508, 42441, 42498, 42673, 42491, 42381, 42046, 42333, 42419, 42454, 42388, 42244, 42524, 42527, 42523, 42521, 42676, 42677, 42428, 42420, 42392, 42399, 42384, 42418, 42321, 42330, 42408, 42400, 42393, 42317, 42394, 42195, 42375, 42030, 42292, 42205, 42335, 42337, 42328, 42332, 42233, 42209, 42287, 42267, 42310, 42302, 42306, 42301, 42312, 42316, 42246, 42280, 42210, 42201, 42243, 42206, 42247, 42241, 42202, 42078, 42288, 42125, 42027, 42214, 42126, 42194, 42217, 42220, 42218, 42193, 42175, 42172, 42095, 42127, 42088, 42093, 42164, 42155, 42163, 42165, 42157, 42063, 42128, 42102, 42112, 42115, 42099, 42141, 42133, 42145, 42142, 42134, 42098, 42092, 42097, 42096, 42064, 42039, 42061, 42017, 42050, 42026, 42028, 42021, 42015, 41992, 41991, 41984, 41987, 41990, 41942, 41997, 42006, 42009, 42002, 42000, 42008, 42001, 42148, 41976, 41889, 41974, 41899, 41965, 41924, 41964, 41892, 41758, 41951, 41947, 41948, 41913, 41912, 41941, 41906, 41928, 42149, 41922, 41926, 41919, 41923, 41905, 41903, 41894, 41896, 41891, 41824, 41849, 41887, 36595, 41879, 41885, 41835, 41809, 41848, 41851, 41844, 41874, 41864, 41870, 41861, 41816, 41838, 41750, 41626, 41811, 41803, 41789, 41795, 41828, 41759, 41712, 41765, 41286, 41733, 41778, 41777, 41622, 41692, 41697, 41737, 41740, 41748, 41738, 41636, 41645, 41714, 41715, 41705, 41701, 41702, 41829, 41674, 41676, 41661, 40343, 41675, 41643, 41689, 41668, 41667, 41647, 41577, 41654, 41653, 41641, 41582, 41642, 41615, 41627, 41618, 41576, 41565, 41578, 41617, 41558, 41616, 41607, 41612, 41545, 40833, 41601, 41597, 41593, 41606, 41574, 41258, 41556, 41546, 41557, 41555, 41547, 41283, 41523, 41543, 41533, 41531, 41312, 41179, 41514, 41518, 41254, 39619, 41203, 41255, 41191, 41165, 41178, 40770, 41390, 40899, 40011, 40960, 39329, 40785, 40704, 40806, 40805, 40803, 41393, 41392, 40674, 40675, 40628, 40645, 40511, 39998, 40614, 40474, 40548, 40487, 39789, 40121, 40278, 40359, 40364, 40365, 40369, 40360, 40174, 40080, 40052, 40136, 40197, 40195, 40093, 40092, 40053, 35785, 37390, 39853, 40013, 40014, 40015, 39815, 39828, 37392, 39573, 38843, 39455, 39537, 39710, 39685, 39304, 34715, 39406, 39461, 39468, 39462, 39460, 39464, 41407, 39393, 39058, 38712, 38995, 39292, 39229, 39181, 38463, 39139, 39031, 36746, 38670, 38787, 38515, 38827, 32912, 38786, 38595, 38699, 38644, 38419, 37099, 34961, 38465, 37505, 38526, 38534, 38002, 36028, 37651, 41413, 37482, 38149, 38143, 38154, 38157, 38029, 37974, 33133, 37739, 37944, 37945, 37943, 37824, 37778, 37571, 37463, 35374, 37736, 37669, 37763, 37758, 37755, 37766, 37759, 36479, 37598, 37664, 37667, 37410, 37340, 37596, 37595, 37479, 37389, 36288, 37079, 36359, 37300, 37041, 37236, 37180, 37170, 37189, 37182, 36772, 37097, 37053, 37081, 36840, 37013, 36773, 37027, 36787, 36333, 36892, 36853, 36805, 34119, 36806, 36168, 35856, 36809, 36182, 36790, 36747, 35348, 36760, 36480, 36759, 34355, 36729, 34655, 36743, 36493, 35787, 36422, 36335, 36384, 36436, 36096, 36253, 36169, 32676, 36240, 35421, 36194, 35667, 36209, 36212, 36210, 36224, 36219, 36213, 36227, 41426, 36114, 36081, 36115, 36069, 35529, 35516, 36040, 35681, 34593, 35978, 35894, 35614, 35759, 35792, 35821, 35376, 35588, 35732, 35758, 35757, 35804, 35803, 35799, 35798, 35682, 35706, 34383, 35402, 35377, 35655, 35266, 35619, 35485, 35513, 35517, 35546, 35514, 35530, 35500, 35433, 35405, 35480, 35487, 35333, 35482, 35170, 34815, 35467, 35331, 35168, 34908, 35451, 35435, 35455, 35438, 35447, 35449, 35442, 35440, 35453, 35439, 35436, 34817, 35305, 35137, 34909, 35166, 34765, 35098, 32482, 34811, 34606, 34279, 34529, 34668, 34699, 34635, 34783, 34486, 34822, 34820, 34825, 34823, 34826, 34831, 34829, 34827, 34753, 34738, 34697, 34736, 34717, 34718, 34698, 34636, 34004, 34414, 34491, 34621, 34398, 34252, 34542, 34338, 34488, 34489, 34280, 34240, 34415, 41442, 41440, 34147, 34053, 34292, 34369, 33986, 34192, 34037, 34151, 34132, 34057, 34101, 34085, 34025, 34058, 34052, 34003, 34038, 33784, 33530, 33923, 33871, 32705, 33991, 33989, 33959, 32820, 33940, 33958, 33926, 33787, 33475, 33818, 33644, 33788, 33661, 33727, 33610, 33609, 33689, 33662, 33692, 33759, 33754, 33757, 33748, 33744, 33745, 33746, 33747, 33658, 33570, 33659, 33638, 33594, 33645, 33639, 33480, 33326, 33371, 33178, 33341, 33557, 33531, 33477, 33422, 33373, 33375, 33354, 33295, 33342, 33358, 32645, 33243, 33227, 33197, 33288, 33120, 33228, 33165, 33023, 33212, 33075, 33194, 33296, 33297, 33313, 33301, 33298, 33308, 33310, 33025, 33179, 32764, 32946, 32717, 33093, 33105, 33094, 33097, 33092, 32998, 33021, 32928, 32996, 32980, 32977, 32960, 32650, 32931, 32929, 32870, 32924, 41454, 41457, 32747, 32874, 32763, 32821, 32793, 32895, 32875, 32876, 32889, 32877, 32880, 32891, 32878, 32890, 32583, 32338, 32767, 32746, 32731, 32734, 32646, 32560, 32604, 32651, 32631, 32632, 32629, 32512, 32545, 32563, 32564, 32582, 32478, 32334, 32542, 32496, 32480, 32541, 32377, 32391, 32481, 32450, 32479, 32428, 32465, 32449, 32290, 32448, 32442, 32414, 32393, 32409, 32396, 32272, 32356, 32371, 32372, 32353, 32333, 32336, 32319, 32273, 31504, 31376, 31329, 31317, 31264, 31256, 31251, 31148, 31189, 31192, 31205, 30924, 31067, 31034, 31021, 31020, 30995, 30888, 30957, 30292, 30810, 41363, 30798, 41376, 30794, 30747, 30669, 30642, 30590, 30358, 30492, 30264, 30301, 30459, 30460, 30359, 30416, 30391, 30376, 30363, 30368, 30369, 30318, 30317, 30062, 30310, 30326, 30302, 30295, 30262, 30255, 30241, 30202, 30227, 30225, 30183, 30148, 30157, 30106, 30124, 30125, 30105, 30091, 30061, 30057, 30027, 29981, 29977, 29978, 29920, 29916, 29884, 29887, 29876, 29847, 29817, 29828, 29796, 29741, 29236, 29714, 29627, 29678, 29662, 29397, 29172, 29613, 29612, 29611, 29523, 29396, 29350, 29370, 29264, 29360, 29303, 29333, 29308, 29288, 29156, 29243, 29242, 29181, 29177, 29168, 29148, 29136, 29098, 29014, 29101, 29012, 29061, 29058, 29049, 28853, 28990, 28998, 28927, 28947, 28948, 28949, 28888, 28917, 28789, 28874, 28875, 28797, 28829, 28798, 28761, 28765, 28727, 28757, 28714, 28704, 28565, 28537, 28481, 28457, 28422, 28411, 28452, 28406, 28393, 28126, 28062, 27489, 27341, 27526, 27247, 27244, 27158, 27118, 27537, 27059, 26874, 26863, 26771, 26773, 26811, 26743, 26402, 26608, 26216, 26551, 26449, 26438, 26324, 26380, 26373, 26321, 26207, 26251, 26217, 26236, 26166, 26097, 26148, 26076, 25963, 25997, 26001, 25839, 25927, 25819, 25904, 25893, 25765, 25729, 25665, 25642, 25744, 25717, 25674, 25692, 25632, 25383, 25534, 25391, 25449, 25302, 25297, 25266, 25267, 25268, 24909, 25228, 25240, 25229, 25243, 25230, 25238, 25213, 25221, 25203, 25042, 25198, 25214, 25088, 25210, 25209, 25208, 25089, 25187, 25188, 24878, 25155, 25141, 25066, 24868, 25186, 25090, 25161, 25156, 25157, 25171, 25176, 25165, 25162, 25172, 25164, 25050, 25145, 24644, 25137, 25131, 25125, 25134, 25127, 25130, 25126, 25121, 25092, 25119, 25116, 25098, 25100, 25099, 25106, 25111, 25067, 25031, 25049, 25070, 25082, 25085, 25081, 25079, 25083, 25087, 25080, 24798, 24981, 25032, 25053, 25048, 25051, 24877, 25013, 24874, 24925, 24452, 23424, 25018, 25019, 25017, 25021, 25016, 24987, 24949, 24561, 25000, 24995, 24994, 24989, 24982, 24921, 24858, 24980, 24842, 24804, 24963, 24971, 24964, 24933, 24932, 24959, 24960, 24941, 24034, 24931, 24930, 24617, 24917, 24919, 24803, 24831, 24525, 27596, 24882, 24900, 24884, 24891, 24894, 24885, 24893, 24908, 24902, 24887, 24892, 24886, 24871, 24747, 24847, 24756, 24846, 24794, 24344, 27599, 24805, 24799, 24738, 24757, 24797, 24818, 24823, 24822, 24810, 24826, 24807, 24819, 24808, 24809, 24790, 24782, 24748, 24646, 24696, 24758, 24780, 24779, 24769, 24767, 24766, 24751, 24581, 24675, 24670, 24655, 24694, 24510, 24707, 24721, 24724, 24733, 24723, 24725, 24722, 24731, 24573, 24576, 24690, 24492, 24633, 24689, 24194, 24645, 24682, 24678, 24406, 24579, 24666, 24629, 24530, 24470, 24639, 24534, 24563, 24618, 24630, 24623, 24559, 24519, 24540, 24583, 24200, 24607, 24590, 24609, 24598, 24592, 24593, 24608, 24591, 24611, 24575, 24535, 23964, 24517, 24547, 24555, 24539, 24312, 24554, 24339, 24508, 24397, 24538, 24528, 24516, 24415, 24514, 24531, 24521, 24524, 24420, 24522, 24511, 24475, 24491, 24500, 23846, 24499, 24488, 24494, 24507, 24030, 24503, 24486, 24431, 24416, 24483, 24480, 24484, 24481, 24473, 24469, 24307, 24478, 24472, 24460, 24466, 24456, 24459, 24446, 24392, 24433, 24330, 24225, 24323, 24321, 24310, 24413, 24414, 24407, 24301, 24404, 24226, 24295, 24384, 24381, 24168, 24340, 24345, 24253, 24106, 24342, 23803, 27606, 24319, 23974, 24316, 24356, 24378, 24357, 24358, 24371, 24359, 24372, 24361, 24362, 24363, 24332, 24328, 24329, 24308, 24320, 24275, 24039, 24277, 24271, 24294, 24290, 24097, 24264, 24212, 24218, 24160, 24265, 24254, 24251, 24215, 24211, 27610, 24223, 24220, 24219, 24045, 24147, 24136, 24195, 24227, 24228, 24234, 24229, 24231, 24245, 24230, 24235, 24237, 24236, 24205, 24156, 23971, 24199, 24088, 24166, 24091, 24163, 24096, 24158, 24171, 24172, 24173, 24174, 24182, 24184, 24185, 24190, 24183, 24148, 24004, 24107, 24110, 23906, 24141, 23734, 24135, 23398, 24138, 27614, 24047, 24070, 24025, 24061, 24122, 24112, 24113, 24114, 24129, 24124, 24117, 24118, 24095, 24089, 23660, 24074, 24022, 23960, 24038, 23659, 23673, 23937, 23979, 23076, 24046, 27618, 23801, 24037, 23729, 23863, 23550, 23966, 23947, 24011, 24016, 24013, 24010, 23944, 23954, 23593, 24000, 23980, 27621, 27619, 27622, 23989, 23995, 23992, 23986, 23993, 23991, 23754, 23975, 23959, 23854, 23722, 23790, 23952, 23949, 23946, 23929, 23943, 23883, 23805, 23924, 23900, 27624, 23916, 23773, 23476, 23880, 23839, 23898, 23893, 23885, 23882, 23877, 23760, 23879, 23583, 23840, 23850, 23829, 23858, 23859, 23706, 23625, 23795, 23852, 23832, 23842, 23761, 23769, 23255, 23786, 23320, 23486, 23802, 27628, 23828, 23812, 23822, 23813, 23824, 23637, 23725, 23759, 23727, 23781, 23670, 23600, 23712, 23758, 23636, 23753, 23638, 23735, 23307, 23447, 23614, 23740, 23741, 23739, 23746, 23747, 23738, 23718, 23672, 23708, 23627, 23676, 23541, 23389, 23699, 23689, 23703, 23691, 23690, 23701, 23639, 23641, 23310, 23661, 23589, 27635, 27633, 23634, 23635, 23374, 23642, 23644, 23655, 23643, 23653, 23546, 23612, 23294, 23607, 23595, 23555, 23577, 23573, 23547, 23488, 23571, 27638, 23561, 23292, 23551, 23544, 23548, 23545, 23542, 23470, 23483, 23506, 23504, 23495, 23468, 27641, 23531, 23521, 23530, 23523, 23539, 23522, 23412, 23059, 23101, 23451, 23313, 23414, 23422, 23420, 23437, 23410, 23415, 23406, 23381, 23403, 23211, 23293, 23378, 23329, 23359, 23312, 23325, 23311, 23309, 23330, 23296, 23333, 23331, 23323, 23239, 23348, 23334, 23346, 23345, 23352, 23337, 23336, 23335, 23349, 23351, 23305, 23298, 23304, 23242, 23306, 23289, 23285, 23244, 23210, 23214, 23141, 23188, 23190, 23253, 23256, 23088, 23254, 23249, 23245, 23202, 23139, 23241, 23114, 23102, 23115, 23230, 23229, 23222, 23224, 23223, 23197, 23091, 23169, 23165, 23185, 23183, 23176, 23177, 23175, 23080, 23134, 23104, 23124, 23110, 23099, 23050, 23095, 23069, 23100, 23096, 23085, 23158, 23145, 23147, 23160, 23155, 23146, 23066, 23070, 23067, 23048, 23046, 23047, 23045, 23041, 23036, 23006, 23038, 22974, 22600, 23027, 22978, 22942, 23031, 22979, 22958, 22960, 22976, 23021, 23020, 23016, 23026, 23019, 22763, 23014, 23018, 23008, 22867, 22973, 22965, 22930, 22925, 23002, 23003, 22733, 22940, 22794, 22875, 23001, 22870, 22977, 22983, 22985, 22988, 22998, 22984, 22989, 22961, 22901, 22954, 22970, 22967, 22968, 22959, 22946, 22957, 22945, 22944, 22894, 22943, 22955, 22911, 22691, 22952, 22753, 22051, 22938, 22810, 22923, 22001, 22929, 22933, 22927, 22928, 22907, 22920, 22903, 22913, 22905, 22795, 22897, 22912, 22904, 22899, 22874, 22898, 22866, 22872, 22841, 22836, 22846, 22864, 22815, 22847, 22851, 22850, 22837, 22755, 22806, 20973, 22749, 27662, 22761, 22822, 22459, 22802, 21724, 22816, 22712, 22809, 22737, 22655, 22804, 22800, 22797, 22726, 22502, 22762, 22740, 22767, 22766, 22793, 22711, 22738, 27663, 22774, 22781, 22784, 22782, 22783, 22777, 22785, 22776, 22775, 22705, 22747, 22750, 22745, 22735, 22744, 22571, 22640, 22706, 22475, 22704, 22487, 22616, 22658, 22701, 22535, 22709, 22695, 22702, 22388, 22652, 22474, 22694, 22602, 22689, 22377, 22639, 22604, 22569, 22416, 22555, 22609, 22069, 22641, 22570, 22681, 22682, 22669, 22685, 22679, 22678, 22668, 22670, 22667, 22643, 22645, 22638, 22557, 22635, 22626, 22628, 22629, 22627, 22503, 22494, 22606, 22563, 22545, 22542, 22055, 22579, 22580, 22587, 22590, 22585, 22538, 22554, 22492, 22483, 22537, 22539, 22481, 22403, 22500, 22471, 22497, 22366, 22332, 22472, 22423, 22362, 22455, 22268, 22431, 22461, 22436, 22066, 22421, 22328, 22422, 22445, 22437, 22438, 22439, 22382, 22419, 22413, 22376, 22414, 21713, 22405, 22401, 22308, 22385, 22340, 22378, 22322, 22367, 22291, 22348, 22302, 22358, 22229, 21721, 22307, 22124, 22189, 22320, 22284, 21995, 21807, 22316, 22326, 22240, 20889, 22321, 22262, 22306, 22315, 22270, 22305, 20974, 22230, 20722, 22278, 21872, 22266, 22232, 22207, 22188, 21896, 21323, 22170, 22246, 22245, 22247, 22244, 22256, 22228, 22225, 22219, 21493, 22200, 22213, 22206, 22209, 22208, 22201, 22190, 22187, 22182, 22143, 22175, 22179, 22141, 22035, 21854, 22059, 22167, 22162, 22164, 22133, 22058, 22127, 22088, 20971, 21949, 22084, 22009, 22094, 22095, 22097, 22096, 22101, 22104, 21972, 21446, 21994, 21971, 22050, 27682, 21855, 22031, 22023, 22030, 22047, 22046, 22048, 21886, 22017, 22011, 22002, 21954, 21990, 21933, 21941, 21985, 21984, 21530, 21965, 21447, 21905, 21961, 21895, 21885, 21948, 21942, 21845, 21936, 21938, 21874, 21934, 21737, 21890, 27683, 21901, 21868, 21909, 21910, 21916, 21927, 21911, 21912, 21917, 21865, 21897, 21071, 21847, 21846, 21851, 21881, 21849, 21829, 21880, 21738, 21878, 21876, 21808, 21852, 21784, 21802, 21838, 21840, 21828, 21839, 21705, 21835, 21774, 21833, 21813, 21801, 21770, 21775, 21665, 21252, 21184, 27685, 21791, 21800, 21332, 21797, 21232, 21782, 21785, 21783, 21780, 21773, 21771, 21718, 21742, 21694, 21715, 21688, 21657, 21717, 21727, 21751, 21752, 21753, 21765, 21761, 21763, 21754, 21719, 21697, 21512, 21463, 21709, 21710, 21696, 21704, 21689, 21693, 21675, 21681, 21581, 21676, 21616, 21478, 21598, 21648, 21640, 21602, 21596, 20704, 20820, 21090, 21607, 21610, 21535, 21398, 21625, 21626, 21636, 21627, 21629, 21630, 21628, 21590, 21477, 21587, 21588, 21501, 21585, 21509, 21557, 21552, 21528, 21546, 21346, 21502, 21333, 21496, 21328, 21519, 21524, 21520, 21526, 21455, 21427, 21379, 21468, 21401, 21414, 21458, 21448, 21286, 21435, 27697, 21430, 21425, 21417, 20702, 21406, 21274, 21338, 21399, 21351, 21389, 21372, 21383, 21306, 21279, 21347, 21272, 21301, 21335, 27702, 27701, 27703, 21368, 21363, 21357, 21354, 21353, 21364, 21358, 21356, 21366, 21340, 21014, 21304, 21319, 21262, 21212, 21318, 21309, 21268, 21305, 21299, 21283, 21300, 21289, 21290, 21288, 21207, 21281, 21225, 21201, 21190, 21265, 21259, 21223, 21248, 21257, 21250, 21253, 21245, 21174, 21239, 21236, 21240, 21230, 21237, 21228, 21120, 21235, 21161, 21221, 21131, 21222, 21216, 21215, 21182, 21204, 20970, 21148, 21198, 21194, 21195, 21169, 20710, 21179, 21172, 21168, 21150, 21160, 21158, 21093, 21074, 21147, 21055, 21126, 21149, 21121, 21132, 21130, 21076, 21011, 21078, 21099, 21100, 21109, 21097, 21096, 21101, 21107, 21106, 21098, 21111, 21079, 21027, 21077, 20857, 21056, 21057, 20957, 20736, 21054, 21002, 21026, 21030, 21021, 21015, 20903, 21022, 21006, 20911, 20890, 20981, 20978, 20965, 20713, 20987, 20989, 20988, 20993, 20995, 20775, 20856, 20952, 20925, 20938, 20923, 20935, 20924, 20926, 20796, 20899, 20900, 20836, 20853, 20729, 20728, 20893, 20865, 20884, 20864, 20828, 20863, 20862, 20794, 20654, 20883, 20882, 20868, 20869, 20881, 20879, 20870, 20840, 20837, 20691, 20848, 20795, 20843, 20838, 20801, 20723, 20825, 20784, 20817, 20731, 20816, 20807, 20791, 20814, 20803, 20677, 20787, 20805, 20797, 20778, 20659, 20774, 20759, 20782, 20772, 20766, 20718, 20732, 20719, 20756, 20741, 20750, 20754, 20742, 20743, 20708, 20720, 20707, 20697, 20711, 20689, 20698, 20701, 20648, 20690, 20686, 20643, 20670, 20652, 20651, 20660, 20647, 20633, 20562, 20628, 20613, 20625, 20586, 20622, 20617, 20618, 20566, 20584, 20616, 20511, 20611, 20602, 20609, 20603, 20608, 20601, 20556, 20570, 20261, 20249, 20597, 20593, 20280, 20590, 20548, 20539, 20225, 20557, 20263, 20500, 20564, 20565, 20568, 27721, 19759, 20580, 20571, 20572, 20574, 20573, 20576, 20582, 20495, 20549, 20550, 20546, 20540, 20541, 20532, 27723, 27722, 20510, 20503, 20450, 20521, 20515, 20522, 20523, 20524, 20024, 20399, 20422, 20418, 20289, 20488, 20405, 20487, 20464, 20410, 20419, 20475, 20476, 20455, 20454, 20453, 20034, 20451, 20347, 20329, 19888, 20431, 20421, 20346, 20368, 20440, 20441, 20439, 20417, 20315, 20401, 20414, 20248, 20185, 20404, 20398, 20359, 20383, 20173, 20391, 20390, 20385, 20167, 20340, 20367, 20358, 19230, 20341, 20338, 20131, 20284, 20286, 20324, 20322, 20312, 20294, 20293, 20308, 20302, 20304, 20300, 20288, 20252, 20285, 19841, 20209, 20277, 20268, 20275, 19289, 20267, 20259, 20262, 20260, 20196, 20108, 20161, 20246, 20247, 20239, 20244, 20226, 20227, 20231, 20212, 20000, 19877, 20204, 20200, 20181, 20105, 20114, 20132, 20176, 20171, 20169, 20155, 20081, 20067, 20064, 20065, 20149, 20141, 20142, 20146, 20126, 18960, 20116, 20115, 20113, 19894, 20102, 20016, 20100, 20098, 20096, 20093, 20092, 20089, 20029, 20087, 20083, 20080, 20075, 20070, 20079, 27727, 19899, 19900, 19898, 20044, 20043, 20045, 20060, 19997, 19755, 20007, 20005, 19980, 19949, 19960, 19824, 19977, 19974, 19972, 19988, 19989, 19961, 19963, 19885, 19955, 19957, 19953, 19856, 19954, 19871, 18974, 19897, 19950, 19947, 19812, 19893, 19837, 19630, 19933, 19921, 19926, 19922, 19930, 19928, 19892, 19860, 19868, 19883, 19732, 19739, 19869, 19861, 19863, 19864, 19849, 19815, 19842, 19845, 19843, 19840, 19734, 19807, 19836, 19724, 19823, 19728, 19754, 19613, 19729, 19714, 19811, 19584, 19726, 19443, 19750, 19670, 19449, 19741, 27731, 27730, 19779, 19774, 19798, 19775, 19781, 19780, 19793, 19776, 19778, 19777, 19792, 19751, 19752, 19692, 19633, 19745, 19742, 19643, 19736, 19725, 19689, 19719, 19710, 19708, 19712, 19707, 19693, 19404, 19438, 19165, 19685, 19681, 19581, 19421, 19608, 19669, 19431, 19662, 19660, 19659, 19591, 19649, 19648, 19651, 19654, 19655, 19650, 19639, 19642, 19522, 19644, 19246, 19635, 19629, 19536, 19557, 19618, 19559, 19516, 19501, 19597, 19498, 19589, 19592, 19068, 19539, 19580, 19444, 19566, 19227, 19430, 19546, 19377, 19492, 19538, 19423, 19532, 19527, 19204, 19528, 19487, 19346, 19488, 19486, 19460, 19452, 19442, 19235, 19437, 19439, 19416, 19435, 19409, 19426, 27733, 19461, 19479, 19463, 19475, 19464, 19467, 19462, 19156, 19328, 19402, 19389, 19399, 19391, 19385, 19379, 19373, 19283, 19374, 19332, 19231, 19233, 19118, 19322, 19316, 19024, 19304, 19300, 19168, 19301, 19297, 19137, 19208, 19278, 19221, 27734, 19148, 19224, 19240, 19211, 19149, 19247, 19248, 19252, 19251, 19270, 19250, 19249, 19178, 19205, 19159, 19180, 19115, 19172, 19105, 19191, 19196, 19186, 19187, 19064, 19139, 18914, 19124, 19132, 19107, 18978, 19108, 27742, 19052, 18935, 19071, 19038, 19062, 19016, 19036, 19014, 19060, 19079, 19098, 19092, 19082, 19086, 19083, 19081, 19080, 19087, 19094, 18942, 19054, 18863, 19051, 19018, 19023, 19000, 18936, 19017, 19007, 19005, 19006, 19012, 18999, 18990, 18909, 18989, 18979, 18966, 18969, 18958, 18952, 18955, 18945, 18937, 18938, 18897, 18892, 18920, 18934, 18894, 18921, 18910, 18915, 18906, 18893, 18871, 18880, 18872, 18869, 18870, 18864, 18861, 18847, 18854, 18851, 18782, 18719, 18815, 18827, 18828, 18829, 18831, 18830, 18833, 18330, 18824, 18722, 18795, 18820, 18821, 18786, 18800, 18806, 18809, 18524, 18802, 18799, 18790, 18408, 18780, 18788, 18792, 18796, 18781, 18793, 18791, 18785, 18721, 18519, 18774, 18559, 18769, 18504, 18761, 18542, 18759, 18657, 18754, 18739, 18738, 18736, 18742, 18743, 18750, 18744, 18746, 18611, 18729, 18727, 18678, 18490, 18502, 18716, 18428, 18711, 18687, 18686, 18691, 18692, 18695, 18693, 18697, 18703, 18696, 18699, 18694, 18708, 18684, 18680, 18662, 18666, 18669, 18671, 18665, 18555, 18556, 18551, 18549, 18550, 18528, 18309, 18540, 18541, 18497, 18560, 18561, 18566, 18562, 18570, 18567, 18510, 18521, 18500, 18467, 18517, 18429, 18508, 18507, 18488, 18487, 18499, 18441, 18456, 18586, 18574, 18585, 18573, 18572, 18483, 18471, 18486, 18450, 18477, 18472, 18469, 18466, 27748, 18447, 18412, 18443, 18436, 18422, 18405, 18358, 18440, 18425, 18383, 18418, 18423, 18424, 18420, 18385, 18414, 18413, 18382, 18400, 18396, 18397, 18349, 18387, 18384, 18354, 18341, 18370, 18369, 18602, 18591, 18589, 18588, 18600, 18595, 18344, 18313, 18356, 18355, 18292, 18318, 18302, 18322, 18328, 18325, 18307, 18606, 18603, 18604, 18290, 18296, 18613, 18618, 18619, 18615, 18282, 18276, 18272, 18277, 18274, 17819, 18275, 18183, 18270, 18258, 18237, 18254, 18225, 18628, 18624, 18629, 18626, 18627, 18633, 18631, 18265, 18233, 18264, 18241, 18260, 18227, 18255, 18257, 18256, 18250, 17793, 18245, 18244, 18242, 18212, 16347, 18221, 17138, 18220, 18217, 18209, 17716, 17202, 18201, 18206, 18198, 18177, 18638, 18640, 18639, 18642, 18654, 18641, 17719, 18178, 17440, 17710, 18185, 17361, 17833, 17761, 17608, 17827, 17834, 17806, 17522, 17822, 17826, 17781, 17807, 17770, 17322, 17788, 17796, 17794, 17728, 17759, 17779, 16569, 17784, 17758, 17723, 17724, 17768, 17707, 17754, 17694, 17729, 17722, 17734, 17735, 17750, 17746, 17526, 17705, 17708, 17704, 17701, 17336, 17684, 17195, 17689, 17638, 17693, 17688, 17685, 17677, 17598, 17279, 17682, 17683, 17680, 17649, 17515, 17675, 17664, 17667, 17669, 17665, 17663, 17612, 17642, 17561, 17621, 17620, 17566, 17480, 17613, 17618, 17623, 17635, 17626, 17624, 17636, 17591, 17531, 17606, 17543, 17594, 17555, 17546, 17535, 17586, 17589, 17549, 17542, 16738, 17567, 17570, 17569, 17573, 17583, 17571, 17574, 17582, 17579, 17572, 17550, 17551, 17511, 16981, 17541, 17508, 17539, 17485, 17533, 17441, 17528, 17525, 17517, 17521, 17516, 17408, 17411, 17514, 17520, 17434, 17381, 17513, 17492, 17509, 17477, 17498, 17394, 17502, 17495, 17494, 17479, 17453, 17447, 17387, 17462, 17464, 17470, 17469, 17463, 17475, 17452, 17134, 17432, 17448, 17442, 17030, 17433, 17309, 17401, 17419, 17405, 17292, 17379, 17853, 17396, 17370, 17393, 17368, 17385, 17290, 17380, 17317, 17377, 17362, 17360, 17359, 16656, 17296, 17337, 17297, 17341, 17356, 17344, 17342, 17353, 17357, 17321, 17312, 17305, 17304, 17217, 17276, 17250, 17300, 17164, 17266, 17192, 17275, 17188, 17277, 17281, 17286, 17282, 17272, 17264, 17251, 17259, 17249, 17193, 17242, 17247, 17143, 17206, 17231, 17227, 17228, 17232, 17229, 17237, 16744, 17142, 17112, 17144, 16984, 17174, 16275, 16322, 16757, 16872, 17150, 17151, 17157, 17160, 17152, 17156, 17075, 17083, 17025, 17072, 17076, 17066, 17093, 17088, 17038, 17039, 16951, 17037, 17082, 17074, 17027, 16562, 17002, 17069, 17065, 17018, 16326, 17063, 17010, 17033, 17047, 17048, 17056, 17052, 17049, 16976, 17011, 17026, 16975, 16853, 16906, 17012, 17008, 16982, 16985, 17001, 16998, 16973, 16844, 16971, 16915, 16986, 16987, 16991, 16995, 16993, 16945, 16876, 16935, 16921, 16959, 16956, 16965, 16919, 16912, 16903, 17866, 17865, 16887, 16867, 16913, 16901, 16925, 16930, 16926, 16923, 16924, 16896, 16879, 16766, 16904, 16841, 16900, 16894, 16761, 16521, 16875, 16869, 16892, 16878, 16870, 16886, 16871, 16868, 16810, 16865, 16848, 16834, 16862, 16832, 16861, 16728, 16840, 16293, 16801, 16770, 16754, 16822, 16828, 16819, 16790, 16722, 16793, 16786, 16792, 16759, 16725, 16764, 16709, 16743, 16755, 16390, 16733, 16701, 16646, 16587, 16730, 16727, 16732, 16729, 16671, 16717, 16692, 16714, 16711, 16696, 16703, 16670, 16668, 16694, 16634, 16689, 16633, 16658, 16686, 16683, 16673, 17883, 17880, 17887, 16669, 16652, 16419, 16649, 16653, 16647, 16557, 16632, 16640, 16626, 16623, 16599, 16586, 16625, 16509, 16520, 16548, 16573, 16580, 16526, 17895, 17892, 17891, 17889, 16611, 16612, 16617, 16525, 16564, 16514, 16501, 16565, 16491, 16560, 16529, 16546, 16517, 16543, 16428, 16536, 16532, 16427, 16443, 16498, 16417, 16512, 16460, 16486, 16499, 16482, 16500, 16495, 16487, 17904, 17900, 17898, 16298, 16454, 16447, 16469, 16407, 16344, 16281, 16473, 16472, 16471, 16416, 16399, 16362, 16424, 16434, 16437, 16441, 16402, 16396, 16387, 16384, 16284, 16334, 16343, 16363, 16353, 16286, 16382, 16375, 16381, 16378, 16377, 16370, 16380, 16340, 16332, 16327, 16297, 16315, 16283, 16273, 16270, 16274, 16272, 16261, 16220, 17913, 15838, 16241, 16244, 16248, 16242, 16245, 16252, 16247, 16243, 16256, 16249, 16144, 16223, 16214, 16165, 16074, 15770, 16167, 16026, 15938, 16172, 16156, 16173, 16181, 16176, 15995, 16178, 16166, 16157, 16152, 15793, 15956, 16153, 15342, 15911, 16110, 16138, 14831, 16079, 16119, 16118, 16103, 17918, 16092, 16133, 16125, 16126, 16128, 15945, 16098, 16072, 15814, 16030, 16069, 16091, 16084, 15953, 16071, 16063, 15925, 15991, 16060, 16056, 16033, 16027, 16028, 16038, 16048, 16044, 16039, 16023, 15957, 16004, 16013, 16012, 16011, 15984, 15931, 15989, 15982, 15981, 15946, 15894, 15950, 15947, 15904, 15977, 15963, 15974, 15965, 15964, 15976, 15967, 15851, 15944, 15926, 15593, 15918, 15839, 15821, 15772, 15824, 15891, 15809, 15678, 15799, 15815, 15850, 15875, 15878, 15869, 15870, 15858, 15859, 15857, 15876, 15846, 15796, 15827, 15822, 15823, 15818, 15776, 15746, 15803, 15767, 15743, 15798, 15585, 15460, 15787, 15287, 15779, 15157, 15783, 15695, 15622, 15734, 15697, 15742, 15627, 15731, 15733, 15693, 15692, 15685, 15719, 15720, 15709, 15713, 17929, 15707, 15704, 15698, 15684, 15696, 15689, 15536, 15690, 15535, 15520, 15648, 15680, 15609, 15677, 15649, 15646, 15640, 15638, 15624, 15633, 15657, 15655, 15661, 15658, 15664, 15663, 15662, 15656, 15417, 15630, 15623, 15577, 15415, 15576, 15590, 15608, 15521, 15601, 15602, 15539, 15596, 15522, 15391, 15591, 15515, 15175, 15586, 15587, 15549, 15541, 15506, 15551, 14635, 15537, 15546, 15547, 15500, 15553, 15555, 15568, 15556, 15564, 15561, 15562, 15466, 15451, 15453, 15445, 15531, 15523, 15530, 15439, 15436, 15440, 15498, 15350, 15435, 15469, 15454, 14668, 15464, 15463, 15480, 15481, 15489, 15478, 15488, 15473, 15482, 15492, 15476, 15474, 15448, 15427, 15303, 17943, 17942, 17941, 15238, 15421, 15413, 15353, 15416, 15396, 14654, 15381, 15392, 14711, 15306, 15358, 14605, 15229, 15307, 15347, 15070, 15299, 15371, 15367, 15365, 15364, 15366, 15373, 15372, 15258, 15344, 15298, 15290, 15293, 15295, 15286, 15281, 15282, 15222, 15239, 15256, 15252, 15250, 15255, 15248, 15216, 15231, 14384, 15170, 15132, 14858, 15208, 14790, 15176, 15150, 15180, 15177, 15173, 15105, 14979, 15200, 15195, 15106, 15123, 15131, 15124, 15034, 14190, 15092, 15127, 15122, 15117, 15074, 14936, 15113, 14993, 14670, 14783, 15107, 17949, 17948, 15091, 15080, 14947, 15085, 15087, 15086, 15088, 15090, 15094, 14672, 15045, 14533, 15026, 14981, 15039, 15042, 14991, 15018, 15020, 15014, 14738, 14647, 14987, 14992, 14990, 14923, 14997, 15001, 15008, 15002, 15000, 14998, 15010, 14999, 15003, 14357, 14824, 14967, 14963, 14965, 14958, 14957, 14946, 14867, 14945, 13692, 14935, 17951, 14930, 14848, 14813, 14863, 14749, 14915, 14871, 14911, 14864, 14869, 14870, 14866, 14849, 14751, 14903, 14899, 14902, 14894, 14859, 14850, 14855, 14827, 14847, 14742, 14837, 14822, 14776, 14836, 14830, 14832, 14823, 14236, 14809, 14601, 14424, 14816, 14810, 14750, 14753, 17954, 17953, 14737, 14798, 14674, 14781, 14773, 14779, 14774, 14705, 14739, 14428, 14741, 14760, 14724, 14755, 14747, 14746, 14743, 14714, 14733, 14331, 14706, 14716, 14704, 14678, 14675, 14545, 14656, 14667, 14584, 17959, 14694, 14685, 14686, 14696, 14684, 14697, 14701, 14617, 14633, 14586, 14400, 14653, 14593, 14641, 14629, 14643, 14607, 14637, 14634, 14640, 14627, 14615, 14610, 14611, 14380, 14589, 14490, 14588, 14481, 14590, 14585, 14544, 17960, 14582, 14542, 14421, 14538, 14434, 14473, 14536, 14431, 14530, 14549, 14550, 14551, 14566, 14557, 14554, 14563, 14562, 14555, 14552, 14558, 14553, 14567, 14556, 14559, 14579, 14524, 14523, 14522, 14423, 14520, 14515, 14487, 14497, 14514, 14495, 14492, 14464, 14498, 14499, 14501, 14500, 14507, 14433, 14479, 14477, 14476, 14472, 14429, 14437, 14418, 14438, 14397, 14408, 14388, 14383, 14441, 14442, 14448, 14449, 14443, 14459, 14372, 14250, 14319, 14321, 14239, 14382, 14179, 14238, 14235, 14280, 14365, 14221, 14349, 14354, 14356, 14353, 14005, 14339, 14259, 14269, 14324, 14284, 14240, 14214, 14295, 14296, 14313, 14287, 14285, 14288, 14307, 14163, 14220, 14273, 14194, 14228, 14246, 14181, 14244, 13818, 13722, 13928, 14203, 14201, 14197, 14227, 14226, 14065, 14079, 14218, 14207, 14202, 14180, 14001, 14178, 14112, 14117, 14173, 14132, 14023, 14148, 14165, 14155, 14156, 14086, 14008, 14151, 14075, 14126, 13969, 14140, 14085, 14137, 14134, 14051, 14121, 14115, 14030, 14028, 14064, 14084, 14082, 14083, 14021, 14074, 14072, 14077, 13798, 14069, 14102, 14107, 13817, 14047, 13842, 14025, 14014, 14012, 14020, 13998, 14004, 13970, 17979, 17978, 17981, 13950, 13897, 13793, 13965, 13953, 13706, 13877, 13761, 13931, 13876, 13971, 13986, 13987, 13972, 13973, 13974, 13845, 13924, 13904, 13902, 13917, 13898, 13806, 13778, 13906, 13915, 13912, 13916, 13908, 13804, 13890, 13807, 13887, 13892, 13849, 13675, 13816, 13756, 13800, 13753, 22516, 22528, 22525, 22517, 13791, 13786, 13783, 13784, 13779, 13755, 13775, 13774, 13720, 13767, 13759, 13760, 13754, 13742, 13663, 13665, 13731, 13737, 13695, 17997, 17993, 13723, 13701, 13677, 13714, 13685, 13699, 13676, 13698, 13669, 13668, 13662, 13659, 13651, 13646, 13531, 18000, 17999, 18011, 18002, 13610, 13618, 13637, 13631, 13643, 13632, 13636, 13579, 13601, 13602, 13599, 13586, 18013, 18015, 13593, 13567, 13580, 13030, 13566, 13575, 13514, 13551, 12420, 13571, 13569, 18018, 13554, 13523, 13483, 13550, 13548, 13532, 13553, 13490, 13547, 12925, 13482, 13533, 13545, 13538, 13535, 13534, 13458, 13427, 13494, 12584, 13424, 13495, 13508, 13498, 13395, 13426, 13469, 13087, 13404, 13481, 13473, 13479, 13454, 13436, 13340, 13444, 13437, 13443, 13445, 13451, 13438, 13410, 13352, 13401, 13409, 13397, 13251, 13345, 13412, 13419, 13418, 13416, 13357, 13400, 13349, 13291, 13371, 13396, 13365, 13379, 13380, 13386, 13385, 13382, 13351, 13289, 13310, 13359, 13356, 12738, 13335, 13339, 18022, 13305, 13224, 13333, 13036, 13308, 22893, 22886, 22880, 22879, 22885, 13306, 12903, 13079, 13297, 13296, 13246, 13126, 13293, 13228, 13288, 13290, 13107, 13205, 13252, 13241, 13234, 13229, 13231, 13209, 12951, 13262, 13253, 13254, 13263, 13255, 13238, 13236, 13230, 13232, 13197, 13227, 13213, 13223, 13200, 13216, 13195, 13158, 13173, 13137, 13136, 13156, 13168, 13084, 13185, 13186, 12920, 13080, 13102, 13128, 13135, 13122, 13132, 13120, 13077, 13081, 13088, 13042, 13072, 12881, 13094, 13092, 13059, 13044, 13060, 13046, 13058, 13055, 13049, 13037, 13053, 13025, 12581, 18029, 12855, 12995, 12945, 13024, 12986, 12726, 12810, 12983, 12943, 12931, 18031, 12994, 12988, 12987, 12985, 12982, 12924, 12935, 12967, 12974, 12971, 12972, 12936, 12944, 12819, 12880, 12934, 12486, 12879, 12932, 12930, 12665, 12874, 12859, 12926, 18035, 18033, 18038, 18037, 12896, 12899, 12897, 12825, 12906, 12905, 12565, 12875, 12831, 12826, 12884, 12890, 12885, 12694, 12651, 12864, 12745, 12689, 18039, 12805, 12809, 12830, 12823, 12848, 12840, 12839, 12850, 12796, 12811, 12732, 18042, 18041, 12712, 12787, 12793, 12788, 12778, 12776, 12744, 18045, 12763, 12751, 12756, 12752, 12760, 12757, 12753, 12734, 12701, 12681, 12729, 12704, 12722, 12708, 12719, 12716, 12572, 12673, 12718, 12691, 12659, 12574, 12655, 12699, 12594, 12695, 12678, 12683, 12672, 12582, 12670, 12643, 12667, 12576, 12661, 12662, 12646, 12653, 12652, 12642, 12591, 12598, 12551, 12631, 12595, 12587, 12471, 12579, 12536, 18049, 12600, 12628, 12601, 12625, 12617, 12618, 12602, 12580, 12570, 12568, 12567, 12457, 12532, 12557, 12467, 12558, 12553, 12477, 12515, 12510, 12449, 12527, 12518, 12439, 12512, 12488, 12514, 18051, 12436, 12474, 12425, 12505, 12426, 12492, 12501, 12493, 12499, 12416, 12419, 12441, 12440, 12412, 12438, 12413, 12405, 12340, 12406, 12364, 12094, 12408, 12370, 12343, 12339, 12372, 12373, 11542, 12366, 11566, 12302, 12377, 12378, 12392, 12201, 12362, 12138, 12356, 12357, 12338, 12349, 12352, 12315, 12342, 12312, 12317, 12311, 12182, 12294, 12298, 12324, 12323, 12325, 12327, 12329, 12326, 12054, 12301, 12293, 11141, 11972, 12235, 12286, 12253, 12148, 12254, 12249, 12241, 12005, 12246, 12247, 12205, 12245, 12213, 12272, 12263, 12262, 12275, 12277, 12264, 12273, 12265, 12237, 12236, 12207, 12151, 12188, 12228, 11927, 12197, 12219, 12215, 12209, 12134, 12118, 12202, 12194, 12128, 12133, 12196, 12189, 12181, 12191, 12159, 18055, 18054, 12174, 11827, 12178, 12156, 11874, 11775, 12155, 12139, 12149, 12136, 12113, 12119, 12126, 11902, 12110, 12129, 12111, 12058, 12123, 12066, 12067, 11994, 11904, 12050, 12105, 12103, 12070, 12099, 12097, 12102, 11829, 12098, 12100, 12093, 11892, 11872, 12069, 18062, 12065, 12056, 12064, 12090, 12077, 12087, 12083, 12091, 12084, 12078, 11423, 12059, 12055, 11674, 12007, 12048, 11920, 11922, 12042, 12038, 12040, 11919, 12009, 12039, 11939, 12037, 11836, 11986, 11992, 11987, 12017, 12016, 12021, 12022, 11935, 11998, 11997, 11909, 11885, 11925, 11832, 11943, 11890, 11971, 11936, 11861, 11945, 11941, 11924, 11923, 11965, 11950, 11954, 11964, 11956, 11962, 11957, 11907, 11917, 11888, 11817, 11913, 11884, 11864, 11883, 11899, 11856, 11891, 11897, 11429, 11786, 11790, 11887, 11881, 11789, 11873, 11866, 11720, 11731, 11819, 11869, 11865, 11808, 11779, 11833, 11860, 11794, 11835, 11818, 11831, 11809, 11855, 11838, 11846, 11839, 11840, 11845, 11792, 11807, 11606, 11772, 11798, 11782, 11665, 11805, 11774, 11787, 11762, 11795, 11739, 11785, 18070, 18066, 11754, 11768, 11715, 11742, 11457, 11753, 11652, 11730, 11717, 11751, 11746, 11750, 11744, 11597, 11727, 11671, 11641, 18078, 18077, 11728, 11723, 11712, 11653, 11662, 11708, 11645, 11648, 11185, 11642, 11337, 11666, 11664, 11500, 11686, 11701, 11689, 11699, 11688, 11700, 11694, 11690, 11696, 11661, 11340, 11650, 11529, 11571, 11539, 11600, 11305, 11603, 11634, 11572, 18080, 11604, 11607, 11193, 11630, 11585, 11594, 11577, 11540, 11528, 11570, 11396, 11536, 11514, 11557, 11559, 11558, 11563, 11535, 11524, 11268, 11493, 11530, 11486, 11430, 11427, 18085, 11371, 11508, 11489, 11495, 11488, 11485, 11455, 11416, 11428, 11451, 11464, 11480, 11478, 11473, 11399, 11450, 11405, 11419, 11445, 11441, 11440, 11407, 11317, 11401, 11377, 11005, 11404, 11334, 11383, 11390, 11002, 11344, 11172, 11379, 18092, 18091, 18089, 11348, 11236, 11270, 11346, 11039, 11226, 11369, 11372, 11366, 11235, 11327, 11303, 18098, 18097, 11351, 11356, 11352, 11173, 11323, 11329, 11309, 11320, 11318, 11019, 11266, 11304, 11174, 11302, 11301, 10955, 10978, 10856, 11071, 11225, 11256, 11251, 11294, 11248, 11285, 11237, 10793, 11232, 11162, 11155, 11159, 10912, 10998, 11191, 18101, 11183, 11184, 10968, 11206, 11207, 11217, 11215, 11208, 11154, 11164, 11163, 11158, 11048, 11148, 11149, 11147, 10735, 10999, 11103, 11125, 10991, 10601, 11054, 11113, 11115, 11124, 11118, 11068, 11111, 11110, 10958, 11112, 11108, 11104, 11074, 11022, 11029, 11059, 10953, 11055, 11044, 10744, 11027, 11096, 11093, 11092, 11083, 11080, 11084, 11082, 11081, 18106, 11042, 10868, 11035, 11031, 10780, 11020, 10960, 11018, 10835, 10992, 10947, 10985, 10995, 10829, 10980, 10941, 10969, 10977, 10974, 10971, 10975, 10973, 10965, 10928, 10964, 10957, 10935, 10784, 10952, 10946, 10948, 10944, 10934, 10891, 10831, 10898, 10782, 10914, 10916, 10921, 10911, 10790, 10842, 10867, 10779, 10905, 10685, 10892, 10858, 10866, 10888, 10855, 10864, 10678, 10814, 10704, 10876, 10880, 10877, 10884, 27761, 10656, 10659, 10693, 10828, 10822, 10787, 10736, 10750, 10802, 10801, 10769, 10809, 10803, 10700, 10701, 10740, 10747, 10737, 10689, 10679, 10705, 10730, 10722, 10728, 10723, 10687, 10683, 10684, 10660, 10668, 10686, 10681, 10661, 10634, 10655, 18122, 18120, 10581, 10596, 10572, 10632, 10627, 10594, 10564, 10583, 10608, 10610, 10609, 10622, 10621, 10611, 10584, 10565, 10582, 10566, 10574, 10562, 10405, 10402, 10272, 10457, 10545, 9803, 10547, 10539, 10504, 10524, 10372, 8457, 10528, 10518, 10508, 10515, 10453, 10459, 10455, 10438, 10434, 10462, 10460, 10092, 10478, 10477, 10485, 10472, 10487, 10484, 10179, 10210, 10435, 10447, 10186, 10242, 9822, 18134, 10369, 10375, 10359, 10361, 10428, 10360, 10421, 10426, 10346, 10349, 10280, 10279, 10327, 10302, 10337, 10212, 10294, 10271, 10303, 9917, 10312, 10322, 10314, 10315, 10313, 10284, 10275, 10274, 10246, 10093, 18135, 10249, 10248, 10243, 9847, 10158, 10200, 10215, 10187, 9809, 10218, 10217, 10219, 10234, 10235, 10220, 10226, 10233, 10228, 9858, 9804, 10205, 10203, 10198, 10193, 10143, 10166, 10192, 10191, 10171, 10053, 9903, 10161, 10154, 9774, 10141, 10146, 10081, 10137, 10133, 10125, 9988, 10098, 10089, 10079, 10113, 10119, 10102, 10107, 10105, 10103, 10121, 10104, 9790, 10078, 10077, 10074, 10062, 10065, 9507, 10056, 9972, 10018, 10050, 9883, 10047, 10049, 10004, 10012, 10020, 9965, 18138, 18140, 10019, 10017, 10013, 10011, 9885, 9795, 9998, 9974, 9976, 9979, 9981, 10029, 9975, 9982, 10027, 9994, 9902, 9962, 9963, 9949, 9907, 9913, 9591, 9970, 9848, 9939, 9924, 9936, 9947, 9944, 9941, 9929, 9860, 9850, 9853, 9900, 9746, 9882, 9818, 18146, 9869, 9781, 9866, 9759, 9800, 9863, 9635, 9805, 9799, 9755, 9813, 9829, 9842, 9827, 9846, 9831, 9832, 9830, 9839, 18149, 9789, 9461, 9711, 9783, 9752, 9715, 9742, 9700, 9706, 9739, 9769, 9660, 9719, 9657, 9656, 9637, 9697, 9672, 9441, 9654, 9647, 9670, 9661, 9678, 9680, 9681, 9685, 9687, 9684, 9679, 9673, 9674, 9729, 9506, 9466, 9651, 9599, 8892, 9636, 9550, 9642, 9603, 9596, 9551, 9600, 9588, 9595, 9582, 9457, 8447, 9590, 9556, 9614, 9567, 9562, 9563, 9557, 9615, 9626, 9623, 9587, 9555, 9578, 9411, 9537, 9581, 9579, 9575, 9553, 9545, 9539, 9543, 9547, 9488, 9510, 9463, 9409, 9310, 9535, 9492, 9476, 9498, 9491, 9465, 9473, 9152, 9469, 9501, 9445, 9253, 9443, 8222, 9444, 9314, 9186, 9399, 9268, 9326, 9304, 9429, 9433, 9423, 9430, 9422, 9396, 9325, 8876, 9317, 9311, 9262, 9290, 9287, 9273, 9271, 9256, 9332, 9259, 9245, 9172, 9167, 9176, 9155, 9190, 9188, 9191, 9180, 9218, 9219, 9214, 9226, 9215, 9225, 9032, 9068, 9162, 8877, 9158, 9084, 9013, 9139, 9105, 9144, 9336, 9335, 9334, 9109, 9110, 9100, 9124, 9131, 9088, 9092, 9086, 9020, 9007, 8971, 9033, 8869, 9046, 9054, 9047, 9036, 9056, 9017, 9004, 8962, 9003, 8862, 8900, 8713, 8974, 8921, 8875, 8822, 8956, 8881, 8736, 8945, 8946, 8950, 8935, 8955, 8936, 8953, 8934, 8793, 8893, 8884, 8851, 8836, 8209, 8863, 8861, 8856, 8852, 8844, 8850, 8823, 8799, 8715, 8834, 8818, 8808, 8807, 8792, 8737, 8651, 8374, 8678, 8778, 8787, 8780, 8777, 8493, 8634, 8725, 8717, 8568, 8763, 8753, 8768, 8770, 8761, 8754, 8714, 8706, 8682, 8445, 8709, 8600, 8703, 8704, 8424, 8656, 8520, 8663, 8702, 8698, 8694, 8650, 8652, 8573, 8646, 8219, 8565, 8644, 8595, 8640, 8602, 8590, 8593, 8497, 8570, 8588, 8621, 8613, 8612, 8616, 8618, 8617, 8614, 8610, 8627, 8566, 8569, 8564, 8559, 8524, 8554, 8489, 8495, 8521, 8519, 8496, 9361, 9360, 9359, 8475, 8516, 8462, 8512, 8513, 8510, 8398, 8473, 8500, 8507, 8503, 9387, 8487, 8435, 8430, 8437, 8390, 8478, 8465, 8480, 8540, 8545, 8544, 8530, 8529, 8547, 8541, 8537, 8531, 8534, 8532, 8466, 8407, 8468, 8452, 8413, 7981, 8439, 8449, 8416, 8458, 8456, 8451, 8450, 8402, 8441, 8442, 8404, 8428, 8401, 8417, 8368, 8409, 9365, 9367, 8406, 8380, 8382, 8378, 8400, 8396, 8129, 8351, 8366, 8236, 8330, 8373, 8384, 8375, 8377, 8355, 8348, 8353, 8328, 8335, 8243, 8247, 8239, 8326, 8273, 8276, 8315, 8279, 7940, 8145, 8221, 8260, 8196, 8297, 8281, 8282, 8284, 8291, 8296, 8308, 8293, 8292, 8283, 8298, 8225, 8249, 8240, 8248, 8200, 8157, 8227, 8193, 8146, 8014, 7960, 8214, 8204, 8194, 8108, 8091, 8159, 8021, 8156, 8126, 8149, 8151, 8086, 8184, 8186, 8172, 8176, 8171, 8170, 8124, 8131, 8038, 8087, 8132, 8120, 8079, 8010, 8114, 8105, 8095, 8045, 8088, 8089, 8046, 7935, 8031, 7949, 8013, 8052, 8061, 8057, 8056, 8054, 8063, 8077, 8074, 8053, 8023, 8027, 7976, 7998, 7944, 7954, 7991, 7980, 7975, 7974, 7932, 7952, 7965, 7941, 7925, 7912, 7892, 7899, 7911, 7938, 7970, 7887, 7880, 7724, 7870, 7766, 7858, 7859, 7818, 7494, 7855, 7705, 7828, 7842, 7841, 7830, 7832, 7843, 7829, 7920, 7816, 7725, 7786, 7787, 7793, 7788, 7789, 7790, 7722, 7706, 7751, 7749, 7752, 7756, 7727, 7667, 7707, 7702, 7573, 7638, 7697, 7668, 7691, 7688, 7690, 7664, 7669, 7622, 7582, 7647, 7632, 7634, 7631, 7630, 7580, 7260, 7592, 7447, 7597, 7599, 7598, 7608, 7600, 7609, 7607, 7583, 7563, 7507, 7502, 7538, 7570, 7490, 7560, 7559, 7441, 7452, 7361, 7475, 7484, 7477, 7478, 7485, 7462, 7394, 7389, 7314, 7401, 7402, 7434, 7426, 7331, 7403, 7419, 7405, 7392, 7384, 7378, 7375, 7273, 7347, 7280, 7284, 7311, 7250, 7285, 7289, 7304, 7291, 7253, 7268, 7254, 7234, 7227, 7257, 7247, 7209, 7096, 7211, 7220, 7214, 7212, 7216, 7140, 7192, 7169, 7195, 7156, 7059, 6277, 7159, 7180, 7171, 7181, 7179, 7172, 7177, 7148, 7138, 7087, 7107, 7109, 7094, 7124, 7112, 7113, 7116, 7114, 7117, 7079, 7051, 7076, 7058, 6915, 7054, 6982, 7024, 7045, 7029, 7031, 6989, 6865, 6996, 6997, 6998, 6999, 7009, 7000, 7011, 7008, 7001, 6914, 6993, 6950, 6949, 6918, 6968, 6960, 6961, 6967, 6962, 6969, 6966, 6848, 6941, 6940, 6934, 6932, 6874, 6862, 6923, 6764, 6922, 6906, 6893, 6894, 6908, 6895, 6838, 6881, 6877, 6844, 6859, 6850, 6819, 6650, 6791, 6703, 6745, 6420, 6784, 6737, 6769, 6810, 6808, 6803, 6802, 6812, 6806, 6805, 6799, 6771, 6744, 6782, 6738, 6491, 6779, 6639, 6777, 6717, 6780, 6750, 6757, 6751, 6753, 6759, 6756, 6735, 6711, 6549, 6716, 6705, 6728, 6724, 6725, 6729, 6713, 6355, 6649, 6691, 6699, 6665, 6697, 6149, 6690, 6687, 6689, 6654, 6681, 6680, 6679, 6682, 18153, 6661, 6640, 6647, 6642, 6628, 6629, 6637, 6619, 6627, 6548, 6545, 6596, 6600, 6605, 6595, 6604, 6594, 6597, 6602, 6573, 6546, 6556, 6552, 6558, 6554, 6553, 6557, 6555, 6529, 6540, 6318, 6312, 6542, 6537, 6507, 6522, 6520, 6519, 6517, 6508, 6350, 6470, 6448, 6395, 6461, 6451, 6463, 6453, 6458, 6300, 6353, 6421, 6382, 6367, 6378, 6379, 6392, 6391, 6386, 6362, 6363, 6348, 6307, 6275, 6356, 6352, 6316, 6293, 6321, 6322, 6323, 6324, 6332, 6330, 6339, 6337, 6331, 6253, 6250, 6247, 6256, 6257, 6261, 6258, 6208, 6207, 6209, 6214, 6215, 6227, 6210, 6182, 6159, 6156, 6040, 6144, 6133, 6134, 6135, 5293, 6121, 6120, 6109, 6106, 6076, 5893, 6003, 6093, 6091, 6095, 6092, 6098, 6078, 6075, 5505, 6004, 5994, 6026, 6052, 6053, 6062, 6054, 6036, 5981, 6020, 6011, 6012, 5980, 5978, 5950, 5951, 5965, 5966, 5948, 5917, 5946, 5846, 5919, 5921, 5922, 5903, 5892, 5848, 5575, 5885, 5884, 5881, 5872, 5875, 5829, 5831, 5830, 5818, 5825, 5819, 5381, 5770, 5800, 5799, 5782, 5708, 5767, 5732, 5684, 5751, 5633, 5711, 5719, 5693, 6389, 5710, 5692, 5635, 5704, 5672, 5677, 5669, 5626, 5657, 5658, 5611, 5579, 5616, 5507, 5572, 5591, 5595, 5540, 5563, 5531, 5523, 5553, 5557, 5526, 5514, 5497, 5461, 5508, 5501, 5500, 5471, 5469, 5487, 5480, 5451, 5454, 5426, 5455, 5429, 5443, 5427, 5413, 5345, 5338, 5380, 5363, 5362, 5368, 5364, 5374, 5312, 5330, 5332, 5310, 5308, 5298, 5261, 5254, 5242, 5233, 5262, 5258, 5264, 5216, 5281, 5275, 5280, 5282, 5274, 5219, 5238, 5225, 5213, 5208, 5210, 5051, 5042, 5196, 5185, 5178, 5179, 5186, 5177, 5069, 5145, 5080, 5155, 5156, 5162, 5157, 5143, 4946, 5137, 5121, 5125, 5126, 5004, 5136, 5109, 5070, 5100, 5093, 5083, 5099, 5082, 5094, 4841, 5078, 5058, 5063, 5059, 5040, 5041, 5039, 5002, 5023, 5027, 5028, 4906, 4955, 4979, 4980, 4997, 4981, 4982, 4986, 4876, 4960, 4964, 4951, 4887, 4902, 4948, 4642, 4900, 4915, 4940, 4918, 4917, 4919, 4920, 4936, 4921, 4922, 4934, 4905, 4748, 4895, 4894, 4843, 4520, 4882, 4853, 4854, 4857, 4868, 4810, 4836, 4561, 4809, 4820, 4829, 4833, 4754, 4635, 4759, 4774, 4760, 4727, 4714, 4564, 4645, 4687, 4633, 4576, 4648, 4643, 4668, 4667, 4659, 4674, 4630, 4624, 4565, 4559, 4617, 4549, 4551, 4582, 4586, 4583, 4581, 4473, 4469, 4538, 4529, 4535, 4455, 4519, 4525, 4524, 4485, 4526, 4465, 4486, 4501, 4487, 4488, 4508, 4492, 4490, 4491, 4502, 4511, 4489, 4468, 4372, 4458, 4408, 4452, 4416, 4417, 4418, 4424, 4419, 4432, 4420, 4421, 4447, 4445, 4423, 4444, 4422, 4364, 4335, 4411, 4401, 4389, 4361, 4392, 4384, 4342, 4348, 4353, 4358, 4382, 4357, 4351, 4345, 4340, 4343, 4326, 4279, 4275, 4312, 4293, 4297, 4296, 4299, 4246, 4291, 4280, 4281, 4282, 4278, 4219, 4218, 4259, 4261, 4273, 4262, 4260, 4176, 4221, 4222, 4224, 4209, 4183, 4190, 4191, 4187, 4177, 4171, 4162, 4174, 4164, 4161, 4150, 4144, 4143, 4145, 4130, 4132, 4131, 4135, 4067, 4119, 4023, 4117, 4103, 4104, 4105, 4100, 4050, 4098, 4047, 4088, 4075, 4076, 4071, 4086, 4049, 4054, 4059, 4039, 4037, 4024, 3980, 3954, 3963, 4007, 4002, 4004, 3983, 3957, 3962, 3960, 3931, 3941, 3932, 3933, 3940, 3926, 3922, 3341, 3896, 3899, 3900, 3907, 3734, 3746, 3845, 3857, 3846, 3854, 3847, 3855, 3758, 3824, 3829, 3795, 3792, 3811, 3756, 3760, 3759, 3761, 3762, 3703, 3678, 3744, 3641, 3706, 3712, 3711, 3713, 3714, 3724, 3720, 3722, 3439, 3695, 3699, 3691, 3640, 3651, 3661, 3662, 3430, 3637, 3639, 3608, 3627, 3548, 3565, 3613, 3560, 3574, 3582, 3583, 3545, 3571, 3549, 3496, 3518, 3543, 3364, 3537, 3539, 3520, 3503, 3499, 3474, 3544, 3371, 3486, 3469, 3465, 3451, 3460, 5438, 3426, 3435, 3421, 3418, 3414, 3413, 3412, 3394, 3395, 3390, 3385, 3362, 3337, 3367, 3359, 3370, 3365, 3356, 3361, 3325, 3353, 3354, 3338, 3326, 3329, 3327, 3302, 3315, 3303, 3306, 3295, 3289, 3255, 3273, 3269, 3213, 3247, 3246, 3239, 3240, 3238, 3204, 3169, 3097, 3217, 3218, 3228, 3229, 3222, 3219, 3221, 3110, 3211, 3077, 2380, 3205, 3203, 3172, 3201, 2435, 3189, 3175, 2479, 2650, 3173, 3170, 3165, 3145, 3154, 3101, 3144, 3106, 3160, 3374, 3119, 3140, 3141, 3137, 3142, 3083, 3066, 3056, 3058, 3057, 2476, 3052, 3033, 3034, 3037, 3046, 3035, 3048, 3036, 3050, 3047, 3028, 2485, 2651, 3022, 3025, 2657, 2659, 2366, 2484, 2376, 2481, 2498, 2489, 2496, 2502, 2499, 2490, 2507, 2503, 2491, 2497, 2447, 2446, 2413, 2411, 2364, 2437, 2371, 2478, 2363, 2414, 2428, 2415, 2420, 2421, 2417, 2419, 2416, 2383, 2404, 2386, 2401, 2387, 2406, 2388, 2389, 2359, 2375, 2368, 2361, 2462, 2353, 2347, 2349, 2357, 2343, 2342, 2326, 2319, 2309, 2336, 2331, 2323, 2666, 2312, 2322, 2669, 2220, 2291, 2305, 2303, 2256, 2233, 2179, 2202, 2214, 2673, 2210, 2208, 2209, 2200, 2195, 2181, 2183, 2188, 2184, 2176, 2174, 2150, 2171, 2161, 2156, 2158, 2159, 2129, 2095, 2113, 2116, 2112, 2104, 2089, 2083, 2091, 1840, 2042, 2055, 2057, 2040, 2687, 2033, 2688, 2007, 1996, 1995, 1807, 1991, 1964, 1968, 1976, 1984, 1987, 1977, 1955, 1962, 1918, 1931, 1934, 1939, 1943, 1944, 1933, 1929, 1909, 1890, 1892, 1877, 1869, 1868, 1862, 1842, 1820, 1816, 2707, 1838, 1818, 1828, 1830, 1804, 1783, 2712, 1809, 1803, 1806, 1798, 1795, 1791, 2718, 2717, 1789, 1793, 1771, 1774, 1775, 1766, 1819, 1721, 1715, 1691, 1661, 1643, 1637, 1638, 2731, 2553, 1598, 1618, 1613, 1595, 2740, 1591, 1588, 1558, 1565, 1540, 1541, 1525, 1522, 1509, 2762, 1478, 1480, 1481, 1482, 1489, 1475, 1467, 1463, 2766, 1445, 1441, 1454, 1446, 1442, 2779, 1412, 1416, 1417, 1419, 1420, 1426, 1424, 1428, 1406, 1411, 1405, 1386, 1387, 1396, 1388, 1395, 1372, 1375, 1374, 1373, 1382, 1376, 1355, 1356, 1357, 1359, 1358, 1366, 1360, 1339, 1344, 1341, 1340, 1343, 1353, 1342, 1345, 1352, 1322, 1336, 1323, 1325, 1324, 1326, 1303, 1304, 1318, 1306, 1305, 1315, 1319, 1307, 1232, 1234, 1233, 1239, 1235, 1236, 1240, 1246, 1247, 1250, 1249, 1248, 2809, 1258, 1259, 1281, 1260, 1261, 1262, 1277, 1276, 1290, 1285, 1291, 1287, 1215, 1216, 1224, 1217, 1225, 1228, 1227, 1218, 1192, 1212, 1194, 1193, 1195, 1198, 1196, 1197, 1208, 1178, 1179, 1186, 1167, 1164, 1145, 1159, 1144, 1147, 1146, 1160, 1162, 1141, 1143, 2814, 2815, 1140, 1118, 1124, 1119, 1126, 1139, 1120, 1133, 1125, 2817, 1095, 1114, 1097, 1098, 1112, 2818, 2819, 970, 1091, 2821, 1082, 1072, 1086, 1073, 1074, 1041, 1044, 1067, 1058, 1043, 1042, 2585, 1007, 1008, 1031, 1010, 1035, 1033, 1039, 1009, 984, 985, 997, 1000, 986, 976, 972, 878, 2831, 941, 965, 942, 968, 963, 944, 966, 943, 917, 918, 932, 939, 920, 935, 937, 2837, 879, 880, 901, 881, 897, 898, 882, 876, 872, 858, 868, 825, 2847, 799, 805, 801, 800, 803, 807, 819, 804, 806, 823, 2851, 791, 835, 834, 792, 793, 790, 788, 832, 2601, 2855, 759, 764, 761, 765, 724, 746, 725, 726, 727, 723, 718, 719, 708, 661, 604, 2872, 644, 628, 626, 620, 622, 617, 627, 610, 624, 592, 595, 553, 591, 544, 566, 573, 572, 608, 552, 550, 538, 517, 524, 518, 512, 463, 467, 464, 479, 478, 447, 443, 438, 428, 426, 396, 417, 409, 407, 406, 389, 390, 388, 375, 2907, 356, 365, 334, 325, 2633, 2634, 330, 313, 2926, 332, 100, 116, 137, 130, 118, 309, 293, 2941, 300, 16, 31, 10, 23, 2953, 2949, 294, 2974, 37, 51, 64, 39, 62, 52, 73, 2989, 74, 244, 271, 76, 249, 259, 246, 250, 236, 235, 229, 206, 190, 216, 214, 3015, 197, 208, 91, 167, 174, 169, 153, 162, 165, 152, 145)) 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, 15.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 18c5c3781d5caa776872a2c02ee1d7b3ca46acda

Labels: decksite

[vorpal-buildbot]

Exceeded slow_query limit (13.8 > 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 (64255, 63923, 63642, 63666, 63388, 63491, 63431, 63449, 63400, 63395, 63368, 64268, 63137, 62984, 62942, 62770, 62851, 63058, 62228, 62699, 62403, 62687, 62528, 62441, 62384, 62383, 62366, 62358, 62216, 62124, 62108, 62103, 62013, 62051, 61970, 62023, 61796, 61735, 61719, 61695, 61681, 61561, 61592, 61523, 61607, 61556, 61563, 61550, 61554, 61484, 61372, 61369, 61320, 61173, 61318, 61263, 60933, 61152, 61119, 61074, 61125, 61052, 60921, 61031, 60617, 60674, 60764, 60556, 60826, 60870, 60820, 60639, 60688, 60572, 60637, 60563, 60571, 60531, 60515, 60346, 60487, 60475, 60455, 60380, 60347, 60292, 60331, 59577, 60065, 60317, 60263, 60287, 60242, 60141, 60262, 60131, 60126, 60121, 60119, 60040, 60031, 59762, 59983, 59969, 59633, 59928, 59624, 59870, 59881, 59795, 59834, 59814, 59622, 59793, 59792, 59727, 59783, 59603, 59470, 59488, 59553, 59604, 59592, 59568, 59581, 59435, 59499, 59502, 59469, 59467, 59466, 59407, 59425, 59411, 59395, 59366, 59363, 59354, 56925, 59074, 58914, 59044, 59003, 58989, 58990, 58947, 58862, 58792, 58767, 58765, 58470, 58094, 58141, 57755, 57288, 57282, 57260, 57231, 57015, 57253, 57086, 57059, 57042, 57039, 56961, 56778, 56742, 56753, 56694, 56637, 56571, 56525, 56394, 56452, 56405, 56399, 56388, 56326, 56286, 56254, 56166, 56168, 56162, 56153, 56075, 55031, 56096, 55999, 55917, 55918, 55884, 55835, 55782, 55737, 55717, 55722, 55693, 55685, 55510, 55488, 55412, 55208, 55181, 55122, 55047, 54522, 54927, 54939, 54909, 54881, 54848, 54741, 54832, 54822, 54817, 54683, 54767, 54701, 54503, 54594, 54596, 54427, 54507, 54554, 54442, 54462, 54251, 54416, 54414, 54364, 54299, 54351, 54260, 54250, 54230, 54231, 54225, 54112, 54194, 54152, 54168, 54115, 54111, 54056, 53452, 53994, 53990, 53959, 53968, 53474, 53882, 53716, 53910, 53876, 53888, 53840, 53763, 53833, 53813, 53687, 53805, 53769, 53570, 53749, 53669, 53643, 53684, 53670, 53662, 53485, 53473, 53638, 53582, 53484, 53573, 53526, 53449, 53549, 53502, 53497, 53501, 53297, 53480, 53433, 53451, 53440, 53321, 53372, 53414, 53395, 53375, 53397, 53154, 53303, 53328, 53354, 53347, 53325, 53252, 53308, 53306, 53300, 53148, 53289, 53235, 53239, 53238, 53236, 52617, 53230, 53226, 53186, 53107, 53139, 53126, 51435, 53002, 53100, 52947, 52818, 52993, 52996, 52959, 52881, 52576, 52970, 52941, 52930, 52765, 52895, 52902, 52629, 52866, 52870, 52876, 52476, 52793, 52220, 52795, 52783, 52747, 52771, 52754, 52762, 52729, 52720, 52703, 52641, 52630, 52611, 52506, 52560, 52566, 52556, 52546, 52449, 52472, 52460, 52431, 52428, 52424, 52321, 52416, 52243, 52366, 52178, 52387, 52375, 52222, 52305, 52349, 52309, 52257, 52290, 52192, 52212, 52236, 52230, 52223, 52200, 52218, 52211, 52206, 51377, 52108, 52101, 51909, 51882, 52050, 52045, 51955, 51526, 51897, 51888, 51870, 51837, 51676, 51705, 51680, 51370, 51612, 51565, 51568, 51558, 51472, 51468, 51485, 51356, 51263, 51170, 51041, 51114, 51244, 51246, 51185, 51113, 51032, 50909, 50914, 50908, 50737, 50854, 50620, 50752, 50694, 50681, 50677, 50668, 50629, 50607, 50554, 49714, 50402, 50379, 50264, 50205, 48762, 50200, 50080, 50041, 49965, 49966, 49106, 49898, 49913, 49902, 49842, 49803, 49792, 49771, 49751, 49469, 49493, 47844, 49669, 49687, 49685, 49583, 49636, 49604, 49315, 49579, 49533, 49299, 49502, 49497, 49430, 49330, 49364, 49312, 49207, 48903, 49154, 49189, 49215, 49200, 49178, 49234, 48197, 49124, 48775, 48810, 48834, 48226, 48600, 48565, 48537, 48511, 48475, 48451, 48452, 47851, 48376, 48180, 48269, 48175, 48171, 48115, 48031, 48025, 48090, 48073, 48075, 48067, 48033, 47824, 47875, 47827, 47739, 47766, 47745, 47583, 47615, 47338, 47083, 47199, 47028, 46999, 46832, 46771, 46760, 46741, 46725, 46540, 46439, 46443, 46034, 45972, 46008, 46040, 45777, 45443, 44671, 44107, 43966, 43936, 43976, 43929, 43991, 43951, 43911, 43910, 43746, 43801, 43731, 43832, 43608, 43543, 43496, 43522, 43480, 43444, 43362, 43356, 43326, 43354, 43315, 43295, 43264, 43261, 43201, 43202, 42490, 43115, 43096, 43079, 43073, 43066, 42847, 42840, 42841, 42836, 42812, 42660, 42659, 42707, 42604, 42642, 42588, 42609, 42548, 42571, 42532, 42528, 42537, 42494, 42475, 42436, 42526, 42391, 42389, 42383, 42346, 42313, 42167, 42022, 38754, 41972, 41893, 41732, 41827, 41683, 41682, 41324, 41644, 41562, 41613, 41559, 41521, 40837, 40643, 40676, 40408, 34530, 40017, 39723, 38751, 38146, 38059, 37987, 37480, 37765, 37314, 37067, 36541, 36583, 36570, 36195, 36214, 36215, 34881, 35345, 35048, 35443, 34696, 34716, 34605, 34416, 34088, 34116, 33624, 33806, 33646, 33625, 33558, 32854, 32979, 32883, 32718, 32689, 32395, 29971, 29997, 29853, 29846, 29425, 29400, 29281, 29103, 28991, 29077, 28040, 28005, 27435, 27780, 27415, 27259, 27193, 26760, 26957, 26938, 26401, 26514, 26400, 26385, 26202, 26062, 26007, 25903, 25891, 25701, 25362, 25301, 25202, 25194, 25140, 25035, 25075, 25041, 24854, 24975, 24711, 24984, 24953, 24970, 24833, 24800, 24904, 24857, 24636, 24409, 24625, 24527, 24716, 24641, 24665, 24474, 24605, 24513, 24504, 24462, 23108, 24302, 24383, 24382, 24367, 24247, 23951, 24162, 24155, 24078, 23945, 23976, 23973, 23899, 23913, 23886, 23881, 23869, 23606, 23861, 23716, 23714, 23251, 23575, 23569, 23570, 23543, 23518, 23535, 23473, 23443, 23438, 23436, 23385, 23363, 23327, 23343, 23344, 23299, 23107, 23290, 23225, 23233, 23196, 23083, 23138, 23116, 23097, 23064, 22855, 22982, 23030, 23025, 22971, 23012, 22835, 22956, 22953, 22932, 22906, 22430, 22844, 22859, 22854, 22842, 22817, 22832, 22839, 22792, 22501, 22811, 22807, 22765, 22760, 22132, 22757, 22789, 22615, 22690, 22369, 22661, 22653, 22642, 22660, 22621, 22649, 22617, 22614, 22592, 22547, 22630, 22636, 22567, 22371, 22507, 22558, 22549, 21957, 22488, 22560, 22551, 22504, 22462, 22477, 22387, 22469, 22463, 22458, 22391, 22335, 22297, 22280, 22399, 22396, 22353, 22380, 22310, 22311, 22349, 22239, 22329, 22347, 22345, 22346, 22325, 22334, 22313, 22235, 22279, 22294, 22281, 22269, 22218, 22263, 22068, 22237, 22222, 22194, 21559, 22173, 22216, 22193, 22195, 21960, 22067, 22181, 21907, 22093, 21932, 22126, 22053, 22120, 22080, 22081, 22072, 22074, 22070, 22019, 22025, 22064, 22052, 21997, 22024, 22032, 22010, 21930, 22000, 21457, 21999, 21952, 21834, 21956, 21946, 21955, 21511, 21944, 21875, 21939, 21826, 21937, 21906, 21534, 21864, 21914, 21860, 21823, 21831, 21703, 21699, 21682, 21822, 21820, 21416, 21815, 21812, 21806, 21073, 21661, 21767, 21561, 21755, 21695, 21701, 21470, 21642, 21654, 21651, 21649, 21644, 21643, 21645, 21614, 21308, 21608, 21001, 21635, 21603, 21589, 21554, 21051, 21533, 21538, 21472, 21540, 21500, 21532, 21505, 21481, 21489, 21491, 21494, 21486, 21440, 21475, 21387, 21459, 21428, 21449, 21445, 21439, 21426, 21402, 21343, 21431, 21395, 21138, 21303, 21276, 21350, 21191, 21320, 21249, 21260, 21270, 21086, 21167, 21242, 21067, 21220, 21162, 21214, 21165, 21082, 21164, 21156, 21038, 20919, 21123, 21032, 21193, 21070, 21019, 21181, 21170, 21155, 20897, 21037, 21139, 20910, 21085, 21115, 21112, 20886, 21053, 21025, 20941, 20902, 21036, 21033, 20712, 20977, 20996, 20951, 20947, 20939, 20725, 20908, 20646, 20681, 20806, 20850, 20669, 20799, 20858, 20876, 20841, 20854, 20833, 20824, 20819, 20823, 20821, 20760, 20809, 20804, 20726, 20773, 20638, 20768, 20769, 20700, 20764, 20676, 20717, 20706, 20692, 20636, 20682, 20683, 20671, 20674, 20666, 20615, 20606, 20462, 20290, 20355, 19543, 20323, 20279, 20133, 20221, 20215, 19909, 19943, 19911, 19907, 19903, 19890, 19401, 19795, 19753, 19663, 19713, 19711, 19113, 19238, 19552, 19530, 19531, 19428, 19482, 19481, 19395, 19363, 19151, 19298, 19193, 19194, 19189, 19188, 19055, 19097, 18930, 18836, 18843, 18688, 18460, 18766, 18748, 18553, 18673, 18432, 18489, 18427, 18320, 18248, 18226, 18171, 18172, 17587, 17554, 17644, 17744, 17745, 17221, 17585, 16552, 17575, 17415, 17417, 17461, 17388, 17338, 16845, 17178, 17288, 17122, 17190, 16484, 17153, 17070, 17054, 17020, 16936, 16937, 16994, 16996, 16967, 16964, 16914, 16928, 16855, 16814, 16648, 16740, 16739, 16493, 16659, 16554, 16628, 16602, 16581, 16540, 16558, 16619, 16575, 16516, 16507, 16470, 16465, 16351, 16464, 16478, 16477, 16348, 16373, 16374, 16339, 16328, 16161, 16089, 16120, 16124, 16122, 16058, 16061, 16064, 15912, 15993, 16040, 16014, 15996, 15988, 15987, 15985, 15970, 15971, 15922, 15688, 15905, 15331, 15865, 15866, 15867, 15868, 15775, 15769, 15760, 15722, 15712, 15717, 15708, 15702, 15459, 15687, 15675, 15672, 15659, 15660, 15650, 15181, 15588, 15565, 15483, 15485, 15449, 15230, 15423, 15405, 15420, 15356, 15375, 15294, 15313, 15326, 15317, 14787, 15291, 15232, 15251, 15254, 15227, 15220, 15163, 15207, 15158, 15144, 15152, 15184, 15187, 15194, 15186, 15185, 15193, 15057, 14952, 14994, 15114, 15046, 15098, 15049, 15015, 14962, 14938, 14862, 14892, 14896, 14208, 14347, 14646, 14650, 14669, 14679, 14683, 14658, 14639, 14539, 14369, 14575, 14205, 14366, 14446, 14376, 14258, 14373, 14224, 14276, 14252, 14277, 14333, 14251, 14302, 14159, 13710, 14231, 14138, 14206, 14183, 14192, 14153, 14164, 14090, 14133, 14123, 13926, 14092, 14100, 14017, 13944, 14010, 13964, 13954, 13943, 13823, 13805, 13790, 13683, 13655, 12696, 13641, 13640, 13574, 13525, 13543, 13492, 13432, 13486, 13374, 13485, 13511, 13450, 13133, 13422, 13334, 13392, 13391, 13364, 13353, 13301, 22892, 22890, 13233, 13159, 13268, 13207, 13172, 13180, 13181, 13182, 13023, 13071, 12901, 12976, 12822, 12841, 12851, 12842, 12843, 12765, 12705, 12693, 12684, 12575, 12658, 12657, 12448, 12624, 12614, 12613, 12476, 12463, 12307, 12401, 12379, 12385, 12319, 12320, 12322, 12290, 12295, 12268, 12270, 12269, 12173, 12079, 8549, 7568, 61)) 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, 13.8, mysql)

Reported on decksite by mysql-perf

Location Hash: 18c5c3781d5caa776872a2c02ee1d7b3ca46acda

Labels: decksite