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 user_id FROM user WHERE user_editcount>=200 AND user_id 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
);

-- 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
-- ) 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...
