Edits to Commons by WMF Staff by month

This query is marked as a draft This query has been published by Jmorgan (WMF).

Edits to commons excluding the File namespace by WMF staff, bucketed by year and month.

SQL

SELECT EXTRACT(Year from DATE_FORMAT(rev_timestamp,'%Y%m%d%H%i%s')) as `year`, 
EXTRACT(Month from DATE_FORMAT(rev_timestamp,'%Y%m%d%H%i%s')) as `month`, 
COUNT(rev_id) AS staff_edits FROM commonswiki_p.revision_userindex r
INNER JOIN commonswiki_p.page AS p
ON r.rev_page = p.page_id 
WHERE p.page_namespace NOT IN (6) #Commons, File, and User talk namespaces
AND r.rev_actor IN (1975, 2345, 2859, 6573, 10237, 12620, 13250, 13477, 17463, 18055, 18056, 18326, 18391, 21677, 23115, 34789, 35584, 37641, 40079, 41802, 44434, 45458, 45746, 45918, 48112, 49687, 57834, 58445, 60104, 61485, 63405, 63891, 66658, 67167, 69918, 73402, 73489, 74531, 82232, 83741, 84828, 85623, 86867, 86977, 87349, 87424, 88016, 88363, 89094, 89156, 89716, 91245, 94047, 96706, 101779, 116338, 121525, 134527, 134817, 136145, 149610, 152416, 154748, 155216, 155639, 161551, 162317, 167955, 576186, 1065724, 1083231, 1167790, 1347391, 1353956, 1390454, 1410364, 1453591, 1490901, 1496718, 1508299, 1512499, 1523284, 1670080, 1731244, 1732975, 1745556, 1750862, 1754781, 1756241, 1757831, 1776728, 1781636, 1803935, 1808815, 1815241, 1815499, 1829580, 1839777, 1871540, 1871572, 1875727, 1886240, 1911596, 1919065, 1930717, 1935713, 1935725, 1970362, 1981657, 2001054, 2004266, 2018304, 2024570, 2028695, 2045735, 2047601, 2052486, 2062562, 2072998, 2073678, 2076718, 2120053, 2123789, 2133059, 2133265, 2134372, 2144312, 2163478, 2213244, 2214334, 2225522, 2233770, 2237681, 2248402, 2249875, 2259604, 2263963, 2273095, 2273588, 2284109, 2291940, 2297244, 2336504, 2350011, 2370904, 2386505, 2408794, 2414667, 2417071, 2453562, 2475685, 2476444, 2476780, 2476791, 2493691, 2496199, 2497810, 2513590, 2559622, 2587569, 2604420, 2609636, 2610200, 2683498, 2693458, 2707356, 2725309, 2744311, 2747853, 2750286, 2767267, 2807978, 2819176, 2820875, 2829823, 2835946, 2844909, 2871888, 2884698, 2904367, 2929859, 2934637, 2938394, 2960562, 3003689, 3004931, 3007861, 3012061, 3012963, 3026652, 3057224, 3062099, 3073460, 3076591, 3080607, 3087083, 3094392, 3094507, 3112358, 3117961, 3118632, 3125886, 3128188, 3133516, 3146053, 3147754, 3164208, 3178403, 3181258, 3187015, 3187263, 3197099, 3198806, 3224545, 3231498, 3231877, 3234208, 3234460, 3243132, 3247952, 3270578, 3270786, 3298794, 3301621, 3310679, 3351226, 3354288, 3363719, 3384399, 3398715, 3399125, 3405199, 3413606, 3417574, 3421771, 3429773, 3469654, 3484880, 3504303, 3521150, 3544520, 3582784, 3629034, 3645705, 3648818, 3651440, 3662713, 3666126, 3668553, 3672445, 3712011, 3719612, 3743280, 3750229, 3752737, 3792601, 3808818, 3834642, 3837942, 3842877, 3846825, 3856276, 3918703, 3939364, 3939658, 3947000, 3963229, 3965295, 3968046, 3972968, 4017493, 4024435, 4052780, 4071168, 4075584, 4102240, 4102805, 4122528, 4132289, 4142897, 4155746, 4170444, 4182925, 4185252, 4185464, 4190382, 4191313, 4202373, 4206908, 4210373, 4210635, 4216342, 4217035, 4230704, 4236888, 4239078, 4247193, 4251240, 4251797, 4252089, 4252405, 4255982, 4260684, 4274877, 4275153, 4278453, 4283554, 4284278, 4284334, 4284551, 4296503, 4299848, 4314352, 4319980, 4323784, 4341626, 4345392, 4355071, 4357241, 4357261, 4364449, 4367436, 4378189, 4384332, 4384643, 4384893, 4402538, 4402844, 4412129, 4414037, 4419260, 4419318, 4435720, 4437390, 4438321, 4438960, 4440237, 4448289, 4450392, 4468641, 4480722, 4489296, 4489332, 4489496, 4504406, 4567813, 4569960, 4569963, 4570086, 4570592, 4573781, 4577472, 4592214, 4617743, 4629658, 4629905, 4632946, 4636567, 4639564, 4649951, 4652824, 4655617, 4666476, 4708489, 4716637, 4725662, 4725756, 4736576, 4772566, 4810645, 4818850, 4819200, 4820082, 4829262, 4834829, 4872476, 4894861, 4896289, 4896486, 4898576, 4902750, 4903522, 4907246, 4914661, 4922484, 4923320, 4945252, 4945432, 4952353, 4954880, 4968658, 4985167, 4999706, 5002879, 5006336, 5017680, 5023092, 5025286, 5071878, 5083280, 5112149, 5113191, 5114905, 5138436, 5167917, 5180707, 5199930, 5237911, 5245123, 5261189, 5267175, 5267230, 5280029, 5282834, 5299866, 5303502, 5317898, 5320335, 5359565, 5367602, 5369698, 5370246, 5373001, 5381699, 5382918, 5407287, 5413279, 5424686, 5434427, 5456294, 5476403, 5515182, 5543012, 5545761, 5585107, 5599554, 5646572, 5689578, 5709203, 5752184, 5767698, 5770382, 5780431, 5800872, 5808442, 5808460, 5808772, 5829718, 5832657, 5855577, 5861817, 5864167, 5890982, 5926741, 5952860, 5980972, 5983765, 5984034, 5985135, 5993853, 6029099, 6041508, 6045267, 6045757, 6064521, 6073951, 6081474, 6099692, 6101515, 6105357, 6108991, 6110447, 6122137, 6122913, 6131532, 6157749, 6159671, 6170115, 6174402, 6174609, 6231176, 6242577, 6273950, 6306022, 6352580, 6354025, 6369354, 6378111, 6398189, 6412246, 6433827, 6444262, 6444369, 6444402, 6444718, 6444858, 6445032, 6445421, 6445780, 6446155, 6446270, 6447012, 6447061, 6447120, 6447852, 6448306, 6450076, 6457654, 6458749, 6482081, 6486398, 6496207, 6547368, 6572987, 6587715, 6587828, 6604188, 6610274, 6623916, 6628526, 6636375, 6642045, 6642151, 6642152, 6665397, 6665469, 6672124, 6692850, 6692879, 6702401, 6707682, 6726844, 6733519, 6736011, 6745974, 6748666, 6751856, 6756030, 6777705, 6777867, 6785808, 6787145, 6790256, 6811218, 6814014, 6819282, 6827094, 6849986, 6874709, 6898454, 6901215, 6904839, 6992482, 6997419, 7008443, 7008991, 7014891, 7050815, 7077604, 7100650, 7144063, 7178775, 7204967, 7212214, 7215917, 7222068, 7252769, 7279738, 7281414, 7290304, 7292427, 7301303, 7303394, 7303812, 7312712, 7313908, 7335404, 7349944, 7362629, 7368318, 7369661, 7385265, 7390680, 7405544, 7408829, 7420944, 7424538, 7440480, 7444352, 7448018, 7456438, 7456497, 7458523, 7470416, 7487322, 7489956, 7494585, 7502394, 7502754, 7507652, 7514009, 7531960, 7926040, 23171953, 23195024, 23211205, 23254215, 23256993, 23271287, 23271805, 23293541, 23310523, 23326865, 23337783, 23348100, 23376144, 23398261, 23422350, 23423512, 23429153, 23430530, 23446902, 23449577, 23471669, 23474531, 23474784, 23489876, 23490450, 23490870, 23495842, 23530075, 23547061, 23549199, 23595072, 23597741, 23613965, 23631768, 23645993, 23646486, 23665016, 23668428, 23671584, 23673219, 23674339, 23688401, 23713238, 23715889, 23734824, 23743123, 23755981, 23761603, 23778408, 23793692, 23799634, 23815347, 23818800, 23829774, 23831919, 23908869, 23909541, 23920610, 23954205, 23963268, 23964084, 23977172, 23981060, 23981230, 24014632, 24084191, 24085885, 24153081, 24198931, 24208628, 24261001, 24266495, 24272042, 24318386, 24340460, 24350609, 24441246, 24472164, 24495754, 24557950, 24572445, 24614779, 24628636, 24724459, 24727670, 24736084, 24744109, 24757782, 24759789, 24759900, 24760433, 24761402, 24765951, 24766859, 24767707) #is a staff account
GROUP BY `year`, `month` 
ORDER BY `year` ASC, `month` ASC;

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