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

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