Untitled query #38983

This query is marked as a draft This query has been published by Wargo.
SQL

USE plwiki_p;
SELECT MIN(rev_timestamp) AS start, /*rev_actor*/, user_name
 FROM revision JOIN actor ON rev_actor = actor_id JOIN user ON actor_user = user_id
 WHERE rev_actor IN (6, 7, 8, 10, 13, 18, 20, 23, 24, 26, 29, 31, 32, 38, 44, 45, 50, 55, 56, 65, 77, 85, 87, 94, 97, 113, 118, 122, 123, 135, 136, 141, 155, 157, 158, 162, 163, 171, 174, 177, 195, 211, 229, 231, 244, 245, 253, 262, 270, 273, 274, 279, 281, 285, 299, 310, 319, 321, 330, 336, 350, 354, 364, 370, 376, 379, 382, 387, 401, 411, 415, 416, 420, 427, 430, 434, 442, 446, 449, 465, 478, 510, 513, 516, 517, 523, 528, 533, 534, 540, 543, 547, 549, 558, 561, 564, 580, 582, 594, 621, 622, 629, 630, 632, 642, 645, 647, 653, 664, 668, 676, 677, 679, 682, 685, 693, 718, 719, 720, 727, 751, 764, 765, 767, 781, 784, 792, 798, 799, 807, 808, 810, 812, 830, 841, 842, 855, 860, 864, 868, 870, 881, 885, 900, 902, 907, 909, 911, 922, 976, 983, 984, 985, 998, 1007, 1010, 1014, 1027, 1045, 1066, 1067, 1075, 1079, 1084, 1090, 1099, 1137, 1138, 1145, 1147, 1148, 1150, 1156, 1166, 1174, 1178, 1180, 1181, 1191, 1197, 1212, 1217, 1227, 1266, 1314, 1321, 1322, 1323, 1331, 1332, 1346, 1351, 1355, 1368, 1380, 1391, 1403, 1434, 1462, 1475, 1480, 1486, 1497, 1501, 1508, 1527, 1548, 1550, 1555, 1581, 1594, 1619, 1668, 1673, 1674, 1675, 1676, 1679, 1681, 1682, 1693, 1694, 1695, 1696, 1697, 1705, 1711, 1714, 1715, 1762, 1778, 1784, 1805, 1811, 1818, 1821, 1827, 1850, 1870, 1875, 1882, 1892, 1901, 1908, 1940, 1959, 1962, 1977, 2006, 2014, 2053, 2059, 2080, 2090, 2131, 2138, 2165, 2172, 2189, 2205, 2206, 2217, 2218, 2253, 2270, 2338, 2363, 2367, 2392, 2409, 2415, 2417, 2425, 2427, 2430, 2461, 2465, 2475, 2477, 2500, 2505, 2508, 2568, 2625, 2640, 2644, 2649, 2672, 2713, 2761, 2775, 2866, 2923, 2924, 2943, 2951, 2952, 2953, 3041, 3068, 3095, 3130, 3139, 3186, 3192, 3236, 3257, 3282, 3304, 3322, 3368, 3404, 3429, 3477, 3485, 3495, 3502, 3529, 3531, 3561, 3562, 3577, 3787, 3825, 3845, 3873, 3890, 3924, 3935, 3939, 3942, 3944, 3945, 3946, 3948, 3949, 3950, 3951, 3960, 3961, 3962, 3963, 3964, 3966, 3968, 3969, 3971, 3972, 3973, 3975, 3976, 3978, 3979, 3980, 3981, 3982, 3983, 3985, 3986, 3987, 3988, 3989, 3990, 3991, 3992, 3993, 3994, 3995, 3997, 3998, 4000, 4001, 4002, 4004, 4005, 4006, 4007, 4008, 4013, 4014, 4052, 4071, 4085, 4130, 4138, 4182, 4198, 4212, 4226, 4238, 4247, 4257, 4289, 4298, 4305, 4318, 4326, 4332, 4333, 4344, 4366, 4424, 4513, 4549, 4611, 4686, 4744, 4757, 4769, 4771, 4772, 4797, 4869, 4876, 4881, 4898, 4922, 4951, 4952, 5007, 5059, 5121, 5150, 5179, 5194, 5195, 5246, 5249, 5255, 5276, 5291, 5304, 5312, 5315, 5316, 5318, 5319, 5320, 5321, 5341, 5377, 5381, 5495, 5504, 5507, 5544, 5565, 5566, 5629, 5835, 5861, 5943, 5963, 6035, 6049, 6052, 6093, 6182, 6198, 6199, 6200, 6206, 6275, 6280, 6289, 6290, 6291, 6295, 6298, 6299, 6322, 6480, 6574, 6603, 6749, 6750, 6867, 6878, 6944, 7039, 7085, 7141, 7168, 7195, 7277, 7346, 7357, 7391, 7513, 7577, 7579, 7584, 7585, 7587, 7590, 7592, 7598, 7605, 7649, 7650, 7654, 7724, 7734, 7750, 7774, 7775, 7873, 7952, 8166, 8193, 8215, 8337, 8362, 8557, 8652, 8654, 8655, 8656, 8657, 8658, 8659, 8660, 8684, 8686, 8742, 8777, 8786, 8874, 8892, 9250, 9271, 9331, 9339, 9340, 9448, 9489, 9568, 9608, 9646, 9657, 9790, 10048, 10315, 10629, 10826, 10864, 10940, 10951, 11080, 11136, 11405, 11406, 11809, 11852, 11853, 11876, 11894, 11964, 12000, 12019, 12398, 12852, 12864, 13021, 13134, 13136, 13137, 13139, 13144, 13145, 13148, 13166, 13167, 13169, 13175, 13225, 13228, 13240, 13241, 13242, 13243, 13244, 13245, 13535, 13663, 13738, 13841, 14002, 14064, 14256, 14611, 14639, 14717, 14718, 14720, 14846, 14936, 15057, 15313, 15536, 15578, 16190, 16251, 16301, 16565, 16627, 16670, 16672, 16689, 16790, 16799, 16800, 16805, 16853, 17325, 17419, 17719, 17870, 18143, 18339, 18663, 18753, 18868, 18942, 19173, 19237, 19396, 19595, 19711, 19731, 19834, 20477, 21086, 21121, 21398, 21547, 21572, 21682, 21706, 21773, 21961, 21967, 21974, 22328, 22798, 23085, 23086, 23804, 23812, 24202, 24218, 24249, 24250, 24333, 24363, 24435, 24607, 24781, 24782, 24928, 24944, 24945, 24948, 25055, 25666, 25973, 25984, 26141, 26872, 27402, 27621, 27795, 27872, 28070, 28664, 29475, 29484, 29737, 29741, 29746, 29786, 29851, 29878, 29887, 29907, 29924, 29947, 30025, 30026, 30032, 30033, 30036, 31738, 32104, 32566, 32600, 33261, 33287, 33299, 33658, 33659, 33679, 34122, 34397, 34525, 34527, 34530, 34856, 35160, 35535, 35822, 35823, 36052, 36229, 36491, 36950, 37484, 37495, 38071, 38075, 38078, 38079, 38081, 38088, 38090, 38094, 38121, 38125, 38147, 38175, 38184, 38790, 38791, 38796, 38821, 38849, 38850, 38852, 38855, 38857, 38867, 39069, 39501, 39618, 40062, 40480, 40738, 42859, 43015, 43102, 43111, 45008, 45009, 45010, 45012, 45304, 45488, 45846, 45876, 45883, 46000, 46104, 46171, 48915, 49652, 50164, 50279, 50580, 50620, 50726, 50885, 50948, 52083, 52315, 53607, 54716, 54802, 54873, 55962, 56180, 56431, 56438, 56468, 56799, 56832, 56852, 56886, 57615, 57822, 58069, 58361, 58683, 59109, 60699, 60886, 61268, 61322, 61418, 61462, 61678, 62121, 62711, 62952, 63080, 63275, 64047, 64116, 64143, 64224, 64633, 64743, 64767, 64838, 65470, 65521, 66274, 66389, 66476, 66649, 67620, 68407, 69977, 70603, 70760, 71003, 71104, 72806, 73650, 73659, 74252, 74462, 76051, 76481, 77618, 78288, 78366, 78786, 79377, 81158, 81260, 82683, 82812, 83234, 83663, 84994, 85717, 86962, 92171, 94222, 94380, 94906, 94971, 97148, 97722, 98260, 100930, 104622, 104972, 105181, 107572, 108008, 108038, 108490, 108558, 108730, 109311, 109790, 109920, 110812, 110968, 111059, 111498, 112733, 113362, 113514, 113637, 115325, 116497, 117257, 122153, 122436, 122495, 123085, 123305, 124502, 126555, 128006, 130747, 134386, 136402, 136939, 136987, 138586, 143284, 145612, 147901, 149458, 150040, 151813, 154182, 157115, 159098, 160782, 161065, 163377, 175366, 178484, 179425, 183088, 183331, 183791, 185113, 188843, 189168, 190799, 191788, 192435, 194831, 200184, 204379, 208192, 209238, 210696, 211656, 212991, 215293, 216281, 220285, 222495, 223183, 224773, 226425, 228000, 236862, 239488, 242567, 243173, 244418, 249907, 253547, 257559, 257651, 259259, 262012, 271446, 272044, 278485, 289185, 290301, 291282, 291362, 294279, 298559, 310527, 312491, 326212, 328932, 330299, 330794, 331094, 331698, 331908, 334664, 337394, 345094, 348275, 350829, 354371, 370346, 377849, 381710, 386151, 395511, 396782, 400380, 407057, 412961, 413252, 414756, 427800, 428366, 440343, 449340, 449951, 461208, 463655, 482449, 487738, 488451, 503587, 507918, 518070, 520285, 531942, 544486, 544889, 560309, 581917, 582105, 582161, 586144, 622225, 731000, 781040, 781478, 993096, 1009943, 1051523, 1877871)
 GROUP BY rev_actor
WHERE start<'20040829070000'
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
