Provincia di Lecco, modifiche

This query is marked as a draft This query has been published by Nemo bis.

Per https://meta.wikimedia.org/wiki/Talk:Wikimania_Esino_Lario_-_Protagonismo_culturale_offline_e_online

SQL

USE itwiki_p;
SELECT mese, modifiche
FROM (SELECT SUBSTR(rev_timestamp, 1, 6) AS mese,
   COUNT(rev_id) AS modifiche
   FROM revision
   -- List from https://petscan.wmflabs.org/?language=it&project=wikipedia&depth=5&categories=Provincia%20di%20Lecco&negcats=Nati%20in%20provincia%20di%20Lecco%0D%0AMorti%20in%20provincia%20di%20Lecco&ns%5B0%5D=1&doit=
   WHERE rev_page IN ('675', '3425', '8495', '8614', '9403', '17306', '20980', '20981', '20983', '20984', '20986', '20987', '20988', '20989', '20990', '20993', '20997', '20998', '20999', '21000', '21001', '21003', '21004', '21033', '21035', '21036', '21037', '21038', '21039', '21040', '21041', '21042', '21043', '21044', '21110', '21111', '21112', '21115', '21116', '21119', '21120', '21121', '21125', '21127', '21131', '21132', '21134', '21251', '21252', '21253', '21256', '21258', '21259', '21260', '21262', '21263', '21264', '21268', '21269', '21270', '21273', '21274', '21275', '21277', '21279', '21280', '21281', '21285', '21286', '21289', '21290', '23623', '25459', '40265', '57192', '61041', '63874', '82915', '93259', '94251', '115283', '117411', '123514', '123912', '128099', '133132', '137520', '164685', '178443', '203731', '203744', '203747', '203781', '203788', '203794', '203810', '203811', '203820', '203893', '212695', '225517', '226729', '233516', '234379', '234442', '235197', '246106', '252495', '256099', '256860', '258111', '260108', '261240', '264004', '268737', '268740', '270929', '277515', '285175', '289695', '290536', '300865', '302140', '312884', '314888', '315999', '321569', '328044', '371620', '384118', '401622', '412014', '413874', '420651', '429438', '441817', '441923', '451532', '465531', '466068', '484717', '492901', '493021', '494182', '511347', '512866', '513356', '525675', '527465', '531933', '546565', '552217', '557512', '558673', '562286', '567988', '574481', '578052', '580956', '589723', '593387', '594301', '601585', '608265', '608434', '609745', '614574', '619312', '619947', '627653', '628241', '630083', '643026', '645871', '646759', '646765', '653650', '666045', '674046', '676006', '678411', '682643', '688791', '688919', '689925', '691402', '691803', '692585', '692719', '694473', '695346', '697193', '697651', '699071', '705822', '709142', '711154', '716645', '717302', '736488', '736794', '752808', '756481', '757546', '763594', '764297', '765008', '772260', '773537', '779567', '781261', '789794', '794710', '796391', '799083', '814225', '815007', '815211', '819227', '820613', '820680', '821905', '822500', '822566', '852435', '856019', '864208', '864800', '866908', '871410', '872238', '872264', '872281', '872335', '875041', '892525', '894022', '911796', '916194', '1016181', '1016182', '1016192', '1016197', '', '1057176', '1065092', '1066555', '1067817', '1068332', '1068358', '1068395', '1077844', '1080827', '1080859', '1081931', '1081942', '1083835', '1084443', '1086015', '1086069', '1086315', '1087250', '1090033', '1095888', '1096061', '1096079', '1097639', '1097910', '1098603', '1101829', '1109116', '1113238', '1123529', '1127460', '1135096', '1140335', '1140460', '1140486', '1140500', '1140543', '1167033', '1182434', '1200953', '1215061', '1215300', '1230639', '1230653', '1234642', '1235229', '1235286', '1236148', '1246371', '1246994', '1248038', '1250629', '1250991', '1252774', '1253498', '1253613', '1268292', '1283311', '1283760', '1301704', '1304973', '1305753', '1307522', '1307562', '1312505', '1330982', '1331412', '1333121', '1337132', '1338569', '1341593', '1343362', '1366511', '1384946', '1386099', '1386897', '1391342', '1401188', '1424556', '1426798', '1440947', '1441023', '1452262', '1457530', '1460887', '1463287', '1471051', '1478128', '1485157', '1490403', '1494149', '1495671', '1497920', '1507679', '1509254', '1518659', '1544282', '1544919', '1549583', '1552012', '1560653', '1561844', '1565318', '1567739', '1567766', '1569450', '1570328', '1574565', '1576095', '1578783', '1580287', '1583658', '1587574', '1594181', '1594422', '1597111', '1597177', '1597649', '1598258', '1599295', '1611144', '1611206', '1612205', '1612362', '1626553', '1632471', '1635467', '1635765', '1637018', '1642454', '1642499', '1642522', '1646971', '1647370', '1648012', '1652315', '1655677', '1673792', '1687382', '1687617', '1687732', '1690022', '1693731', '1695458', '1700244', '1703513', '1705840', '1706632', '1709677', '1712360', '1714536', '1714767', '1722334', '1722744', '1723900', '1724555', '1733106', '1733357', '1734504', '1735166', '1736714', '1744298', '1745443', '1745684', '1749460', '1749520', '1751096', '1751377', '1752562', '1753937', '1755139', '1755782', '1761232', '1768180', '1777125', '1789521', '1791722', '1792844', '1794639', '1801247', '1804316', '1805367', '1805480', '1807695', '1811840', '1823073', '1823540', '1828902', '1829686', '1835626', '1846063', '1846110', '1846495', '1847256', '1849706', '1860875', '1872394', '1877297', '1884014', '1884934', '1885490', '1887969', '1892670', '1897948', '1902563', '1910676', '1918331', '1926622', '1935406', '1935505', '1944181', '1948449', '1952901', '1961091', '1965924', '1970402', '1970413', '1974415', '1975306', '1976601', '1977356', '1977759', '1980797', '1992132', '2028880', '2029523', '2031320', '2031539', '2033252', '2033290', '2034704', '2035034', '2035554', '2035958', '2038203', '2044468', '2045065', '2046499', '2048561', '2048759', '2057101', '2058934', '2066951', '2076567', '2081148', '2081441', '2082681', '2091112', '2099139', '2099751', '2102048', '2105146', '2107020', '2112282', '2112537', '2115331', '2120003', '2121824', '2130219', '2142293', '2143877', '2150936', '2151865', '2152402', '2169108', '2176417', '2191757', '2210978', '2218777', '2220331', '2231313', '2238576', '2248732', '2271672', '2281717', '2285297', '2289989', '2309812', '2314797', '2326464', '2332148', '2332158', '2346323', '2350586', '2357791', '2362411', '2370945', '2379246', '2399291', '2405287', '2410395', '2410403', '2424961', '2440913', '2458485', '2459163', '2465138', '2476297', '2481738', '2481792', '2483119', '2484915', '2486727', '2487293', '2495476', '2508139', '2530469', '2532799', '2544437', '2548960', '2549130', '2549687', '2585513', '2589027', '2600796', '2602684', '2604176', '2611340', '2620824', '2621581', '2640598', '2654854', '2659101', '2663145', '2682525', '2684756', '2688261', '2688675', '2690439', '2692484', '2693376', '2697656', '2701667', '2706241', '2709142', '2712225', '2712434', '2726750', '2729752', '2734687', '2773189', '2788419', '2797422', '2797853', '2820542', '2822261', '2822307', '2827941', '2829701', '2846808', '2857742', '2867006', '2880748', '2891727', '2898662', '2905164', '2914330', '2917411', '2917702', '2918026', '2921347', '2924106', '2929656', '2936380', '2946660', '2947911', '2992316', '2996818', '3019803', '3020877', '3021462', '3030236', '3045643', '3052794', '3055228', '3072951', '3075958', '3084700', '3086130', '3087290', '3105259', '3105998', '3106008', '3112753', '3120074', '3129293', '3129490', '3148928', '3149738', '3149762', '3150603', '3150627', '3150654', '3171451', '3176104', '3194494', '3200138', '3203912', '3205505', '3224662', '3227520', '3229149', '3230802', '3231681', '3233225', '3233305', '3233845', '3234731', '3234996', '3235110', '3238686', '3240791', '3241391', '3241712', '3244985', '3255682', '3257321', '3257420', '3257698', '3260110', '3260764', '3261177', '3262569', '3274264', '3275691', '3277620', '3278814', '3292846', '3296248', '3320738', '3324037', '3324075', '3324101', '3324120', '3363003', '3369670', '3386035', '3392799', '3410480', '3452298', '3472193', '3476086', '3510028', '3510923', '3529308', '3572964', '3573400', '3573427', '3573438', '3573449', '3574535', '3574554', '3592874', '3593617', '3593626', '3605648', '3605653', '3617815', '3634367', '3642000', '3650814', '3652394', '3658267', '3660818', '3661093', '3666732', '3667044', '3676454', '3677639', '3677888', '3712902', '3724494', '3727271', '3741723', '3744306', '3746223', '3763477', '3763650', '3805219', '3820390', '3822717', '3826959', '3835967', '3836064', '3840843', '3840851', '3840875', '3840887', '3840903', '3840919', '3848070', '3861088', '3898194', '3898545', '3898611', '3898631', '3898871', '3902391', '3904077', '3906266', '3910044', '3918372', '3932014', '3945237', '3949493', '3950409', '3956081', '3956439', '3961109', '3972428', '3981408', '3990923', '3995853', '3996907', '4000357', '4009532', '4011289', '4013721', '4022850', '4026655', '4027629', '4029794', '4029841', '4034599', '4047444', '4054169', '4075206', '4077910', '4087970', '4088487', '4093129', '4109696', '4114440', '4115002', '4135646', '4140510', '4149762', '4149933', '4149958', '4152829', '4163371', '4173414', '4177998', '4196712', '4199100', '4201608', '4203599', '4203612', '4204088', '4206549', '4213956', '4219721', '4226565', '4234501', '4282439', '4326693', '4331535', '4332342', '4358034', '4368400', '4400858', '4406380', '4410848', '4411300', '4425960', '4436292', '4446907', '4447948', '4449484', '4450530', '4451040', '4463957', '4466395', '4484032', '4495802', '4506530', '4516430', '4533447', '4535716', '4561285', '4571492', '4572225', '4586068', '4602121', '4613399', '4628262', '4633273', '4658643', '4659932', '4661715', '4664406', '4664469', '4668694', '4674887', '4674960', '4678621', '4679055', '4679061', '4682962', '4683821', '4684973', '4685556', '4693468', '4694266', '4694285', '4695137', '4703523', '4704837', '4704856', '4708873', '4709525', '4710613', '4714792', '4728431', '4731957', '4734141', '4739659', '4744124', '4744153', '4759850', '4763963', '4766529', '4772081', '4787633', '4792625', '4798915', '4798954', '4798973', '4799114', '4799123', '4800382', '4801989', '4802141', '4802454', '4806063', '4806095', '4814185', '4820915', '4834189', '4845622', '4893563', '4911381', '4941959', '4977785', '4978540', '4997949', '5003361', '5006724', '5007558', '5011651', '5014284', '5033505', '5034118', '5046196', '5060240', '5061181', '5061349', '5070764', '5070795', '5070913', '5070954', '5071086', '5074016', '5074152', '5103238', '5103260', '5103328', '5107353', '5113840', '5115279', '5118915', '5120349', '5144052', '5149658', '5218198', '5224254', '5226164', '5236337', '5246751', '5246777', '5273208', '5289813', '5292868', '5295554', '5309127', '5328151', '5344926', '5351792', '5356614', '5370234', '5399832', '5403524', '5414422', '5423209', '5432459', '5434137', '5438786', '5442465', '5450167', '5451422', '5467304', '5468389', '5468714', '5481362', '5495270', '5505232', '5515780', '5523390', '5524719', '5524797', '5525250', '5527201', '5527927', '5527992', '5528030', '5528182', '5528214', '5528215', '5529048', '5529192', '5530285', '5531577', '5532564', '5536858', '5537499', '5537594', '5537794', '5537917', '5538020', '5538709', '5538996', '5539061', '5540184', '5540318', '5541393', '5541694', '5541883', '5542431', '5543175', '5543600', '5543886', '5544244', '5552744', '5582409', '5613702', '5614624', '5625872', '5625873', '5625875', '5628296', '5675938', '5717889', '5760508', '5761091', '5802311', '5870932', '5883425', '5885274', '5887649', '5891612', '5891871', '5892310', '5893278', '5893915', '5895342', '5895715', '5901721', '5916069', '5916177', '5916258', '5918791', '5920773', '5931803', '5931835', '5938329', '5941991', '5957180', '6011631')
   GROUP BY mese
   ORDER BY rev_timestamp DESC
) AS revs;

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