Untitled query #53080

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

/*SELECT * FROM revision
LEFT JOIN actor on revision.rev_actor = actor.actor_id
WHERE actor_user IS NULL
AND actor_name NOT RLIKE "^[0-9]{1,3}(\.[0-9]{1,3}){3}$"
AND actor_name NOT RLIKE "^[0-9A-F]{0,4}(:[0-9A-F]{0,4}){2,7}$"
LIMIT 10;*/
SELECT user_id, MAX(rev_timestamp) AS user_lastedit FROM user
LEFT JOIN actor on user.user_id = actor.actor_user
LEFT JOIN revision on actor.actor_user = revision.rev_actor
WHERE user_id IN (3, 15, 18, 30, 63, 70, 77, 95, 149, 179, 197, 204, 207, 208, 250, 455, 489, 633, 638, 697, 720, 744, 830, 832, 1063, 1097, 1113, 1149, 1160, 1177, 1224, 1271, 1305, 1351, 1389, 1427, 1438, 1500, 1504, 1514, 1580, 1632, 1672, 1710, 1732, 1739, 1820, 1921, 1934, 1945, 1970, 2003, 2026, 2031, 2051, 2080, 2098, 2110, 2151, 2153, 2159, 2220, 2268, 2308, 2332, 2394, 2443, 2453, 2487, 2497, 2570, 2595, 2644, 2839, 2862, 2928, 3103, 3366, 3376, 3434, 3459, 3490, 3524, 3527, 3534, 3545, 3552, 3590, 3702, 4129, 4944, 5205, 5350, 5655, 5849, 5954, 5962, 6200, 6216, 6298, 6753, 7247, 7310, 7756, 7800, 8086, 8708, 8997, 9641, 9690, 9723, 10035, 10336, 10453, 11306, 11517, 12371, 13578, 13912, 14109, 14113, 14366, 14606, 14641, 14906, 15212, 15317, 15407, 15431, 15536, 16209, 16619, 16761, 16826, 16881, 16971, 16972, 17313, 18121, 18316, 18327, 18333, 18550, 18736, 18948, 19169, 19402, 20150, 20179, 20848, 20882, 21104, 21311, 21522, 21598, 21852, 22662, 22684, 22895, 23054, 23245, 23545, 23693, 23773, 23844, 23892, 23936, 24024, 24344, 24740, 24899, 25177, 25440, 25546, 25567, 25714, 25868, 25975, 26159, 26244, 26536, 26666, 26728, 27515, 28085, 28350, 28381, 28636, 28743, 28757, 28963, 29174, 29822, 29824, 30294, 30311, 30339, 30378, 30486, 31341, 31361, 31363, 31420, 31654, 32025, 32098, 32215, 32675, 32723, 32959, 32988, 33267, 33430, 33500, 33680, 34184, 34324, 34664, 35345, 35383, 35717, 35841, 36032, 36257, 36300, 36514, 36526, 36601, 36611, 36621, 36680, 37265, 37527, 37539, 37762, 37786, 38118, 38265, 38376, 38389, 38420, 38510, 38748, 38832, 38972, 39098, 39247, 39401, 39458, 39533, 39728, 40177, 40200, 41095, 41202, 41288, 41553, 41722, 41778, 41868, 41963, 41997, 42853, 42968, 42980, 43061, 43229, 43496, 43973, 44089, 44159, 44223, 44709, 44968, 45074, 45174, 45328, 45609, 45627, 46008, 46238, 46390, 46444, 46658, 47157, 47562, 47697, 47923, 48037, 48725, 48728, 49099, 49524, 49674, 50114, 50706, 50874, 51209, 51819, 52045, 52388, 52592, 52899, 53008, 53022, 54047, 54186, 54216, 54763, 55284, 56431, 56595, 56814, 56840, 56943, 57088, 57124, 57601, 57857, 58194, 58225, 58794, 58992, 59414, 59643, 59910, 60068, 60313, 60476, 60574, 60609, 60690, 60703, 60954, 61144, 61302, 61315, 61365, 61754, 61854, 61876, 62160, 62295, 62297, 62418, 62532, 62733, 62996, 63155, 63278, 63624, 63747, 63867, 64385, 64628, 64718, 64895, 64897, 65334, 66000, 66464, 66654, 66980, 67048, 67256, 69275, 69415, 69573, 69878, 69882, 70849, 70917, 71143, 71821, 72278, 72333, 74385, 74706, 75324, 75585, 76026, 76150, 76814, 77361, 78366, 78925, 79211, 79256, 79284, 80433, 80457, 81632, 81679, 82644, 82678, 82820, 83364, 83423, 83431, 83587, 83894, 84051, 84846, 84874, 85762, 85825, 86806, 87705, 87888, 88661, 88703, 89562, 89769, 90755, 91062, 91123, 92354, 92542, 92635, 92711, 93424, 94420, 94519, 94600, 94611, 95188, 95843, 96443, 96906, 97328, 97616, 98169, 98683, 98878, 99361, 99553, 99614, 99959, 99976, 100041, 100341, 101209, 102405, 102595, 104744, 104783, 104816, 105027, 105642, 105745, 107059, 107580, 107762, 107939, 107984, 108410, 108561, 109623, 111086, 112006, 112747, 112906, 113828, 114557, 117336, 117466, 117525, 119483, 119536, 120072, 120501, 121628, 125377, 125617, 125763, 125806, 126920, 126942, 130417, 132093, 132488, 132550, 132627, 133096, 135078, 135723, 135881, 135956, 137744, 139201, 140005, 140228, 140991, 142004, 144160, 144188, 144564, 146998, 147107, 147674, 148134, 148650, 148718, 149304, 149648, 150488, 150707, 150729, 151015, 151545, 153108, 155515, 156684, 156922, 157440, 157680, 157832, 158276, 158579, 160778, 161054, 161258, 161472, 161773, 162069, 163703, 163831, 163989, 164424, 166569, 167065, 167259, 167535, 168204, 168447, 168615, 168624, 171174, 173412, 175843, 176707, 177903, 177950, 179540, 179952, 180206, 180462, 182377, 183184, 183373, 186491, 187500, 187975, 188438, 188453, 188929, 188969, 189052, 189085, 189596, 190936, 191728, 192310, 193001, 193339, 193863, 194408, 194820, 195524, 195580, 195681, 197428, 197717, 197974, 198243, 198732, 198856, 199078, 199311, 199625, 200195, 200322, 201671, 202882, 204476, 205658, 207714, 208115, 208322, 208858, 209012, 214795, 214981, 217001, 217754, 217770, 217973, 219367, 219850, 220065, 220484, 220774, 221534, 221902, 222059, 222394, 222431, 222539, 222974, 223067, 226157, 226195, 226286, 226428, 227002, 227489, 227797, 227991, 228408, 228443, 229097, 229214, 229354, 229680, 229683, 230053, 230444, 232305, 232902, 233853, 234648, 235772, 235820, 235891, 236150, 236969, 237936, 240047, 240690, 242806, 243064, 244801, 245193, 247004, 247434, 248432, 250095, 250848, 251691, 252379, 252684, 254739, 254745, 255544, 255609, 257255, 259469, 260259, 263734, 266126, 266418, 267136, 271511, 272513, 273359, 273797, 274633, 275284, 275360, 275363, 275454, 277684, 278832, 279032, 279447, 281573, 284621, 284758, 288390, 296137, 305854, 308073, 309008, 316212, 316491, 321730, 322190, 323842, 331061, 332011, 334900, 337861, 341104, 341105, 341106, 341107, 341108, 341109, 341110, 341111, 341112, 341113, 341114, 341115, 341116, 341118, 341119, 343550, 344705, 344953, 345626, 345914, 346024, 346058, 346728, 349094, 349141, 349222, 350066, 350739, 350744, 352264, 354671, 354703, 354970, 355352, 356868, 366115, 366691, 367839, 368066, 371419, 375793, 377773, 379737, 380219, 382547, 384054, 384111, 386552, 387421, 389852, 390704, 391532, 393203, 394515, 395902, 399735, 400977, 402232, 402391, 403345, 409912, 424586, 424748, 427269, 438919, 439740, 440976, 442636, 444163, 448463, 448959, 450113, 451651, 453230, 459839, 467397, 473052, 475385, 477986, 478170, 479397, 479399, 479611, 480743, 485596, 485649, 490588, 491226, 492219, 494819, 497940, 509686, 529747, 537763)
GROUP BY user_id, actor_id
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...
