MySQL 5.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE times (
  `ID` int(11) NOT NULL,
  `challengeID` mediumint(9) NOT NULL DEFAULT '0',
  `playerID` mediumint(9) NOT NULL DEFAULT '0',
  `score` int(11) NOT NULL DEFAULT '0',
  `date` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `checkpoints` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO `times` (`ID`, `challengeID`, `playerID`, `score`, `date`, `checkpoints`) VALUES
(82424, 466, 43, 10760, 1519923280, '8740,10760'),
(82443, 466, 2, 10780, 1519923356, '8750,10780'),
(82452, 466, 43, 10780, 1519923410, '8760,10780'),
(82458, 466, 516, 10790, 1519923491, '8740,10790'),
(82463, 466, 224, 10790, 1519923544, '8750,10790'),
(82472, 466, 43, 10750, 1519923589, '8730,10750'),
(82477, 466, 2, 10770, 1519923615, '8750,10770'),
(82493, 466, 108, 10780, 1519923705, '8750,10780'),
(82495, 466, 536, 10790, 1519923706, '8760,10790'),
(82497, 466, 43, 10790, 1519923711, '8740,10790'),
(82499, 466, 536, 10780, 1519923720, '8750,10780'),
(82957, 466, 75, 10780, 1519974258, '8760,10780'),
(83059, 466, 890, 10780, 1519991682, '8760,10780'),
(83067, 466, 1163, 10780, 1519991804, '8750,10780'),
(83069, 466, 1163, 10780, 1519991843, '8760,10780'),
(83072, 466, 1163, 10760, 1519991877, '8740,10760'),
(83077, 466, 28, 10790, 1519991922, '8740,10790'),
(83078, 466, 28, 10790, 1519991937, '8740,10790'),
(83854, 466, 68, 10740, 1520127190, '8740,10740'),
(83855, 466, 874, 10720, 1520127255, '8770,10720'),
(83856, 466, 874, 10620, 1520127293, '8770,10620'),
(83857, 466, 68, 10690, 1520127333, '8730,10690'),
(83858, 466, 874, 10530, 1520127377, '8730,10530'),
(83859, 466, 68, 10610, 1520127396, '8750,10610'),
(83860, 466, 874, 10660, 1520127424, '8780,10660'),
(84482, 466, 944, 10650, 1520245653, '8730,10650'),
(84483, 466, 716, 10510, 1520245682, '8770,10510'),
(84484, 466, 944, 10510, 1520245690, '8790,10510'),
(84485, 466, 439, 10550, 1520245709, '8760,10550'),
(84486, 466, 716, 10540, 1520245728, '8750,10540'),
(84487, 466, 716, 10520, 1520245762, '8790,10520'),
(84488, 466, 944, 10560, 1520245775, '8740,10560'),
(84489, 466, 716, 10490, 1520245810, '8770,10490'),
(84490, 466, 944, 10630, 1520245810, '8750,10630'),
(84491, 466, 944, 10490, 1520245855, '8750,10490'),
(84492, 466, 944, 10510, 1520245872, '8760,10510'),
(84744, 466, 716, 10540, 1520267004, '8790,10540'),
(84745, 466, 944, 10540, 1520267011, '8770,10540'),
(84747, 466, 2, 10670, 1520267047, '8760,10670'),
(84748, 466, 47, 10490, 1520267048, '8750,10490'),
(84750, 466, 2, 10500, 1520267061, '8770,10500'),
(84751, 466, 147, 10540, 1520267068, '8780,10540'),
(84754, 466, 108, 10720, 1520267084, '8790,10720'),
(84755, 466, 716, 10570, 1520267085, '8790,10570'),
(84756, 466, 890, 10540, 1520267091, '8760,10540'),
(84757, 466, 147, 10500, 1520267091, '8770,10500'),
(84758, 466, 47, 10520, 1520267093, '8740,10520'),
(84759, 466, 439, 10540, 1520267098, '8770,10540'),
(84760, 466, 108, 10770, 1520267098, '8800,10770'),
(84761, 466, 890, 10500, 1520267105, '8750,10500'),
(84762, 466, 108, 10680, 1520267112, '8770,10680'),
(84763, 466, 147, 10500, 1520267127, '8740,10500'),
(84764, 466, 147, 10510, 1520267140, '8740,10510'),
(84765, 466, 108, 10790, 1520267147, '8770,10790'),
(84766, 466, 654, 10680, 1520267151, '8740,10680'),
(84767, 466, 890, 10530, 1520267151, '8750,10530'),
(84770, 466, 944, 10510, 1520267169, '8770,10510'),
(84771, 466, 108, 10690, 1520267171, '8740,10690'),
(84773, 466, 8, 10590, 1520267184, '8770,10590'),
(84774, 466, 944, 10480, 1520267194, '8750,10480'),
(84775, 466, 654, 10590, 1520267203, '8760,10590'),
(84776, 466, 716, 10650, 1520267204, '8730,10650'),
(84778, 466, 108, 10710, 1520267216, '8820,10710'),
(84779, 466, 716, 10700, 1520267231, '8780,10700'),
(84780, 466, 8, 10510, 1520267239, '8780,10510'),
(84781, 466, 147, 10530, 1520267240, '8730,10530'),
(84782, 466, 47, 10520, 1520267259, '8750,10520'),
(84783, 466, 108, 10550, 1520267276, '8820,10550'),
(84785, 466, 890, 10570, 1520267278, '8760,10570'),
(84786, 466, 8, 10520, 1520267287, '8780,10520'),
(84788, 466, 944, 10490, 1520267297, '8740,10490'),
(84789, 466, 147, 10590, 1520267311, '8770,10590'),
(84790, 466, 1188, 10510, 1520267322, '8790,10510'),
(84791, 466, 8, 10490, 1520267322, '8750,10490'),
(84792, 466, 716, 10650, 1520267340, '8750,10650'),
(84793, 466, 944, 10480, 1520267343, '8750,10480'),
(84794, 466, 147, 10620, 1520267344, '8830,10620'),
(84795, 466, 654, 10570, 1520267361, '8740,10570'),
(84796, 466, 8, 10490, 1520267362, '8750,10490'),
(84797, 466, 716, 10540, 1520267365, '8770,10540'),
(84798, 466, 890, 10500, 1520267374, '8760,10500'),
(84799, 466, 108, 10710, 1520267375, '8740,10710'),
(84801, 466, 47, 10470, 1520267381, '8750,10470'),
(84802, 466, 2, 10480, 1520267402, '8750,10480'),
(84804, 466, 944, 10470, 1520267434, '8740,10470'),
(84806, 466, 890, 10500, 1520267452, '8760,10500'),
(84807, 466, 108, 10590, 1520267453, '8840,10590'),
(84808, 466, 654, 10550, 1520267463, '8780,10550'),
(84809, 466, 108, 10490, 1520267468, '8770,10490'),
(84810, 466, 944, 10510, 1520267469, '8780,10510'),
(84811, 466, 716, 10570, 1520267484, '8820,10570'),
(84812, 466, 8, 10520, 1520267492, '8750,10520'),
(84813, 466, 47, 10480, 1520267498, '8740,10480'),
(84814, 466, 147, 10540, 1520267504, '8740,10540'),
(84815, 466, 97, 10500, 1520267522, '8760,10500'),
(84816, 466, 439, 10490, 1520267528, '8770,10490'),
(84817, 466, 8, 10470, 1520267530, '8730,10470'),
(85186, 466, 28, 10750, 1520312087, '8790,10750'),
(85187, 466, 28, 10550, 1520312279, '8760,10550'),
(85188, 466, 28, 10530, 1520312430, '8810,10530'),
(85189, 466, 28, 10490, 1520312723, '8760,10490'),
(85191, 466, 28, 10500, 1520312892, '8760,10500'),
(85192, 466, 255, 10730, 1520312906, '8770,10730'),
(85194, 466, 255, 10740, 1520312941, '8810,10740'),
(85195, 466, 255, 10710, 1520313003, '8780,10710'),
(85196, 466, 28, 10500, 1520313023, '8740,10500'),
(85197, 466, 28, 10470, 1520313078, '8750,10470'),
(85198, 466, 255, 10680, 1520313133, '8760,10680'),
(85199, 466, 255, 10600, 1520313199, '8810,10600'),
(85200, 466, 255, 10690, 1520313213, '8760,10690'),
(85201, 466, 255, 10460, 1520313226, '8740,10460'),
(85202, 466, 28, 10480, 1520313230, '8740,10480'),
(85203, 466, 255, 10660, 1520313325, '8760,10660'),
(85204, 466, 255, 10510, 1520313349, '8770,10510'),
(85205, 466, 255, 10530, 1520313429, '8740,10530'),
(85206, 466, 28, 10490, 1520313466, '8760,10490'),
(85207, 466, 28, 10480, 1520313480, '8740,10480'),
(85208, 466, 28, 10460, 1520313747, '8740,10460'),
(85717, 466, 599, 10780, 1520409736, '8770,10780'),
(85721, 466, 811, 10790, 1520409915, '8770,10790'),
(85722, 466, 599, 10560, 1520409928, '8760,10560'),
(85723, 466, 599, 10510, 1520410008, '8770,10510'),
(85724, 466, 599, 10470, 1520410050, '8750,10470'),
(85725, 466, 599, 10700, 1520410160, '8770,10700'),
(86094, 466, 716, 10540, 1520531431, '8750,10540'),
(86095, 466, 716, 10520, 1520531466, '8760,10520'),
(86096, 466, 716, 10520, 1520531545, '8750,10520'),
(86218, 466, 66, 10580, 1520591360, '8790,10580'),
(86219, 466, 66, 10540, 1520591374, '8800,10540'),
(86222, 466, 66, 10550, 1520591446, '8790,10550'),
(86224, 466, 66, 10510, 1520591487, '8740,10510'),
(86225, 466, 66, 10480, 1520591535, '8740,10480'),
(86227, 466, 66, 10500, 1520591684, '8760,10500'),
(86228, 466, 66, 10490, 1520591709, '8740,10490'),
(86231, 466, 66, 10590, 1520591744, '8820,10590'),
(86232, 466, 66, 10470, 1520591784, '8740,10470'),
(86233, 466, 66, 10480, 1520591830, '8760,10480'),
(86234, 466, 66, 10500, 1520591843, '8740,10500'),
(86235, 466, 66, 10490, 1520591890, '8740,10490'),
(86236, 466, 66, 10560, 1520591973, '8730,10560'),
(86237, 466, 66, 10530, 1520592020, '8740,10530'),
(86238, 466, 66, 10480, 1520592044, '8740,10480'),
(86240, 466, 66, 10470, 1520592079, '8740,10470'),
(86241, 466, 66, 10480, 1520592128, '8740,10480'),
(86242, 466, 66, 10540, 1520592153, '8770,10540'),
(86243, 466, 66, 10480, 1520592178, '8750,10480'),
(86245, 466, 66, 10490, 1520592236, '8750,10490'),
(86247, 466, 66, 10630, 1520592295, '8720,10630'),
(86248, 466, 164, 10500, 1520592312, '8740,10500'),
(86251, 466, 164, 10560, 1520592407, '8800,10560'),
(86252, 466, 164, 10580, 1520592422, '8780,10580'),
(86253, 466, 66, 10580, 1520592435, '8750,10580'),
(86254, 466, 164, 10490, 1520592458, '8760,10490'),
(86255, 466, 66, 10500, 1520592483, '8770,10500'),
(86256, 466, 66, 10460, 1520592496, '8730,10460'),
(86257, 466, 66, 10520, 1520592510, '8730,10520'),
(86292, 466, 97, 10560, 1520612143, '8780,10560'),
(86293, 466, 8, 10530, 1520612189, '8790,10530'),
(86297, 466, 8, 10480, 1520612254, '8750,10480'),
(86298, 466, 1585, 10640, 1520612256, '8760,10640'),
(86302, 466, 28, 10610, 1520612310, '8870,10610'),
(86303, 466, 8, 10490, 1520612324, '8750,10490'),
(86305, 466, 8, 10480, 1520612389, '8760,10480'),
(86306, 466, 1588, 10700, 1520612412, '8790,10700'),
(86309, 466, 97, 10530, 1520612459, '8790,10530'),
(86310, 466, 97, 10530, 1520612472, '8780,10530'),
(86311, 466, 8, 10490, 1520612473, '8720,10490'),
(86312, 466, 1585, 10550, 1520612501, '8760,10550'),
(86313, 466, 1588, 10610, 1520612504, '8790,10610'),
(86314, 466, 1585, 10570, 1520612515, '8780,10570'),
(86315, 466, 1031, 10780, 1520612518, '8750,10780'),
(86316, 466, 1588, 10740, 1520612527, '8770,10740'),
(86317, 466, 1031, 10520, 1520612541, '8750,10520'),
(86318, 466, 1031, 10520, 1520612555, '8780,10520'),
(86319, 466, 1588, 10550, 1520612573, '8740,10550'),
(86320, 466, 97, 10590, 1520612578, '8750,10590'),
(86321, 466, 1588, 10530, 1520612586, '8780,10530'),
(86323, 466, 28, 10490, 1520612611, '8770,10490'),
(86324, 466, 1585, 10530, 1520612613, '8770,10530'),
(86325, 466, 1585, 10500, 1520612638, '8750,10500'),
(86326, 466, 28, 10470, 1520612641, '8750,10470'),
(86327, 466, 1535, 10730, 1520612643, '8760,10730'),
(86329, 466, 97, 10680, 1520612664, '8750,10680'),
(86330, 466, 1031, 10680, 1520612665, '8780,10680'),
(86331, 466, 1535, 10570, 1520612679, '8750,10570'),
(86724, 466, 261, 10500, 1520716791, '8740,10500'),
(87124, 466, 28, 10510, 1520823293, '8750,10510'),
(87125, 466, 28, 10520, 1520823581, '8760,10520'),
(87535, 466, 28, 10520, 1520909355, '8770,10520'),
(87679, 466, 1577, 10750, 1520960416, '8780,10750'),
(87681, 466, 97, 10580, 1520960510, '8800,10580'),
(87682, 466, 2, 10530, 1520960532, '8780,10530'),
(87683, 466, 97, 10520, 1520960568, '8790,10520'),
(87687, 466, 97, 10480, 1520960651, '8750,10480'),
(87688, 466, 97, 10500, 1520960708, '8770,10500'),
(87689, 466, 1535, 10710, 1520960720, '8860,10710'),
(87690, 466, 97, 10500, 1520960771, '8780,10500'),
(87691, 466, 1577, 10520, 1520960776, '8750,10520'),
(87692, 466, 1552, 10670, 1520960780, '8780,10670'),
(87693, 466, 97, 10540, 1520960784, '8780,10540'),
(87880, 466, 474, 10620, 1521040795, '8820,10620'),
(87882, 466, 1714, 10590, 1521040879, '8730,10590'),
(87883, 466, 474, 10510, 1521040956, '8750,10510'),
(87884, 466, 1714, 10580, 1521040965, '8790,10580'),
(87885, 466, 474, 10530, 1521040970, '8800,10530'),
(87886, 466, 397, 10610, 1521041025, '8800,10610'),
(87887, 466, 1535, 10550, 1521041025, '8800,10550'),
(87888, 466, 1031, 10790, 1521041034, '8750,10790'),
(87889, 466, 474, 10530, 1521041060, '8810,10530'),
(87890, 466, 397, 10650, 1521041061, '8750,10650'),
(87891, 466, 1535, 10730, 1521041064, '8760,10730'),
(87892, 466, 397, 10640, 1521041128, '8810,10640'),
(87893, 466, 1714, 10570, 1521041139, '8780,10570'),
(87894, 466, 397, 10610, 1521041141, '8740,10610'),
(87895, 466, 1031, 10690, 1521041154, '8770,10690'),
(87896, 466, 474, 10530, 1521041206, '8750,10530'),
(88121, 466, 1031, 10670, 1521111725, '8760,10670'),
(88123, 466, 1651, 10510, 1521111790, '8770,10510'),
(88124, 466, 1651, 10690, 1521111806, '8750,10690'),
(88125, 466, 1651, 10530, 1521111949, '8770,10530'),
(88127, 466, 1651, 10520, 1521111990, '8770,10520'),
(88128, 466, 1651, 10510, 1521112062, '8780,10510'),
(88129, 466, 1651, 10510, 1521112076, '8780,10510'),
(88130, 466, 1651, 10510, 1521112091, '8750,10510'),
(88131, 466, 1651, 10510, 1521112162, '8750,10510'),
(88132, 466, 1651, 10600, 1521112193, '8750,10600'),
(88134, 466, 1651, 10480, 1521112216, '8750,10480'),
(88135, 466, 1651, 10520, 1521112254, '8730,10520'),
(88136, 466, 1651, 10530, 1521112415, '8770,10530'),
(88137, 466, 1651, 10480, 1521112502, '8760,10480'),
(88138, 466, 1651, 10650, 1521112516, '8760,10650'),
(88139, 466, 1651, 10470, 1521112614, '8740,10470'),
(90193, 466, 147, 10560, 1521484762, '8770,10560'),
(90194, 466, 1714, 10520, 1521484777, '8780,10520'),
(90195, 466, 261, 10620, 1521484783, '8800,10620'),
(90196, 466, 1714, 10510, 1521484800, '8790,10510'),
(90197, 466, 147, 10520, 1521484808, '8770,10520'),
(90198, 466, 1163, 10790, 1521484821, '8760,10790'),
(90199, 466, 2, 10520, 1521484825, '8780,10520'),
(90200, 466, 410, 10500, 1521484838, '8780,10500'),
(90203, 466, 1163, 10780, 1521484865, '8750,10780'),
(90206, 466, 1714, 10550, 1521484936, '8770,10550'),
(90208, 466, 516, 10690, 1521484953, '8950,10690'),
(90209, 466, 261, 10540, 1521484958, '8790,10540'),
(90211, 466, 147, 10530, 1521484980, '8790,10530'),
(90212, 466, 410, 10510, 1521484985, '8770,10510'),
(90214, 466, 516, 10570, 1521485008, '8760,10570'),
(90215, 466, 147, 10460, 1521485016, '8740,10460'),
(90217, 466, 410, 10480, 1521485027, '8740,10480'),
(90219, 466, 410, 10520, 1521485040, '8750,10520'),
(90220, 466, 8, 10560, 1521485050, '8740,10560'),
(90221, 466, 147, 10530, 1521485052, '8740,10530'),
(90222, 466, 516, 10530, 1521485057, '8770,10530'),
(90223, 466, 1163, 10660, 1521485058, '8750,10660'),
(90225, 466, 28, 10470, 1521485066, '8750,10470'),
(90226, 466, 147, 10470, 1521485066, '8730,10470'),
(90227, 466, 147, 10520, 1521485079, '8780,10520'),
(90229, 466, 147, 10490, 1521485104, '8770,10490'),
(90230, 466, 158, 10670, 1521485105, '8780,10670'),
(90231, 466, 2, 10520, 1521485113, '8740,10520'),
(90232, 466, 147, 10540, 1521485117, '8790,10540'),
(90235, 466, 8, 10480, 1521485160, '8760,10480'),
(90236, 466, 147, 10510, 1521485171, '8760,10510'),
(90237, 466, 164, 10670, 1521485185, '8790,10670'),
(90238, 466, 147, 10580, 1521485185, '8770,10580'),
(90239, 466, 1714, 10590, 1521485192, '8800,10590'),
(90240, 466, 8, 10470, 1521485195, '8750,10470'),
(90242, 466, 147, 10510, 1521485210, '8770,10510'),
(90243, 466, 28, 10460, 1521485217, '8740,10460'),
(90244, 466, 147, 10490, 1521485223, '8760,10490'),
(90245, 466, 1163, 10520, 1521485231, '8790,10520'),
(90246, 466, 410, 10520, 1521485241, '8740,10520'),
(90247, 466, 410, 10490, 1521485254, '8750,10490'),
(90248, 466, 365, 10640, 1521485256, '8810,10640'),
(90249, 466, 147, 10500, 1521485258, '8740,10500'),
(90250, 466, 516, 10580, 1521485260, '8800,10580'),
(90251, 466, 28, 10460, 1521485262, '8740,10460'),
(90253, 466, 1714, 10520, 1521485280, '8750,10520'),
(90254, 466, 147, 10460, 1521485284, '8730,10460'),
(90255, 466, 164, 10690, 1521485289, '8770,10690'),
(90256, 466, 147, 10490, 1521485355, '8760,10490'),
(90257, 466, 516, 10530, 1521485355, '8760,10530'),
(90258, 466, 365, 10530, 1521485365, '8790,10530'),
(90262, 466, 365, 10490, 1521485390, '8750,10490'),
(90263, 466, 28, 10500, 1521485403, '8760,10500'),
(90264, 466, 147, 10510, 1521485411, '8760,10510'),
(90265, 466, 410, 10510, 1521485412, '8790,10510'),
(90266, 466, 1163, 10520, 1521485432, '8800,10520'),
(90267, 466, 516, 10510, 1521485448, '8750,10510'),
(90268, 466, 8, 10470, 1521485448, '8750,10470'),
(90269, 466, 365, 10480, 1521485452, '8750,10480'),
(90270, 466, 365, 10530, 1521485466, '8790,10530'),
(90271, 466, 410, 10500, 1521485469, '8740,10500'),
(90272, 466, 516, 10730, 1521485479, '8780,10730'),
(90273, 466, 1163, 10670, 1521485479, '8750,10670'),
(90274, 466, 147, 10470, 1521485481, '8740,10470'),
(90275, 466, 28, 10490, 1521485494, '8760,10490'),
(90276, 466, 2, 10520, 1521485505, '8760,10520'),
(90277, 466, 2, 10470, 1521485520, '8730,10470'),
(90278, 466, 147, 10460, 1521485538, '8740,10460'),
(90279, 466, 147, 10470, 1521485551, '8740,10470'),
(90280, 466, 410, 10550, 1521485563, '8770,10550'),
(90281, 466, 147, 10470, 1521485575, '8750,10470'),
(90282, 466, 410, 10500, 1521485588, '8740,10500'),
(90283, 466, 410, 10500, 1521485601, '8730,10500'),
(90284, 466, 365, 10530, 1521485604, '8770,10530'),
(90285, 466, 147, 10480, 1521485612, '8740,10480'),
(90286, 466, 516, 10500, 1521485613, '8760,10500'),
(90287, 466, 147, 10490, 1521485637, '8770,10490'),
(90288, 466, 516, 10490, 1521485639, '8750,10490'),
(90289, 466, 410, 10500, 1521485652, '8770,10500'),
(90290, 466, 516, 10490, 1521485662, '8740,10490'),
(90291, 466, 28, 10510, 1521485663, '8750,10510'),
(90292, 466, 410, 10520, 1521485665, '8760,10520'),
(90293, 466, 147, 10490, 1521485671, '8770,10490'),
(90294, 466, 2, 10670, 1521485687, '8790,10670'),
(90295, 466, 410, 10490, 1521485689, '8760,10490'),
(90296, 466, 365, 10510, 1521485706, '8760,10510'),
(90297, 466, 1714, 10560, 1521485709, '8770,10560'),
(90298, 466, 28, 10510, 1521485718, '8770,10510'),
(90299, 466, 1714, 10490, 1521485723, '8750,10490'),
(90300, 466, 28, 10500, 1521485732, '8760,10500'),
(90301, 466, 147, 10470, 1521485741, '8750,10470'),
(90302, 466, 147, 10480, 1521485754, '8740,10480'),
(90303, 466, 8, 10650, 1521485755, '8760,10650'),
(90304, 466, 164, 10500, 1521485760, '8750,10500'),
(90305, 466, 365, 10540, 1521485797, '8740,10540'),
(90308, 466, 261, 10580, 1521485846, '8760,10580'),
(90309, 466, 410, 10490, 1521485856, '8750,10490'),
(90310, 466, 164, 10510, 1521485870, '8790,10510'),
(90311, 466, 516, 10480, 1521485873, '8760,10480'),
(90312, 466, 410, 10490, 1521485877, '8750,10490'),
(90313, 466, 28, 10470, 1521485883, '8740,10470'),
(90314, 466, 8, 10480, 1521485890, '8760,10480'),
(90315, 466, 516, 10490, 1521485896, '8750,10490'),
(90316, 466, 2, 10510, 1521485914, '8740,10510'),
(90317, 466, 28, 10500, 1521485931, '8780,10500'),
(90467, 466, 255, 10650, 1521511003, '8770,10650'),
(90469, 466, 255, 10500, 1521511037, '8750,10500'),
(90470, 466, 8, 10510, 1521511163, '8770,10510'),
(90471, 466, 8, 10490, 1521511180, '8770,10490'),
(90473, 466, 255, 10530, 1521511272, '8770,10530'),
(90475, 466, 28, 10520, 1521511284, '8770,10520'),
(90476, 466, 28, 10480, 1521511297, '8740,10480'),
(90477, 466, 28, 10490, 1521511311, '8760,10490'),
(90479, 466, 8, 10480, 1521511416, '8760,10480'),
(90480, 466, 8, 10480, 1521511468, '8760,10480'),
(90481, 466, 28, 10510, 1521511495, '8770,10510'),
(90482, 466, 8, 10520, 1521511680, '8770,10520'),
(90483, 466, 8, 10490, 1521511698, '8770,10490'),
(90484, 466, 8, 10480, 1521511760, '8740,10480'),
(90485, 466, 8, 10470, 1521511800, '8740,10470'),
(90486, 466, 8, 10500, 1521511878, '8750,10500'),
(90487, 466, 28, 10500, 1521512165, '8780,10500'),
(90488, 466, 28, 10450, 1521512189, '8730,10450'),
(90489, 466, 8, 10500, 1521512247, '8780,10500'),
(90490, 466, 8, 10500, 1521512418, '8770,10500'),
(90491, 466, 8, 10500, 1521512444, '8780,10500'),
(90492, 466, 8, 10480, 1521512916, '8760,10480'),
(90493, 466, 8, 10470, 1521513042, '8730,10470'),
(90494, 466, 8, 10480, 1521513366, '8760,10480'),
(90495, 466, 8, 10490, 1521513379, '8760,10490'),
(90496, 466, 8, 10470, 1521513405, '8740,10470'),
(90497, 466, 8, 10480, 1521513418, '8750,10480'),
(90498, 466, 8, 10480, 1521513499, '8760,10480'),
(90499, 466, 8, 10470, 1521513566, '8750,10470'),
(90500, 466, 8, 10470, 1521513638, '8730,10470'),
(90501, 466, 8, 10480, 1521513722, '8750,10480'),
(90502, 466, 8, 10500, 1521513803, '8750,10500'),
(90503, 466, 8, 10490, 1521513838, '8770,10490'),
(90504, 466, 8, 10690, 1521513912, '8740,10690'),
(90505, 466, 8, 10480, 1521514029, '8760,10480'),
(90506, 466, 8, 10490, 1521514164, '8730,10490'),
(90507, 466, 8, 10480, 1521514374, '8750,10480'),
(90508, 466, 8, 10500, 1521514426, '8760,10500'),
(90686, 466, 410, 10540, 1521564789, '8760,10540'),
(90687, 466, 716, 10550, 1521564790, '8770,10550'),
(90688, 466, 410, 10460, 1521564828, '8720,10460'),
(90689, 466, 1535, 10560, 1521564847, '8810,10560'),
(90690, 466, 1535, 10560, 1521564860, '8820,10560'),
(90692, 466, 97, 10540, 1521564897, '8800,10540'),
(90693, 466, 716, 10540, 1521564922, '8790,10540'),
(90694, 466, 97, 10530, 1521564933, '8750,10530'),
(90695, 466, 97, 10490, 1521564947, '8740,10490'),
(90696, 466, 410, 10480, 1521565009, '8730,10480'),
(90697, 466, 716, 10510, 1521565014, '8780,10510'),
(90698, 466, 716, 10530, 1521565053, '8750,10530'),
(90700, 466, 716, 10520, 1521565067, '8750,10520'),
(90701, 466, 97, 10490, 1521565084, '8750,10490'),
(90702, 466, 97, 10520, 1521565097, '8790,10520'),
(90703, 466, 716, 10520, 1521565170, '8800,10520'),
(90704, 466, 410, 10480, 1521565185, '8750,10480'),
(90706, 466, 410, 10480, 1521565230, '8730,10480'),
(90707, 466, 97, 10580, 1521565238, '8820,10580'),
(90708, 466, 410, 10480, 1521565248, '8730,10480'),
(90709, 466, 410, 10500, 1521565263, '8740,10500'),
(90710, 466, 716, 10490, 1521565303, '8750,10490'),
(90711, 466, 410, 10490, 1521565333, '8760,10490'),
(91478, 466, 97, 10510, 1521713978, '8760,10510'),
(91479, 466, 97, 10510, 1521714136, '8790,10510'),
(91480, 466, 97, 10500, 1521714295, '8750,10500'),
(91481, 466, 97, 10670, 1521714430, '8760,10670'),
(91982, 466, 410, 10460, 1521836978, '8740,10460'),
(91983, 466, 410, 10490, 1521837110, '8730,10490'),
(92155, 466, 8, 10450, 1521857118, '8730,10450'),
(92156, 466, 410, 10530, 1521857155, '8780,10530'),
(92157, 466, 410, 10490, 1521857235, '8770,10490'),
(92158, 466, 410, 10490, 1521857310, '8750,10490'),
(92159, 466, 410, 10500, 1521857357, '8750,10500'),
(92160, 466, 410, 10510, 1521857429, '8750,10510'),
(92161, 466, 410, 10510, 1521857529, '8740,10510'),
(92162, 466, 410, 10500, 1521857661, '8750,10500'),
(92163, 466, 410, 10500, 1521857675, '8770,10500'),
(92415, 466, 147, 10530, 1521898161, '8810,10530'),
(92416, 466, 147, 10480, 1521898192, '8760,10480'),
(92417, 466, 410, 10520, 1521898200, '8770,10520'),
(92418, 466, 97, 10610, 1521898207, '8810,10610'),
(92419, 466, 97, 10500, 1521898220, '8770,10500'),
(92420, 466, 147, 10490, 1521898229, '8760,10490'),
(92422, 466, 410, 10570, 1521898271, '8760,10570'),
(92423, 466, 410, 10510, 1521898284, '8770,10510'),
(92425, 466, 410, 10520, 1521898297, '8740,10520'),
(92427, 466, 147, 10490, 1521898365, '8760,10490'),
(92428, 466, 410, 10480, 1521898379, '8750,10480'),
(92430, 466, 410, 10480, 1521898426, '8730,10480'),
(92431, 466, 397, 10610, 1521898428, '8770,10610'),
(92432, 466, 397, 10670, 1521898442, '8740,10670'),
(92433, 466, 410, 10490, 1521898442, '8720,10490'),
(92434, 466, 97, 10500, 1521898443, '8760,10500'),
(92436, 466, 410, 10500, 1521898466, '8740,10500'),
(92437, 466, 397, 10600, 1521898476, '8750,10600'),
(92438, 466, 410, 10470, 1521898479, '8730,10470'),
(92439, 466, 147, 10490, 1521898483, '8730,10490'),
(92440, 466, 410, 10530, 1521898493, '8740,10530'),
(92441, 466, 410, 10480, 1521898518, '8730,10480'),
(92444, 466, 410, 10470, 1521898559, '8720,10470'),
(92445, 466, 147, 10460, 1521898575, '8740,10460'),
(92446, 466, 97, 10490, 1521898581, '8770,10490'),
(92447, 466, 410, 10460, 1521898607, '8740,10460'),
(92448, 466, 147, 10450, 1521898622, '8730,10450'),
(92449, 466, 397, 10650, 1521898632, '8760,10650'),
(92450, 466, 410, 10460, 1521898641, '8740,10460'),
(92452, 466, 97, 10490, 1521898668, '8740,10490'),
(92453, 466, 97, 10470, 1521898682, '8720,10470'),
(92454, 466, 147, 10510, 1521898685, '8750,10510'),
(92763, 466, 97, 10450, 1521918942, '8730,10450'),
(92765, 466, 410, 10500, 1521918983, '8760,10500'),
(92766, 466, 28, 10460, 1521919048, '8740,10460'),
(92767, 466, 147, 10470, 1521919064, '8730,10470'),
(92768, 466, 97, 10550, 1521919069, '8780,10550'),
(92769, 466, 1846, 10760, 1521919095, '8730,10760'),
(92771, 466, 410, 10500, 1521919113, '8740,10500'),
(92772, 466, 147, 10460, 1521919123, '8720,10460'),
(92773, 466, 147, 10500, 1521919149, '8770,10500'),
(92774, 466, 97, 10510, 1521919181, '8790,10510'),
(92775, 466, 410, 10500, 1521919191, '8750,10500'),
(92776, 466, 410, 10460, 1521919239, '8730,10460'),
(92778, 466, 1846, 10460, 1521919267, '8740,10460'),
(92779, 466, 147, 10480, 1521919275, '8730,10480'),
(92780, 466, 147, 10460, 1521919288, '8740,10460'),
(92782, 466, 1846, 10560, 1521919293, '8810,10560'),
(92783, 466, 410, 10460, 1521919343, '8730,10460'),
(92784, 466, 410, 10460, 1521919357, '8730,10460'),
(92785, 466, 1846, 10480, 1521919376, '8750,10480'),
(92786, 466, 97, 10500, 1521919386, '8770,10500'),
(92787, 466, 410, 10450, 1521919404, '8720,10450'),
(92788, 466, 1846, 10500, 1521919438, '8760,10500'),
(92790, 466, 410, 10460, 1521919452, '8720,10460'),
(93101, 466, 114, 10570, 1521972802, '8740,10570'),
(93102, 466, 1552, 10540, 1521972823, '8720,10540'),
(93103, 466, 114, 10520, 1521972854, '8780,10520'),
(93153, 466, 1535, 10760, 1521991445, '8760,10760'),
(93154, 466, 114, 10540, 1521991467, '8740,10540'),
(93155, 466, 410, 10480, 1521991485, '8750,10480'),
(93156, 466, 114, 10500, 1521991532, '8780,10500'),
(93157, 466, 410, 10470, 1521991689, '8740,10470'),
(93158, 466, 114, 10500, 1521991691, '8750,10500'),
(93159, 466, 1535, 10530, 1521991708, '8790,10530'),
(93160, 466, 410, 10460, 1521991735, '8740,10460'),
(93161, 466, 114, 10600, 1521991770, '8810,10600'),
(93162, 466, 410, 10460, 1521991805, '8730,10460'),
(93163, 466, 1535, 10500, 1521991879, '8750,10500'),
(93164, 466, 114, 10480, 1521991918, '8750,10480'),
(93165, 466, 1535, 10500, 1521991951, '8780,10500'),
(93166, 466, 410, 10490, 1521991956, '8750,10490'),
(93167, 466, 1535, 10500, 1521991988, '8770,10500'),
(93168, 466, 516, 10480, 1521992020, '8740,10480'),
(93381, 466, 410, 10470, 1522020798, '8750,10470'),
(93382, 466, 410, 10470, 1522020852, '8740,10470'),
(93383, 466, 410, 10490, 1522020888, '8770,10490'),
(93384, 466, 28, 10460, 1522021042, '8740,10460'),
(93385, 466, 28, 10490, 1522021113, '8750,10490'),
(93386, 466, 410, 10490, 1522021152, '8770,10490'),
(93387, 466, 410, 10470, 1522021199, '8740,10470'),
(93388, 466, 410, 10490, 1522021268, '8740,10490'),
(93389, 466, 28, 10550, 1522021295, '8800,10550'),
(93390, 466, 410, 10490, 1522021315, '8770,10490'),
(93391, 466, 28, 10790, 1522021345, '8820,10790'),
(93429, 466, 1846, 10680, 1522059837, '8790,10680'),
(93431, 466, 1846, 10540, 1522059922, '8740,10540');

SELECT *, from_unixtime(date) FROM `times` WHERE playerID = 147 and challengeID = 466
order by score asc


ID
challengeID
playerID
score
date
checkpoints
from_unixtime(date)


92448
466
147
10450
1521898622
8730,10450
2018-03-24 13:37:02

90215
466
147
10460
1521485016
8740,10460
2018-03-19 18:43:36

90254
466
147
10460
1521485284
8730,10460
2018-03-19 18:48:04

90278
466
147
10460
1521485538
8740,10460
2018-03-19 18:52:18

92445
466
147
10460
1521898575
8740,10460
2018-03-24 13:36:15

92772
466
147
10460
1521919123
8720,10460
2018-03-24 19:18:43

92780
466
147
10460
1521919288
8740,10460
2018-03-24 19:21:28

90226
466
147
10470
1521485066
8730,10470
2018-03-19 18:44:26

90274
466
147
10470
1521485481
8740,10470
2018-03-19 18:51:21

90279
466
147
10470
1521485551
8740,10470
2018-03-19 18:52:31

90281
466
147
10470
1521485575
8750,10470
2018-03-19 18:52:55

90301
466
147
10470
1521485741
8750,10470
2018-03-19 18:55:41

92767
466
147
10470
1521919064
8730,10470
2018-03-24 19:17:44

90285
466
147
10480
1521485612
8740,10480
2018-03-19 18:53:32

90302
466
147
10480
1521485754
8740,10480
2018-03-19 18:55:54

92416
466
147
10480
1521898192
8760,10480
2018-03-24 13:29:52

92779
466
147
10480
1521919275
8730,10480
2018-03-24 19:21:15

90229
466
147
10490
1521485104
8770,10490
2018-03-19 18:45:04

90244
466
147
10490
1521485223
8760,10490
2018-03-19 18:47:03

90256
466
147
10490
1521485355
8760,10490
2018-03-19 18:49:15

90287
466
147
10490
1521485637
8770,10490
2018-03-19 18:53:57

90293
466
147
10490
1521485671
8770,10490
2018-03-19 18:54:31

92420
466
147
10490
1521898229
8760,10490
2018-03-24 13:30:29

92427
466
147
10490
1521898365
8760,10490
2018-03-24 13:32:45

92439
466
147
10490
1521898483
8730,10490
2018-03-24 13:34:43

84757
466
147
10500
1520267091
8770,10500
2018-03-05 16:24:51

84763
466
147
10500
1520267127
8740,10500
2018-03-05 16:25:27

90249
466
147
10500
1521485258
8740,10500
2018-03-19 18:47:38

92773
466
147
10500
1521919149
8770,10500
2018-03-24 19:19:09

84764
466
147
10510
1520267140
8740,10510
2018-03-05 16:25:40

90236
466
147
10510
1521485171
8760,10510
2018-03-19 18:46:11

90242
466
147
10510
1521485210
8770,10510
2018-03-19 18:46:50

90264
466
147
10510
1521485411
8760,10510
2018-03-19 18:50:11

92454
466
147
10510
1521898685
8750,10510
2018-03-24 13:38:05

90197
466
147
10520
1521484808
8770,10520
2018-03-19 18:40:08

90227
466
147
10520
1521485079
8780,10520
2018-03-19 18:44:39

84781
466
147
10530
1520267240
8730,10530
2018-03-05 16:27:20

90211
466
147
10530
1521484980
8790,10530
2018-03-19 18:43:00

90221
466
147
10530
1521485052
8740,10530
2018-03-19 18:44:12

92415
466
147
10530
1521898161
8810,10530
2018-03-24 13:29:21

84751
466
147
10540
1520267068
8780,10540
2018-03-05 16:24:28

84814
466
147
10540
1520267504
8740,10540
2018-03-05 16:31:44

90232
466
147
10540
1521485117
8790,10540
2018-03-19 18:45:17

90193
466
147
10560
1521484762
8770,10560
2018-03-19 18:39:22

90238
466
147
10580
1521485185
8770,10580
2018-03-19 18:46:25

84789
466
147
10590
1520267311
8770,10590
2018-03-05 16:28:31

84794
466
147
10620
1520267344
8830,10620
2018-03-05 16:29:04


SELECT a.*, IF(
          @p = ChallengeId,
          @r := @r +1,
          @r := 1
      ) AS Rank,
      @p := ChallengeId from (SELECT
        MIN(score) AS score,
        ChallengeId,
        playerID, from_unixtime(date)
    FROM
        times
    WHERE
        (
            DATE BETWEEN '1519858800' AND '1522533600'
        )
    GROUP BY
        challengeID,
        playerID
                             ORDER BY
          ChallengeId ASC,
          Score ASC,
          DATE ASC LIMIT 5000000) a, (SELECT
  @r := 0,
  @p := 0
) t 


score
ChallengeId
playerID
from_unixtime(date)
Rank
@p := ChallengeId


10450
466
28
2018-03-02 11:58:42
1
466

10450
466
147
2018-03-05 16:24:28
2
466

10450
466
8
2018-03-05 16:26:24
3
466

10450
466
97
2018-03-05 16:32:02
4
466

10450
466
410
2018-03-19 18:40:38
5
466

10460
466
255
2018-03-06 05:08:26
6
466

10460
466
66
2018-03-09 10:29:20
7
466

10460
466
1846
2018-03-24 19:18:15
8
466

10470
466
2
2018-03-01 16:55:56
9
466

10470
466
944
2018-03-05 10:27:33
10
466

10470
466
47
2018-03-05 16:24:08
11
466

10470
466
599
2018-03-07 08:02:16
12
466

10470
466
1651
2018-03-15 11:03:10
13
466

10480
466
516
2018-03-01 16:58:11
14
466

10480
466
365
2018-03-19 18:47:36
15
466

10480
466
114
2018-03-25 11:13:22
16
466

10490
466
108
2018-03-01 17:01:45
17
466

10490
466
716
2018-03-05 10:28:02
18
466

10490
466
439
2018-03-05 10:28:29
19
466

10490
466
164
2018-03-09 10:45:12
20
466

10490
466
1714
2018-03-14 15:21:19
21
466

10500
466
890
2018-03-02 11:54:42
22
466

10500
466
1585
2018-03-09 16:17:36
23
466

10500
466
1535
2018-03-09 16:24:03
24
466

10500
466
261
2018-03-10 21:19:51
25
466

10510
466
1188
2018-03-05 16:28:42
26
466

10510
466
474
2018-03-14 15:19:55
27
466

10520
466
1163
2018-03-02 11:56:44
28
466

10520
466
1031
2018-03-09 16:21:58
29
466

10520
466
1577
2018-03-13 17:00:16
30
466

10530
466
874
2018-03-04 01:34:15
31
466

10530
466
1588
2018-03-09 16:20:12
32
466

10540
466
1552
2018-03-13 17:06:20
33
466

10550
466
654
2018-03-05 16:25:51
34
466

10600
466
397
2018-03-14 15:23:45
35
466

10610
466
68
2018-03-04 01:33:10
36
466

10670
466
158
2018-03-19 18:45:05
37
466

10750
466
43
2018-03-01 16:54:40
38
466

10780
466
536
2018-03-01 17:01:46
39
466

10780
466
75
2018-03-02 07:04:18
40
466

10790
466
224
2018-03-01 16:59:04
41
466

10790
466
811
2018-03-07 08:05:15
42
466


SELECT MIN(t.ID),t.Score,t.ChallengeId,t.playerID,MIN( from_unixtime(date) )
FROM `times` t inner Join
(SELECT MIN(Score) score,challengeID,playerID 
   from `times` 
   group by challengeID,playerID 
   Order by Score ASC) s
 ON t.challengeID = s.challengeID 
    and t.playerID = s.playerID
    and t.Score = s.score
GROUP BY t.Score,t.ChallengeId,t.playerID
order by t.Score


MIN(t.ID)
Score
ChallengeId
playerID
MIN( from_unixtime(date) )


92155
10450
466
8
2018-03-24 02:05:18

90488
10450
466
28
2018-03-20 02:16:29

92763
10450
466
97
2018-03-24 19:15:42

92448
10450
466
147
2018-03-24 13:37:02

92787
10450
466
410
2018-03-24 19:23:24

86256
10460
466
66
2018-03-09 10:48:16

85201
10460
466
255
2018-03-06 05:13:46

92778
10460
466
1846
2018-03-24 19:21:07

90277
10470
466
2
2018-03-19 18:52:00

84801
10470
466
47
2018-03-05 16:29:41

85724
10470
466
599
2018-03-07 08:07:30

84804
10470
466
944
2018-03-05 16:30:34

88139
10470
466
1651
2018-03-15 11:16:54

93164
10480
466
114
2018-03-25 16:31:58

90269
10480
466
365
2018-03-19 18:50:52

90311
10480
466
516
2018-03-19 18:57:53

84809
10490
466
108
2018-03-05 16:31:08

86254
10490
466
164
2018-03-09 10:47:38

84816
10490
466
439
2018-03-05 16:32:08

84489
10490
466
716
2018-03-05 10:30:10

90299
10490
466
1714
2018-03-19 18:55:23

86724
10500
466
261
2018-03-10 21:19:51

84761
10500
466
890
2018-03-05 16:25:05

93163
10500
466
1535
2018-03-25 16:31:19

86325
10500
466
1585
2018-03-09 16:23:58

87883
10510
466
474
2018-03-14 15:22:36

84790
10510
466
1188
2018-03-05 16:28:42

86317
10520
466
1031
2018-03-09 16:22:21

90245
10520
466
1163
2018-03-19 18:47:11

87691
10520
466
1577
2018-03-13 17:06:16

83858
10530
466
874
2018-03-04 01:36:17

86321
10530
466
1588
2018-03-09 16:23:06

93102
10540
466
1552
2018-03-25 11:13:43

84808
10550
466
654
2018-03-05 16:31:03

92437
10600
466
397
2018-03-24 13:34:36

83859
10610
466
68
2018-03-04 01:36:36

90230
10670
466
158
2018-03-19 18:45:05

82472
10750
466
43
2018-03-01 16:59:49

82957
10780
466
75
2018-03-02 07:04:18

82499
10780
466
536
2018-03-01 17:02:00

82463
10790
466
224
2018-03-01 16:59:04

85721
10790
466
811
2018-03-07 08:05:15


SELECT MIN(Score) score,challengeID,playerID from `times` group by challengeID,playerID Order by Score ASC


score
challengeID
playerID


10450
466
147

10450
466
8

10450
466
97

10450
466
410

10450
466
28

10460
466
255

10460
466
66

10460
466
1846

10470
466
47

10470
466
2

10470
466
1651

10470
466
599

10470
466
944

10480
466
516

10480
466
365

10480
466
114

10490
466
439

10490
466
1714

10490
466
108

10490
466
164

10490
466
716

10500
466
261

10500
466
890

10500
466
1585

10500
466
1535

10510
466
474

10510
466
1188

10520
466
1577

10520
466
1163

10520
466
1031

10530
466
874

10530
466
1588

10540
466
1552

10550
466
654

10600
466
397

10610
466
68

10670
466
158

10750
466
43

10780
466
536

10780
466
75

10790
466
224

10790
466
811

ID	challengeID	playerID	score	date	checkpoints	from_unixtime(date)
92448	466	147	10450	1521898622	8730,10450	2018-03-24 13:37:02
90215	466	147	10460	1521485016	8740,10460	2018-03-19 18:43:36
90254	466	147	10460	1521485284	8730,10460	2018-03-19 18:48:04
90278	466	147	10460	1521485538	8740,10460	2018-03-19 18:52:18
92445	466	147	10460	1521898575	8740,10460	2018-03-24 13:36:15
92772	466	147	10460	1521919123	8720,10460	2018-03-24 19:18:43
92780	466	147	10460	1521919288	8740,10460	2018-03-24 19:21:28
90226	466	147	10470	1521485066	8730,10470	2018-03-19 18:44:26
90274	466	147	10470	1521485481	8740,10470	2018-03-19 18:51:21
90279	466	147	10470	1521485551	8740,10470	2018-03-19 18:52:31
90281	466	147	10470	1521485575	8750,10470	2018-03-19 18:52:55
90301	466	147	10470	1521485741	8750,10470	2018-03-19 18:55:41
92767	466	147	10470	1521919064	8730,10470	2018-03-24 19:17:44
90285	466	147	10480	1521485612	8740,10480	2018-03-19 18:53:32
90302	466	147	10480	1521485754	8740,10480	2018-03-19 18:55:54
92416	466	147	10480	1521898192	8760,10480	2018-03-24 13:29:52
92779	466	147	10480	1521919275	8730,10480	2018-03-24 19:21:15
90229	466	147	10490	1521485104	8770,10490	2018-03-19 18:45:04
90244	466	147	10490	1521485223	8760,10490	2018-03-19 18:47:03
90256	466	147	10490	1521485355	8760,10490	2018-03-19 18:49:15
90287	466	147	10490	1521485637	8770,10490	2018-03-19 18:53:57
90293	466	147	10490	1521485671	8770,10490	2018-03-19 18:54:31
92420	466	147	10490	1521898229	8760,10490	2018-03-24 13:30:29
92427	466	147	10490	1521898365	8760,10490	2018-03-24 13:32:45
92439	466	147	10490	1521898483	8730,10490	2018-03-24 13:34:43
84757	466	147	10500	1520267091	8770,10500	2018-03-05 16:24:51
84763	466	147	10500	1520267127	8740,10500	2018-03-05 16:25:27
90249	466	147	10500	1521485258	8740,10500	2018-03-19 18:47:38
92773	466	147	10500	1521919149	8770,10500	2018-03-24 19:19:09
84764	466	147	10510	1520267140	8740,10510	2018-03-05 16:25:40
90236	466	147	10510	1521485171	8760,10510	2018-03-19 18:46:11
90242	466	147	10510	1521485210	8770,10510	2018-03-19 18:46:50
90264	466	147	10510	1521485411	8760,10510	2018-03-19 18:50:11
92454	466	147	10510	1521898685	8750,10510	2018-03-24 13:38:05
90197	466	147	10520	1521484808	8770,10520	2018-03-19 18:40:08
90227	466	147	10520	1521485079	8780,10520	2018-03-19 18:44:39
84781	466	147	10530	1520267240	8730,10530	2018-03-05 16:27:20
90211	466	147	10530	1521484980	8790,10530	2018-03-19 18:43:00
90221	466	147	10530	1521485052	8740,10530	2018-03-19 18:44:12
92415	466	147	10530	1521898161	8810,10530	2018-03-24 13:29:21
84751	466	147	10540	1520267068	8780,10540	2018-03-05 16:24:28
84814	466	147	10540	1520267504	8740,10540	2018-03-05 16:31:44
90232	466	147	10540	1521485117	8790,10540	2018-03-19 18:45:17
90193	466	147	10560	1521484762	8770,10560	2018-03-19 18:39:22
90238	466	147	10580	1521485185	8770,10580	2018-03-19 18:46:25
84789	466	147	10590	1520267311	8770,10590	2018-03-05 16:28:31
84794	466	147	10620	1520267344	8830,10620	2018-03-05 16:29:04

score	ChallengeId	playerID	from_unixtime(date)	Rank	@p := ChallengeId
10450	466	28	2018-03-02 11:58:42	1	466
10450	466	147	2018-03-05 16:24:28	2	466
10450	466	8	2018-03-05 16:26:24	3	466
10450	466	97	2018-03-05 16:32:02	4	466
10450	466	410	2018-03-19 18:40:38	5	466
10460	466	255	2018-03-06 05:08:26	6	466
10460	466	66	2018-03-09 10:29:20	7	466
10460	466	1846	2018-03-24 19:18:15	8	466
10470	466	2	2018-03-01 16:55:56	9	466
10470	466	944	2018-03-05 10:27:33	10	466
10470	466	47	2018-03-05 16:24:08	11	466
10470	466	599	2018-03-07 08:02:16	12	466
10470	466	1651	2018-03-15 11:03:10	13	466
10480	466	516	2018-03-01 16:58:11	14	466
10480	466	365	2018-03-19 18:47:36	15	466
10480	466	114	2018-03-25 11:13:22	16	466
10490	466	108	2018-03-01 17:01:45	17	466
10490	466	716	2018-03-05 10:28:02	18	466
10490	466	439	2018-03-05 10:28:29	19	466
10490	466	164	2018-03-09 10:45:12	20	466
10490	466	1714	2018-03-14 15:21:19	21	466
10500	466	890	2018-03-02 11:54:42	22	466
10500	466	1585	2018-03-09 16:17:36	23	466
10500	466	1535	2018-03-09 16:24:03	24	466
10500	466	261	2018-03-10 21:19:51	25	466
10510	466	1188	2018-03-05 16:28:42	26	466
10510	466	474	2018-03-14 15:19:55	27	466
10520	466	1163	2018-03-02 11:56:44	28	466
10520	466	1031	2018-03-09 16:21:58	29	466
10520	466	1577	2018-03-13 17:00:16	30	466
10530	466	874	2018-03-04 01:34:15	31	466
10530	466	1588	2018-03-09 16:20:12	32	466
10540	466	1552	2018-03-13 17:06:20	33	466
10550	466	654	2018-03-05 16:25:51	34	466
10600	466	397	2018-03-14 15:23:45	35	466
10610	466	68	2018-03-04 01:33:10	36	466
10670	466	158	2018-03-19 18:45:05	37	466
10750	466	43	2018-03-01 16:54:40	38	466
10780	466	536	2018-03-01 17:01:46	39	466
10780	466	75	2018-03-02 07:04:18	40	466
10790	466	224	2018-03-01 16:59:04	41	466
10790	466	811	2018-03-07 08:05:15	42	466

MIN(t.ID)	Score	ChallengeId	playerID	MIN( from_unixtime(date) )
92155	10450	466	8	2018-03-24 02:05:18
90488	10450	466	28	2018-03-20 02:16:29
92763	10450	466	97	2018-03-24 19:15:42
92448	10450	466	147	2018-03-24 13:37:02
92787	10450	466	410	2018-03-24 19:23:24
86256	10460	466	66	2018-03-09 10:48:16
85201	10460	466	255	2018-03-06 05:13:46
92778	10460	466	1846	2018-03-24 19:21:07
90277	10470	466	2	2018-03-19 18:52:00
84801	10470	466	47	2018-03-05 16:29:41
85724	10470	466	599	2018-03-07 08:07:30
84804	10470	466	944	2018-03-05 16:30:34
88139	10470	466	1651	2018-03-15 11:16:54
93164	10480	466	114	2018-03-25 16:31:58
90269	10480	466	365	2018-03-19 18:50:52
90311	10480	466	516	2018-03-19 18:57:53
84809	10490	466	108	2018-03-05 16:31:08
86254	10490	466	164	2018-03-09 10:47:38
84816	10490	466	439	2018-03-05 16:32:08
84489	10490	466	716	2018-03-05 10:30:10
90299	10490	466	1714	2018-03-19 18:55:23
86724	10500	466	261	2018-03-10 21:19:51
84761	10500	466	890	2018-03-05 16:25:05
93163	10500	466	1535	2018-03-25 16:31:19
86325	10500	466	1585	2018-03-09 16:23:58
87883	10510	466	474	2018-03-14 15:22:36
84790	10510	466	1188	2018-03-05 16:28:42
86317	10520	466	1031	2018-03-09 16:22:21
90245	10520	466	1163	2018-03-19 18:47:11
87691	10520	466	1577	2018-03-13 17:06:16
83858	10530	466	874	2018-03-04 01:36:17
86321	10530	466	1588	2018-03-09 16:23:06
93102	10540	466	1552	2018-03-25 11:13:43
84808	10550	466	654	2018-03-05 16:31:03
92437	10600	466	397	2018-03-24 13:34:36
83859	10610	466	68	2018-03-04 01:36:36
90230	10670	466	158	2018-03-19 18:45:05
82472	10750	466	43	2018-03-01 16:59:49
82957	10780	466	75	2018-03-02 07:04:18
82499	10780	466	536	2018-03-01 17:02:00
82463	10790	466	224	2018-03-01 16:59:04
85721	10790	466	811	2018-03-07 08:05:15