Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
WTM
.
Toggle Highlighting
SQL
USE plwiki_p; SELECT start, user_name FROM ( 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, 92, 94, 97, 106, 113, 118, 122, 123, 135, 136, 141, 155, 157, 158, 162, 163, 171, 174, 177, 180, 195, 211, 229, 231, 233, 244, 245, 250, 253, 262, 270, 273, 274, 279, 281, 284, 285, 299, 300, 310, 319, 321, 322, 325, 330, 336, 342, 346, 350, 354, 364, 370, 376, 379, 382, 387, 392, 401, 402, 411, 414, 415, 416, 420, 427, 430, 434, 438, 442, 446, 449, 458, 465, 478, 491, 510, 513, 516, 517, 523, 528, 533, 534, 537, 540, 543, 545, 547, 549, 550, 558, 561, 564, 571, 580, 582, 586, 589, 594, 621, 622, 629, 630, 632, 642, 645, 647, 653, 659, 664, 668, 676, 677, 679, 682, 684, 685, 693, 695, 699, 718, 719, 720, 727, 741, 742, 751, 764, 765, 767, 773, 781, 784, 792, 798, 799, 807, 808, 810, 812, 823, 830, 841, 842, 855, 860, 864, 868, 870, 881, 885, 896, 900, 902, 907, 908, 909, 911, 915, 922, 976, 983, 984, 985, 989, 995, 998, 1007, 1009, 1010, 1014, 1027, 1045, 1050, 1064, 1066, 1067, 1075, 1079, 1084, 1085, 1090, 1094, 1099, 1101, 1137, 1138, 1145, 1147, 1148, 1150, 1156, 1160, 1166, 1174, 1178, 1180, 1181, 1183, 1191, 1197, 1209, 1212, 1217, 1227, 1241, 1255, 1266, 1314, 1321, 1322, 1323, 1329, 1331, 1332, 1335, 1338, 1346, 1351, 1355, 1359, 1368, 1380, 1391, 1403, 1434, 1455, 1462, 1475, 1480, 1486, 1497, 1501, 1508, 1527, 1535, 1548, 1550, 1555, 1581, 1594, 1610, 1613, 1619, 1668, 1673, 1674, 1675, 1676, 1679, 1681, 1682, 1692, 1693, 1694, 1695, 1696, 1697, 1705, 1711, 1714, 1715, 1762, 1778, 1784, 1805, 1811, 1818, 1821, 1827, 1834, 1837, 1850, 1870, 1875, 1882, 1892, 1901, 1904, 1908, 1940, 1959, 1962, 1977, 1988, 2006, 2014, 2053, 2059, 2080, 2088, 2090, 2131, 2138, 2164, 2165, 2172, 2189, 2202, 2205, 2206, 2217, 2218, 2253, 2270, 2338, 2349, 2363, 2367, 2389, 2392, 2409, 2415, 2417, 2425, 2427, 2430, 2461, 2465, 2475, 2477, 2500, 2505, 2508, 2550, 2568, 2594, 2625, 2640, 2644, 2649, 2672, 2713, 2761, 2775, 2866, 2906, 2923, 2924, 2943, 2951, 2952, 2953, 2957, 2994, 3019, 3025, 3041, 3068, 3095, 3130, 3139, 3178, 3186, 3192, 3205, 3217, 3236, 3257, 3274, 3277, 3282, 3283, 3286, 3296, 3304, 3321, 3322, 3332, 3368, 3404, 3429, 3477, 3483, 3485, 3495, 3502, 3525, 3529, 3531, 3561, 3562, 3566, 3577, 3670, 3699, 3767, 3774, 3787, 3825, 3830, 3845, 3855, 3873, 3890, 3903, 3924, 3935, 3938, 3939, 3941, 3942, 3944, 3945, 3946, 3947, 3948, 3949, 3950, 3951, 3953, 3960, 3961, 3962, 3963, 3964, 3965, 3966, 3968, 3969, 3971, 3972, 3973, 3974, 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, 4009, 4013, 4014, 4052, 4071, 4081, 4085, 4122, 4130, 4138, 4182, 4198, 4212, 4213, 4226, 4237, 4238, 4247, 4257, 4289, 4298, 4301, 4305, 4318, 4326, 4332, 4333, 4340, 4344, 4356, 4366, 4390, 4424, 4437, 4460, 4513, 4527, 4549, 4611, 4686, 4744, 4757, 4765, 4769, 4771, 4772, 4797, 4814, 4855, 4861, 4869, 4876, 4881, 4898, 4922, 4951, 4952, 4975, 5007, 5037, 5042, 5047, 5059, 5121, 5150, 5177, 5179, 5184, 5194, 5195, 5239, 5246, 5249, 5255, 5256, 5276, 5291, 5304, 5312, 5315, 5316, 5318, 5319, 5320, 5321, 5341, 5373, 5377, 5381, 5387, 5495, 5504, 5507, 5544, 5565, 5566, 5629, 5752, 5796, 5835, 5861, 5865, 5943, 5963, 5966, 6005, 6035, 6049, 6052, 6093, 6182, 6198, 6199, 6200, 6206, 6219, 6273, 6275, 6278, 6280, 6283, 6289, 6290, 6291, 6295, 6298, 6299, 6322, 6328, 6412, 6451, 6480, 6516, 6574, 6603, 6749, 6750, 6751, 6754, 6817, 6867, 6878, 6934, 6944, 7004, 7039, 7085, 7112, 7141, 7157, 7168, 7195, 7222, 7277, 7346, 7357, 7391, 7513, 7553, 7577, 7578, 7579, 7584, 7585, 7587, 7590, 7592, 7598, 7605, 7649, 7650, 7654, 7668, 7687, 7724, 7730, 7734, 7750, 7774, 7775, 7781, 7791, 7873, 7904, 7912, 7952, 7960, 8021, 8166, 8193, 8215, 8253, 8264, 8271, 8326, 8337, 8362, 8557, 8623, 8651, 8652, 8653, 8654, 8655, 8656, 8657, 8658, 8659, 8660, 8684, 8686, 8689, 8704, 8705, 8726, 8727, 8742, 8751, 8777, 8786, 8822, 8836, 8871, 8874, 8892, 8904, 8927, 8933, 8934, 9082, 9086, 9228, 9250, 9271, 9331, 9339, 9340, 9367, 9448, 9462, 9489, 9541, 9547, 9565, 9568, 9601, 9608, 9646, 9657, 9671, 9685, 9704, 9712, 9764, 9790, 9791, 10004, 10048, 10053, 10134, 10164, 10217, 10315, 10518, 10629, 10761, 10769, 10826, 10836, 10864, 10932, 10940, 10951, 11080, 11136, 11327, 11352, 11360, 11405, 11406, 11555, 11584, 11658, 11705, 11809, 11852, 11853, 11876, 11884, 11894, 11964, 12000, 12019, 12080, 12235, 12398, 12690, 12826, 12850, 12852, 12864, 13021, 13051, 13071, 13134, 13136, 13137, 13139, 13144, 13145, 13148, 13166, 13167, 13169, 13175, 13177, 13225, 13228, 13229, 13240, 13241, 13242, 13243, 13244, 13245, 13392, 13535, 13663, 13668, 13738, 13840, 13841, 14002, 14044, 14045, 14064, 14256, 14334, 14611, 14639, 14716, 14717, 14718, 14720, 14846, 14936, 15012, 15057, 15086, 15313, 15427, 15536, 15578, 15581, 15787, 16002, 16188, 16190, 16251, 16301, 16365, 16470, 16555, 16565, 16627, 16670, 16672, 16689, 16724, 16755, 16772, 16790, 16799, 16800, 16801, 16805, 16853, 16929, 17260, 17325, 17333, 17419, 17719, 17870, 18143, 18339, 18627, 18657, 18661, 18663, 18753, 18868, 18942, 18966, 19143, 19171, 19173, 19237, 19243, 19396, 19399, 19487, 19564, 19578, 19595, 19711, 19725, 19731, 19834, 19838, 19954, 20434, 20477, 20628, 21086, 21121, 21147, 21152, 21398, 21511, 21547, 21572, 21638, 21682, 21706, 21773, 21961, 21967, 21974, 21976, 22017, 22079, 22100, 22222, 22234, 22237, 22328, 22541, 22798, 23020, 23065, 23083, 23085, 23086, 23322, 23346, 23804, 23812, 23918, 23931, 24121, 24149, 24155, 24202, 24218, 24244, 24248, 24249, 24250, 24333, 24363, 24367, 24369, 24435, 24463, 24466, 24467, 24607, 24781, 24782, 24894, 24928, 24944, 24945, 24946, 24948, 25055, 25265, 25309, 25666, 25729, 25879, 25973, 25974, 25984, 25994, 26141, 26434, 26435, 26524, 26580, 26719, 26801, 26847, 26872, 27364, 27366, 27402, 27621, 27795, 27872, 27938, 28070, 28130, 28258, 28349, 28355, 28359, 28595, 28597, 28646, 28664, 28729, 29475, 29484, 29737, 29741, 29746, 29786, 29851, 29878, 29887, 29907, 29924, 29947, 30025, 30026, 30029, 30032, 30033, 30034, 30036, 30942, 31584, 31738, 32104, 32249, 32430, 32513, 32566, 32596, 32600, 32935, 33225, 33252, 33261, 33287, 33299, 33589, 33658, 33659, 33660, 33679, 33680, 34072, 34122, 34285, 34310, 34397, 34517, 34525, 34527, 34530, 34708, 34724, 34748, 34856, 34918, 35160, 35535, 35626, 35822, 35823, 35824, 35825, 36052, 36229, 36491, 36514, 36950, 37299, 37484, 37495, 37496, 37767, 38021, 38068, 38069, 38071, 38072, 38075, 38078, 38079, 38080, 38081, 38088, 38089, 38090, 38094, 38121, 38124, 38125, 38131, 38147, 38175, 38184, 38204, 38790, 38791, 38793, 38795, 38796, 38801, 38807, 38821, 38849, 38850, 38851, 38852, 38853, 38854, 38855, 38856, 38857, 38861, 38865, 38867, 39069, 39498, 39501, 39618, 39849, 40062, 40323, 40362, 40480, 40545, 40738, 41363, 42828, 42859, 43015, 43099, 43102, 43109, 43111, 43183, 43261, 43739, 43814, 44333, 44518, 44759, 45008, 45009, 45010, 45012, 45036, 45304, 45376, 45457, 45484, 45488, 45535, 45757, 45774, 45790, 45846, 45876, 45883, 46000, 46104, 46158, 46170, 46171, 46703, 46755, 47140, 47726, 47921, 48915, 48994, 49136, 49652, 49991, 50150, 50164, 50279, 50580, 50620, 50638, 50726, 50885, 50937, 50948, 50972, 51193, 51480, 52073, 52083, 52315, 52486, 52901, 52943, 53092, 53253, 53398, 53607, 53853, 54716, 54802, 54873, 54881, 54882, 54883, 55962, 56001, 56180, 56431, 56438, 56468, 56526, 56623, 56652, 56701, 56709, 56780, 56799, 56832, 56852, 56886, 56908, 56925, 57283, 57615, 57697, 57735, 57761, 57770, 57822, 57838, 57869, 57885, 58069, 58293, 58361, 58384, 58683, 58828, 59109, 59114, 59275, 59327, 59412, 59753, 59792, 59902, 60463, 60533, 60657, 60699, 60886, 60890, 60957, 61143, 61268, 61322, 61418, 61432, 61462, 61547, 61595, 61638, 61678, 61779, 61940, 62121, 62196, 62202, 62347, 62429, 62711, 62767, 62826, 62952, 63080, 63152, 63275, 63333, 63646, 64023, 64047, 64098, 64116, 64143, 64224, 64633, 64743, 64767, 64838, 65342, 65371, 65397, 65470, 65521, 65647, 65736, 65979, 66006, 66017, 66211, 66212, 66274, 66389, 66476, 66594, 66649, 66673, 66819, 66891, 66977, 67063, 67197, 67287, 67374, 67458, 67620, 67717, 67724, 68270, 68364, 68365, 68399, 68407, 68947, 68963, 69057, 69349, 69426, 69459, 69977, 70104, 70415, 70603, 70760, 70926, 70968, 71003, 71104, 71197, 71576, 71607, 71646, 71774, 72200, 72748, 72757, 72778, 72806, 73199, 73381, 73400, 73650, 73659, 74143, 74252, 74283, 74305, 74462, 74875, 75048, 75480, 75528, 75583, 75828, 75871, 75897, 76013, 76051, 76481, 77409, 77447, 77504, 77618, 78046, 78226, 78287, 78288, 78366, 78676, 78786, 79377, 79739, 79794, 80618, 81003, 81093, 81158, 81209, 81260, 81973, 81977, 82142, 82683, 82812, 82815, 83011, 83066, 83137, 83234, 83509, 83574, 83663, 84994, 85014, 85717, 85816, 86272, 86789, 86906, 86920, 86962, 87079, 87627, 88350, 88621, 88916, 89060, 89770, 90159, 90500, 90902, 91563, 91598, 92171, 93102, 93851, 94222, 94333, 94380, 94670, 94875, 94906, 94971, 95695, 96597, 97148, 97722, 97822, 98260, 98291, 98617, 98664, 98805, 99311, 100008, 100489, 100866, 100930, 101227, 101437, 102232, 104622, 104972, 105181, 105654, 107572, 107866, 108008, 108038, 108314, 108490, 108558, 108730, 109085, 109281, 109311, 109790, 109832, 109920, 110349, 110438, 110594, 110699, 110812, 110911, 110968, 111059, 111498, 112141, 112489, 112531, 112549, 112733, 112744, 113362, 113514, 113589, 113637, 113644, 114003, 114315, 115325, 116497, 116891, 117178, 117257, 118731, 119291, 120282, 121659, 121814, 122134, 122153, 122436, 122495, 123085, 123177, 123305, 123455, 124416, 124502, 124665, 125051, 125838, 126476, 126555, 126592, 127075, 128006, 128891, 128899, 129061, 129102, 129212, 129607, 130287, 130607, 130633, 130698, 130747, 131607, 131738, 132188, 132741, 134386, 134587, 134642, 134651, 134868, 135432, 136028, 136402, 136887, 136939, 136987, 138586, 139012, 142919, 143233, 143284, 144725, 145612, 146440, 146891, 147837, 147901, 147998, 148219, 149458, 150039, 150040, 151813, 152778, 154182, 156719, 156800, 157115, 158978, 159098, 159134, 159362, 159544, 160276, 160504, 160782, 161065, 161979, 162014, 162830, 163377, 165348, 167169, 168616, 168784, 172523, 172622, 173415, 174122, 174583, 175366, 176345, 177479, 178031, 178484, 179425, 179959, 180112, 182068, 182249, 182740, 183088, 183331, 183791, 183874, 184593, 184805, 184924, 185113, 185401, 185439, 185871, 186671, 186891, 188001, 188843, 189168, 189668, 190799, 191788, 191871, 191927, 192307, 192435, 193704, 194451, 194631, 194831, 197330, 197807, 198503, 200076, 200184, 201820, 202224, 202925, 204379, 205931, 206255, 207406, 207819, 207971, 208192, 209238, 210409, 210696, 211656, 212242, 212991, 214447, 215293, 216281, 216961, 217302, 220285, 222495, 222522, 223183, 223605, 224493, 224773, 226425, 228000, 228499, 229174, 229643, 230547, 230582, 231079, 232037, 232971, 234343, 234893, 235007, 235940, 236720, 236862, 237612, 237638, 238458, 239488, 239768, 242567, 243173, 243699, 244418, 245991, 245999, 246326, 246595, 247204, 249907, 250596, 250761, 251845, 253502, 253547, 253926, 255644, 257435, 257559, 257651, 258915, 259259, 260320, 261913, 262012, 264863, 266061, 267371, 268505, 268902, 269550, 270136, 271446, 272044, 272936, 274048, 274685, 278485, 279324, 282174, 285655, 286136, 289185, 289306, 289591, 289670, 289750, 290207, 290301, 291222, 291282, 291362, 293340, 293517, 294279, 296094, 296398, 298007, 298039, 298559, 298869, 300732, 301199, 302328, 304396, 305900, 307617, 310527, 312491, 313426, 315186, 315347, 315813, 316381, 316624, 317534, 320325, 322065, 323098, 326212, 328551, 328932, 329494, 330299, 330794, 331002, 331094, 331698, 331908, 332069, 334664, 335514, 336091, 337147, 337394, 338057, 339218, 339426, 340906, 343675, 344572, 345094, 347786, 348170, 348275, 349577, 350829, 352594, 354211, 354371, 356463, 358599, 362997, 364872, 367955, 369574, 370346, 371314, 372180, 377849, 378357, 381710, 382192, 386151, 386342, 389572, 395511, 396782, 396897, 398943, 400380, 402123, 402984, 403360, 404159, 406286, 407057, 412961, 413252, 414756, 416017, 421599, 422046, 426825, 426954, 427800, 428366, 431498, 434324, 436356, 439248, 439451, 440343, 442531, 443150, 449340, 449951, 450392, 453035, 453303, 456402, 457511, 461208, 463461, 463469, 463655, 464885, 466156, 466280, 469292, 470229, 475449, 475857, 477783, 481842, 482449, 487600, 487738, 488451, 490266, 490333, 496246, 496377, 496867, 497539, 498609, 501922, 503587, 507918, 508521, 513101, 517222, 517307, 518070, 520285, 522683, 522820, 523180, 529417, 531896, 531942, 532043, 532163, 544486, 544889, 547895, 549699, 556840, 557105, 559814, 560309, 561033, 580927, 581917, 582105, 582161, 583885, 586144, 587901, 594954, 597244, 599718, 602463, 609410, 614642, 617828, 621388, 622225, 624099, 630527, 638219, 644342, 649113, 652621, 669522, 670338, 677421, 682865, 709867, 731000, 735064, 739563, 749173, 749516, 781040, 781478, 795210, 806563, 821988, 825938, 918002, 989880, 992708, 993096, 1009943, 1011921, 1012423, 1035511, 1040394, 1040700, 1051523, 1055138, 1066681, 1167080, 1207274, 1244945, 1297441, 1337768, 1415509, 1484856, 1877871, 2071087, 2127480, 2200809, 2201695, 2224600, 2606812, 3938276) GROUP BY rev_actor ) AS a WHERE start<'20151110070000' ;
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
.
Checking query status...