wikidata: deleted items listed on covi pages

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

USE dewiki_p;

-- SELECT rev_user, rev_user_text, COUNT(rev_id) AS cnt FROM revision_userindex JOIN page ON rev_page=page_id WHERE rev_timestamp>=20170221000000 AND page_namespace=0 GROUP BY rev_user, rev_user_text HAVING cnt>=50 ORDER BY cnt DESC;

SELECT rev_user, rev_user_text, COUNT(rev_id) AS cnt FROM revision_userindex JOIN page ON rev_page=page_id WHERE rev_user IN (
4, 7, 18, 50, 142, 235, 256, 317, 397, 438, 439, 452, 503, 568, 592, 631, 674, 756, 955, 975, 1145, 1378, 1436, 1442, 1502, 1574, 1614, 1682, 1719, 1748, 1767, 1861, 1861, 1867, 2111, 2161, 2207, 2379, 2581, 2595, 2621, 2953, 2996, 3018, 3026, 3173, 3206, 3232, 3332, 3340, 3406, 3546, 3546, 3653, 3780, 3981, 4074, 4240, 4428, 4472, 4504, 4647, 5088, 5504, 5523, 5539, 6056, 6086, 6190, 6332, 6584, 6726, 6749, 6983, 7087, 7141, 7275, 7327, 7499, 7517, 7564, 7631, 7637, 7671, 7678, 7752, 7810, 7875, 7897, 8145, 8329, 8392, 8392, 8476, 8600, 9012, 9090, 9192, 9346, 9622, 9681, 9787, 9916, 9974, 10164, 10166, 10259, 10276, 10466, 10479, 10662, 10934, 11129, 11167, 11336, 11402, 11409, 11467, 11498, 11790, 11817, 12223, 12393, 12457, 12578, 12659, 12716, 12756, 13036, 13075, 13141, 13177, 13547, 13589, 13598, 13611, 13625, 13677, 14118, 14261, 14269, 14442, 14865, 15219, 15273, 15305, 15579, 15721, 16225, 16280, 16564, 16639, 16801, 16818, 17260, 17302, 17415, 17437, 17810, 18051, 18081, 18158, 18921, 18940, 19578, 19621, 19797, 19870, 20013, 20086, 20199, 20203, 20256, 20294, 20352, 20392, 20649, 20761, 20783, 20978, 21434, 21454, 21732, 22003, 22072, 22243, 22254, 22570, 22612, 23086, 23111, 23347, 23417, 23437, 23636, 23672, 23812, 23832, 24252, 24261, 24480, 24551, 24991, 25174, 25414, 25739, 25749, 26002, 26134, 26274, 26300, 26382, 26928, 26956, 27213, 27640, 27866, 28248, 28433, 28633, 28720, 28816, 28845, 29040, 29258, 29307, 29412, 29416, 29427, 29486, 29519, 29579, 29738, 29776, 29794, 30158, 30431, 30679, 31015, 31087, 31212, 31483, 31492, 31602, 31759, 31785, 32049, 32097, 32102, 32311, 32444, 32546, 32580, 32731, 32767, 32783, 32878, 32945, 32970, 33053, 33262, 33388, 33416, 33503, 33693, 33848, 33894, 34144, 34218, 34225, 34480, 34609, 34611, 34660, 34698, 34759, 34830, 35045, 35162, 35272, 35280, 35543, 35648, 35648, 35676, 35953, 36145, 36147, 36226, 36246, 36360, 36462, 36515, 36728, 36927, 36934, 37000, 37094, 37096, 37117, 37328, 37512, 37528, 37644, 37661, 37879, 37910, 37911, 38176, 38239, 38244, 38262, 38377, 38583, 39066, 39107, 39621, 39772, 39806, 39916, 40182, 40242, 40474, 40667, 40672, 40761, 40784, 40870, 41039, 41118, 41136, 41238, 41268, 41345, 41375, 41392, 41482, 41602, 41876, 42094, 42378, 42674, 42689, 43038, 43067, 43351, 43495, 43681, 43740, 43892, 43893, 44096, 44348, 44391, 44625, 44659, 44825, 44945, 45019, 45262, 45275, 45363, 45468, 45575, 45605, 45633, 45824, 45903, 45933, 45944, 46043, 46051, 46100, 46144, 46288, 46428, 46830, 46931, 47392, 47697, 47717, 47752, 48005, 48213, 48544, 48588, 48724, 48801, 48836, 49010, 49056, 49146, 49203, 49470, 49647, 50217, 50388, 50544, 50674, 50692, 50798, 50922, 50996, 51046, 51459, 51495, 51811, 51840, 51845, 52007, 52132, 52164, 52326, 52555, 52573, 53009, 53228, 53393, 53446, 53620, 53630, 53914, 53968, 53978, 54102, 54109, 54158, 54335, 54486, 54520, 54537, 54681, 54833, 55456, 55519, 55530, 55551, 55586, 55606, 55641, 55765, 56134, 56269, 56380, 56473, 56596, 57003, 57020, 57174, 57228, 57331, 57475, 57559, 58286, 58545, 59279, 59645, 59645, 59691, 59703, 59863, 59977, 60119, 60228, 60510, 60978, 61539, 61568, 61589, 61835, 61890, 62318, 62529, 63248, 63272, 63384, 63470, 63847, 63934, 64083, 64083, 64655, 64751, 64825, 64825, 65311, 65994, 65998, 66181, 66239, 66459, 66535, 66795, 66868, 66956, 67268, 67338, 67513, 67553, 67739, 68075, 68198, 68217, 68633, 68647, 68665, 68876, 69176, 69440, 69518, 70131, 70510, 70560, 70690, 70907, 71145, 71319, 71622, 71781, 71855, 72257, 72487, 72792, 72933, 73068, 73206, 73267, 73374, 73471, 73489, 73659, 73828, 73847, 74155, 74212, 74472, 74472, 74483, 74982, 75115, 75157, 75296, 75448, 75966, 76063, 76079, 76809, 76977, 77053, 77122, 77247, 77827, 77837, 78178, 78249, 78802, 78923, 78927, 79032, 79049, 79075, 79955, 80044, 80088, 80272, 80389, 80720, 80778, 80898, 81126, 81237, 81490, 81528, 81542, 82102, 82268, 82275, 82279, 82299, 82329, 82398, 82471, 82482, 82523, 82594, 82880, 82986, 83039, 83252, 83264, 83682, 83850, 83980, 84100, 84656, 84693, 84806, 84860, 84887, 85794, 85845, 85858, 86029, 86208, 86465, 86572, 86659, 86732, 86839, 87057, 87303, 87477, 87533, 87719, 87821, 88029, 88072, 88415, 88446, 88748, 89215, 89662, 89729, 89813, 89839, 90655, 90689, 90737, 90793, 90811, 91020, 91108, 91626, 91640, 92517, 92846, 92908, 93221, 93464, 93486, 93489, 93628, 93726, 93730, 93861, 94115, 94148, 94220, 94418, 94465, 94593, 94965, 95052, 95052, 95170, 95232, 95386, 95389, 95513, 95974, 96344, 96411, 96533, 96715, 97070, 97361, 97398, 98309, 98778, 99176, 99728, 99749, 99803, 99857, 99962, 100076, 100265, 100308, 100760, 100882, 100912, 101215, 101262, 101521, 101581, 101844, 101913, 102157, 102255, 102327, 102344, 102633, 102753, 102811, 102865, 102902, 102914, 102939, 103542, 103563, 103739, 103925, 104042, 104167, 104680, 104879, 105222, 105256, 105408, 106310, 106507, 106552, 106732, 106798, 106925, 106931, 107812, 107818, 108107, 108135, 108159, 108319, 108395, 108512, 108558, 108994, 108998, 109051, 109064, 109406, 109459, 109890, 110283, 110675, 110681, 111139, 111330, 111732, 112300, 112339, 112805, 112847, 112869, 112874, 113199, 113297, 113799, 114073, 114111, 114282, 114381, 114435, 114511, 114581, 114894, 115049, 115303, 115344, 115481, 115585, 115807, 115924, 116509, 116592, 116812, 116871, 117326, 117429, 117469, 117591, 117646, 118252, 119461, 119494, 119683, 119712, 119729, 119810, 119863, 120181, 120251, 120344, 120637, 120803, 120852, 121104, 121452, 121530, 121562, 121643, 122115, 122780, 122983, 124617, 125106, 125140, 125275, 125451, 125931, 126296, 126420, 126461, 126562, 126649, 126650, 126828, 126937, 126941, 127038, 127051, 127166, 127597, 127694, 127709, 127724, 128330, 128419, 128901, 129401, 129508, 129539, 129565, 129575, 130113, 130113, 130113, 130144, 130498, 130960, 131012, 131105, 131321, 131600, 131684, 131735, 132418, 133031, 133118, 133125, 134152, 134158, 134658, 134664, 135085, 135098, 135151, 135386, 135891, 135966, 136146, 136823, 136825, 137210, 137426, 137566, 137617, 137850, 138009, 138146, 138699, 138957, 139187, 139249, 139283, 139377, 139601, 139806, 140170, 140216, 140257, 140612, 141348, 141439, 141513, 141771, 141777, 141930, 142621, 143352, 143424, 144531, 145562, 145965, 146045, 146053, 146502, 148446, 148702, 148845, 149453, 149634, 149639, 149831, 150004, 152267, 152457, 152809, 153288, 153289, 153697, 153968, 154691, 154724, 155153, 155878, 155952, 156049, 156114, 156577, 157007, 157052, 157146, 157421, 157526, 157527, 157651, 158037, 158264, 158278, 158285, 158844, 158914, 159012, 159132, 159155, 159365, 159467, 159581, 159771, 159975, 160048, 160218, 160484, 160912, 160929, 161010, 161393, 161427, 161862, 162052, 162860, 163840, 164132, 164232, 164664, 164946, 164988, 165049, 165050, 165235, 165320, 165755, 166057, 166121, 166425, 166819, 167022, 167142, 167330, 167394, 167633, 167857, 168120, 168129, 169138, 169273, 169822, 169869, 170055, 170227, 170231, 170360, 170491, 170927, 171060, 171273, 171436, 171707, 171737, 172122, 172343, 172696, 172810, 173009, 173065, 173266, 173414, 173901, 173972, 174019, 174040, 174216, 174542, 174542, 174823, 175151, 175181, 175839, 175866, 175921, 176056, 176071, 176460, 176514, 176555, 176827, 177186, 177286, 177572, 177959, 178175, 178232, 178974, 179007, 179405, 179434, 179669, 179722, 179767, 179800, 179867, 179952, 180272, 180599, 180817, 180827, 181119, 181337, 181366, 181606
) AND page_namespace=0 GROUP BY rev_user, rev_user_text HAVING cnt>=200 ORDER BY cnt DESC;
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...
