0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for committed Christians, experts in Christianity and those interested in learning more

SELECT u.Id as SO_ID, year(p.CreationDate) as PY, month(p.CreationDate) as PM, Count(*) as Count 
FROM Users u 
inner join Posts p on u.Id = p.OwnerUserId
where u.Id in (
1224374,223910,215200,1108902,633513,2554537,708122,1754,344286,1227343,406289,7426,64334,12252,17373,2759880,1608220,123743,1148505,70876,218882,356788,53715,170407,266536,937222,345188,905093,736,30203,125913,34155,454134,8384,194869,13793,12799,201382,742527,464923,48940,405796,510359,165435,210702,125523,368296,323655,261122,110189,89789,1424361,746010,21362,1024142,21897,748221,211627,57191,423218,419970,1366938,1480820,2363,12604,975090,1628832,530808,733798,984284,250832,688297,99455,175201,763080,538272,156239,116908,4911,597122,66549,109749,287583,778329,793079,364024,1431239,116938,1829950,698590,497418,445322,58,240358,25066,374293,21784,1322962,1231943,299327,1048571,466100,144496,295257,142368,302804,813268,1086938,52136,2864275,259900,310196,283302,752527,77,1323,1481262,36687,9887,497356,631459,553403,796656,724357,2146682,496445,273767,383912,1284,759316,1366033,439317,141822,680578,170876,23855,82599,564181,669989,236192,8061,27581,381422,210908,2469,2359374,691859,646634,1310443,134335,356674,241642,36737,241536,402706,1158844,135978,1440715,39018,12730,1973152,7565,1237,1332389,898810,833696,17917,976314,277256,1401720,427390,942855,1946319,11917,29676,47939,920539,49881,622030,296677,1885896,174971,695874,470477,72908,984226,2848,541091,716118,118224,584846,8311,937718,1376032,1113515,49415,295097,324491,897985,1404332,419875,7714,992184,16524,902729,105604,1324320,1667256,174578,1686485,110088,93995,347487,1700256,191846,90777,351207,3937,207291,850326,87960,435460,2894,454586,266795,2489497,10018,2220,188702,155387,781754,386856,1332690,13433,8507,88485,14065,203747,46076,1170489,137598,210070,113719,151212,1060207,490498,3963,169277,1370195,74152,523215,132401,4050,456735,825342,2119660,1106671,3653034,29,1168038,236455,984335,856790,293681,87629,1569983,297696,1563012,179328,133701,538216,102225,173480,45816,8020,74053,35566,8171,1399567,2133271,89218,26566,400675,329921,616937,417513,99907,2247344,2792630,909651,628864,868718,117801,139705,1891,17,1474,1110395,3822499,1169959,1146987,10571,362065,2016353,64313,19856,188473,22467,37776,82159,514866,119262,3831401,204,173768,18392,3475,8718,717027,1203388,274519,10612,194957,110463,3114,353632,2062384,3022,2232695,1071951,26227,16998,112682,866273,80663,85309,577704,791345,1154262,278326,1885892,309733,50776,4858,1796673,296703,39666,25690,1021426,570918,2003420,2397883,1663621,45914,165017,350951,329769,24193,328968,179311,1189769,305,18475,725957,244454,1489051,1843849,1207508,266804,11023,5651,959,1564201,396318,489003,979315,506556,51270,482999,633210,23763,983127,379593,878701,196626,82118,1133145,73342,55954,878903,68172,122164,25188,422869,51055,1604579,2733272,773869,151495,423599,431053,917053,16787,1135427,163751,13968,4853,418832,1011919,550975,619891,187986,101203,371228,21461,633440,95022,319741,63147,1766435,1525358,41153,136194,487883,1682038,433929,176837,142223,17847,2827152,576975,29394,1319434,562990,1308994,203583,67808,371071,64690,1354590,631619,957500,950252,71391,264970,236255,12880,811335,1240745,1111732,55862,201991,942905,2476137,1065868,94092,362871,2450607,407403,885081,89761,465368,108857,73446,536986,1010887,620237,1404311,407906,375670,219912,425756,666752,100112,740597,1238702,250798,3614,111243,184100,791178,802407,665947,531644,222356,235145,120,467690,751504,1669499,190189,58656,1256179,50038,2410991,1541708,949704,59975,568389,208513,37843,417872,1177407,1575654,31455,234830,87862,246044,725403,790075,634336,481231,1031892,100875,159145,8223,998395,651924,24638,1649762,239567,135655,1375689,16645,410457,291640,30850,9822,699057,1452554,968201,3240,2452678,81019,338435,794,241204,71,1411000,283895,299408,384110,356218,2590,1822675,1090568,411216,2676,502676,1338999,7072,1461068,23947,518930,1272944,1067211,85064,809198,160971,366114,3340,823967,437226,214302,29771,907926,722427,6010,178651,53001,29068,98877,412507,798792,101318,446591,240980,385966,631438,937006,2961,37482,385986,26180,1896124,255955,731,1922144,778430,827452,393911,517733,971592,4418,1374007,227646,20471,1132889,344477,5458,115049,1546330,1017787,400914,168738,1031205,1944367,1134899,1072106,627047,262875,958104,655251,209103,251008,14877,406,209050,628943,965495,151382,524708,3765,105570,571758,777247,423228,603281,117625,88340,334743,1589074,276250,778889,1154998,852103,250385,223147,1992,894449,13468,241646,102371,336862,1480060,415554,104816,509934,1876971,872150,29002,197684,402436,1044792,1600696,250290,205426,666188,1864267,698978,1162102,1761970,1727181,95589,184743,7492,1008891,203876,17815,16204,564761,1738941,683321,74291,135021,15882,865416,463785,1197952,428908,559884,207007,1560353,586750,1070506,63074,592839,802397,52589,630588,1935144,3575,23934,16609,1253390,19556,731285,866021,67,1913833,251094,666790,2128,677526,132528,27462,168703,708810,1038783,828290,94416,27025,446487,590107,182801,312124,914695,187404,223370,3310890,447922,775,198324,29825,1026980,912882,271177,133616,222367,265046,598531,2030983,148647,116853,330204,634769,490744,14122,705245,263359,85773,114454,316891,90890,2479962,834192,866296,1106339,337,218248,103297,312260,41321,478288,2789029,2372767,1413881,311339,110026,488563,112765,305530,766511,841096,2300,1042997,1713313,9660,700372,1089452,251983,57719,540981,924,1642688,120052,159607,375646,121379,178758,395495,656010,213902,538253,830035,1184256,116710,349179,37205,27816,799755,167797,607055,265022,78053,249078,303154,76,439755,970346,506952,1154098,39437,131951,336623,197364,887078,96707,185319,1137738,416549,149458,265609,47908,585637,1029936,57787,24730,106342,2637,940936,2595,264676,9209,1731686,102514,105924,442695,275593,5377,628859,9652,1020114,105101,338600,942147,320584,1216334,2437923,138693,9431,109589,1199801,476982,1263015,506507,643383,186762,134668,1308682,91632,627356,1178519,2502125,11507,528405,141080,3321069,275491,176021,90155,643821,1615761,213816,3767,1004119,1954,120930,1148564,212343,906442,239394,101095,11577,226388,1947065,1755158,3857,717268,92876,623949,1356446,1217671,1054558,62401,1368385,344578,1620588,523135,634386,1454135,151501,61130,1007714,2812249,1063392,1293320,153861,954,2620715,8211,2719178,28686,136865,906974,2872551,25855,1152664,1683867,21388,89177,678687,407513,2124709,366464,434546,1623304,106550,9143,114359,1459442,473688,373542,454697,174601,558352,3452,1031372,554241,1288,1567581,27358,63013,3666800,503527,630407,1317965,1695398,54680,264712,59753,369775,412339,527206,62505,177633,1869343,311304,1945,359226,2555,1787669,36464,1806289,1310408,84041,22118,551436,1876138,62601,1198713,538729,1366860,892454,73012,19370,500274,1459114,157136,164392,575029,209406,94892,198291,4907,147510,508681,938263,357986,3622,111033,984658,158755,370,283788,899796,279566,1441955,1235975,70235,277079,1169597,180857,936786,875311,2154,1825057,1200805,126659,102590,1373795,3347,12734,120673,912935,1170095,3696,2159516,900762,280671,210559,22994,547238,1202501,6946,1147002,582386,152335,37422,638597,63030,1093248,253514,194904,1233376,1529843,60276,573421,607050,156061,18831,1649198,1317927,348314,597506,1867759,854930,97337,100988,2413651,269883,684037,555,1166285,715454,366755,77914,600522,249313,86018,329874,503945,59017,4273,51500,185973,289068,6013,74021,1961800,56076,1586229,90305,85733,260189,220600,2635,1992193,120731,359287,403540,4257,2444226,135157,737286,1446448,224186,160990,656833,267878,199397,132042,1510185,983929,56555,589248,254187,771928,1333686,80656,133974,408193,629057,179335,1218727,1490196,237238,652807,240313,1213720,2158663,227699,33194,110762,850882,2117395,8964,1623359,774,728086,576369,2624159,78182,1968099,81112,391999,979120,206493,351084,1832856,208281,419831,671468,24380,229967,703644,397202,940843,2562358,67976,1601531,446766,2510,651983,586621,241314,27,802674,1146151,691586,2099612,145405,563771,785005,483145,1130374,155224,2745343,941243,78385,1461350,243238,281809,210709,98867,173445,175861,400663,1247,47630,1880100,314042,372694,101855,3290955,204276,582377,83667,204920,524621,359005,1574413,329303,916168,199043,652605,35220,156140,362884,221745,1279443,258586,341703,27565,720502,465895,1971587,1642765,979220,1496807,408027,58856,1036545,975487,571554,87582,199166,805060,1564038,83771,545295,516190,1508245,336423,1218959,11177,2390542,344532,811001,455712,571,139916,101223,308942,2420979,516558,21352,1298998,495154,391072,3261,369540,17230,2044966,2277715,277205,323463,1006504,2280737,175778,264971,260677,1050256,1028139,558776,12895,1165441,223201,190766,120654,218017,10318,1943980,1541276,12348,199217,82320,423544,946922,307,246102,730127,404779,1902864,717630,1090886,1152113,2185,6193,208529,3803234,834319,7526,877115,89594,681493,962289,388006,228373,54468,806986,3333,1560534,2969960,223301,3826560,1475689,2587539,637283,1294624,96233,261188,48146,134063,944616,366091,151200,195550,361954,5000,89493,430061,508813,1108031,418715,868691,178042,1432681,1010025,1003511,2883114,193282,260391,282538,1170964,198514,121375,164966,1316463,645638,2658173,415105,6967,125212,209371,5047,182895,889039,1453907,65180,1401895,54609,904239,302703,179026,144743,105741,654870,122376,81367,339428,226578,514232,942070,1902445,5203,77047,200985,2892706,121668,458548,417980,1594166,757734,236562,886335,833881,3533785,3415,1276462,75215,2015183,90690,1129447,1176168,521912,113452,127769,662565,3596772,52759,814391,360921,1238943,1459532,278836,95049,234723,45668,480970,119978,86708,1076296,695181,213159,737278,241631,1818849,321555,2340657,772156,95462,989851,30896,27915,805704,5247,324529,2687831,269686,158502,175126,495612,74733,53163,53182,291999,42669,942,183341,570040,1200865,410894,1455713,643928,118058,144755,159715,686902,618370,1154538,1407067,1532551,973174,3727176,178060,1445182,623682,121495,244883,2386284,852738,20788,339705,3199927,1188552,2711474,433723,116855,119257,29420,1179380,63477,321764,384164,58876,27482,483432,107468,213259,1011426,12725,1263211,185738,16947,34183,329911,1612176,573595,4933,202324,368626,128581,2415660,48523,1810631,1026289,717965,42182,287415,563118,492317,773702,134300,1094597,179993,1735853,1181561,53687,1125592,704286,117117,75573,737186,7893,95195,813142,1661224,1313536,333082,1435225,1084133,1085051,1919371,182654,1767,1003754,1224550,848931,1250301,399268,1222057,1168577,112794,554546,1431433,621686,364708,1142467,578859,457670,205264,124084,1380,742308,597737,1167750,652715,100506,567499,1498622,1296486,205132,680429,564683,3111,681549,1505262,571881,857238,1412984,455363,136418,381256,949772,1050322,160823,386226,59188,2638959,49893,2026043,224918,3570747,6153,977419,1102855,204927,1483961,1202195,784439,131848,214146,144655,492536,548,3015436,180881,777982,418413,3255740,953327,10093,12958,91768,578116,3087507,1089520,52920,604556,314,1260600,1247107,374420,11062,472021,127019,573432,1612322,640577,875127,476408,456568,667874,413575,877694,45108,33975,183339,1472222,16513,304533,20723,378494,3812932,1591,192819,16865,425495,207868,187367,2145398,420001,54421,1178189,110678,2016450,2137592,1041878,137848,20922,629345,151469,888059,3728283,2820,516719,413622,95506,7267,5192,652486,552840,237942,1275055,1141494,686048,2535870,159548,1165998,272420,912787,158325,229006,2950484,385460,667624,575133,7824,945456,66601,975140,3262870,96140,210530,45696,2259934,909135,18402,82046,847269,249412,62104,418828,2312233,815989,741404,779919,881224,8844,925881,1476464,1401814,1664123,771838,1487071,26130,1162838,873043,1751236,643591,298279,3957,1043380,1152902,1309115,282,335599,503402,1698443,284709,695775,784338,602245,1361399,71519,2246694,901773,1214116,1745689,62600,433890,121713,36693,182365,24862,12243,473395,579461,173019,1834171,1892729,1828408,1943380,2650842,767,59849,340537,1511991,1028230,600622,225014,1377292,797778,710654,48044,710275,59511,2530000,2167692,973126,1579559,253542,1123794,244128,540028,147137,738917,94668,1152809,620622,18159,3780629,407762,3265861,1659187,36057,1154642,879839,392794,208257,3230501,215175,1825269,1157412,192637,2496,4797,51695,5988,433077,337354,195003,804758,2249962,703567,19450,336845,931754,22468,1703505,454485,285,26699,562906,1254937,860525,807131,695186,394484,2636910,650109,697079,339535,105518,2081133,550295,1665872,1009194,16363,826136,30433,9453,3018212,704552,1827539,142474,1140238,15861,202739,970023,275629,89170,1535640,1790,1141076,408974,3965704,577237,327100,30488,918365,1451820,965571,20789,467183,765107,113921,1006050,1949301,27536,1510289,575879,74366,968154,1336699,1726005,858374,20713,12707,1113872,8174,758074,3950,710492,582542,27314,763468,1443490,13064,90413,4233,721276,489280,104096,468904,218098,266261,197655,95869,44636,20265,1204740,1344457,647635,299099,769871,749622,78685,1525799,1672536,113988,1077715,206571,191226,1748769,221392,445303,196759,387347,546654,49956,543467,879420,3396594,1011102,2142228,196439,1470114,1689150,377089,613720,1614717,150,3776408,121363,215166,306003,610665,10156,70417,32128,715913,2234726,2358237,276386,67598,265881,117430,1188479,1721485,3129,1032781,914361,1196031,22452,267505,436078,1346741,1342791,319042,1260077,738512,2472255,2615680,120706,973243,634705,342390,229091,2001511,413863,157830,9470,1887118,151316,1318,152133,21804,183203,843192,3589609,750543,653643,1416050,137067,262298,737995,49922,65563,248224,91748,1638627,287947,125170,657880,1176246,943604,123328,7001,693754,2116153,237401,123827,566561,1154165,1126880,1175947,191450,28585,1134879,97879,1588648,543488,1172780,554327,1440784,681986,302969,113702,669930,759939,1128459,187516,898030,1655496,16015,1361851,296853,1399006,224142,2192786,1546831,634223,499363,1206418,151845,854246,597849,960214,839849,765067,515774,1955990,961045,771735,1255516,1339987,1512892,152061,1491675,597105,572814,93687,1922232,824954,703410,953628,286515,275736,1171796,301304,2184364,2136670,299282,184769,266737,752391,203499,650264,242924,710131,32432,255308,211473,895847,877638,92887,2047962,2507444,966082,344543,461321,1183294,144669,3020198,627446,3029,441739,1412471,263266,176075,1754849,1356721,2826987,353463,1715726,697112,234562,24147,13750,1812984,2429229,31252,151796,22425,1620432,143804,698871,289625,117657,1220,1325440,2335488,962231,2193308,625566,350908,835805,1647312,1281575,218439,737178,39933,2461430,59768,721127,519580,1242271,785326,329291,787250,31049,1324232,835996,3816684,207238,1322393,9861,229045,3590634,3838927,665240,425690,1423787,175627,64023,389899,1368050,549587,464738,3192769,3753754,682480,281572,364123,652259,916757,180445,3298432,2251116,590956,1092956,256793,1860963,75505,5862,176597,918850,371043,1270084,112862,326315,8334,158513,380231,67431,2083968,118912,257808,391762,808734,237211,1208021,515537,1051419,644,88932,537243,3396598,710312,641418,607095,529691,1464282,405971,44815,105794,4281,1154145,136062,682807,843432,2023177,1615910,722367,9073,161644,737234,1570529,1168055,417629,982177,658247,988355,996110,1062366,1439955,128578,413600,2630737,689423,931301,836931,789826,708221,3307951,984214,778587,1475899,668758,135105,965782,288238,55948,1242837,121736,929732,198108,47570,1742028,980655,369892,223175,521060,13379,224288,1631153,2634437,88905,62425,618188,1867398,163149,149212,922168,1180335,3735770,500944,2632240,3361732,1501858,1715138,22939,857029,1129040,1006164,486871,1011213,1267793,103050,214340,1088020,744228,1301147,223826,222185,34426,274553,4352,768893,826530,512280,272923,55589,1142380,1658743,629433,659253,202233,81377,446747,853001,331759,408854,1632200,2593378,2757969,31191,875701,121948,1368547,222381,205610,673984,30016,741892,1152759,85306,12624,72871,424581,21950,535924,1843581,906270,28002,2386185,2209631,103174,1022305,575849,77167,562174,1272776,1338065,258781,185210,751695,1637003,772104,48750,1032785,2848773,370471,244780,18539,5849,12457,267173,479180,31474,1459310,762826,1053756,460940,935950,1491425,65700,130478,1975259,820124,780162,200802,1355117,2705293,416574,1318734,512453,1477333,890012,209108,261642,319479,844726,592535,3116150,12601,518955,982227,374405,73826,264567,341754,428442,524427,41106,1168347,513030,1482044,1686356,777919,408870,456408,1840574,2626509,304299,576195,732765,159571,559633,293515,334519,239790,1049915,88396,1383243,215752,411,205210,525780,893986,892255,176101,990752,338913,153,566189,796538,473232,901395,215120,13932,1475986,1200171,1884004,799769,1102722,1532537,1684740,1228945,914500,23786,738201,203968,935404,1152833,1708801,873263,1062597,1459498,2295834,232243,1074338,2142048,1920188,207359,278464,2660435,985851,154722,409386,339614,70465,1544883,1170559,858015,378045,1507012,155090,328129,506566,2075,54378,1222230,7766,584768,302916,965176,1178890,404289,895305,1224692,570319,751857,682849,1287695,158708,282343,3093524,2565084,2039986,218843,908423,213284,2013906,343291,284685,1664,148736,188415,337455,922401,225584,453912,1134816,269746,3046987,378383,2596586,594316,916994,19421,1149739,51275,982619,203018,129839,132628,25688,961425,3716262,1528581,501825,340358,2631119,174545,1547298,93431,348160,1286692,103843,3507600,1223950,330092,251121,50391,12897,1303785,634574,1751666,2112408,153424,655618,1507843,3659,1718119,115500,1357169,1356465,183110,3007014,64056,437301,1935703,997432,788223,1745901,741858,1526448,679569,1588775,1231953,463535,475992,525532,695987,48405,839960,174001,1076742,241137,1546551,2839733,304542,548266,99021,1021343,1226945,798286,1415348,2767460,614660,79033,597408,783797,443659,525338,2033853,2171102,722332,239645,1628022,1877791,991807,36299,261267,1238586,230437,814458,610533,1876254,64630,132464,363881,772000,804181,1652408,760185,965352,721710,1095011,1059337,135247,78642,1804180,467186,419193,65649,33910,811376,2066320,851135,2096689,515288,704546,28288,63059,551818,64669,55718,1163867,103,699423,227809,17360,740108,265570,1644638,1238257,90278,32384,10067,730,746902,599307,781641,231695,3697311,28721,875305,407731,74359,219155,713890,2747593,3007243,677413,1365936,1510145,217973,1359859,960586,351028,1220932,2848094,167980,186994,1124868,890779,707247,119901,1279574,357811,684410,436976,530055,2295734,1899820,985414,1721440,198663,1730400,21141,100856,359940,526383,1934907,34462,246698,1700352,646577,135683,478893,755254,54384,1761845,60934,749000,1890498,731773,6001,1815853,2777244,163707,297407,301152,1840573,230575,263926,2745072,652728,2627204,323779,1741753,886437,449704,16148,271475,633391,1306895,328344,1400008,19350,86185,1153216,409976,1071366,2808596,727862,451093,1212702,91358,566412,378356,878043,398012,117539,50329,1361711,969922,2134533,2288754,326458,466440,1262832,237917,225088,83927,1303415,244745,60247,232481,1370927,3096451,1284102,584821,376458,334717,809280,40749,754095,875245,277250,1033668,1519003,974063,1636905,272069,507299,130086,277757,61045,835860,312952,178068,3465517,117796,247674,40310,242231,1504385,561624,2250029,240665,239879,1734130,241232,3808623,87356,192529,866408,901433,1236225,2258390,47605,250762,224108,719034,1913543,41728,1524162,46027,599139,850764,1205348,146764,232169,1807595,1098674,978275,1807763,181489,2168085,1113807,3183739,437964,154513,50539,196012,43990,173839,468160,2167315,374845,137776,789462,627272,15851,289156,142213,1459556,204979,393357,856488,1466951,692237,1335395,143305,28400,18228,804147,71489,679449,241754,209867,1549844,1322858,187799,935361,1575185,85414,3023040,2297196,128948,1301364,57954,444134,75780,1050156,1895394,583608,1968736,756246,113797,5630,210832,74711,4455,3195691,813167,209174,228080,2047,1344614,479643,1014975,1822289,2012870,106958,1387668,837090,42633,2324327,1563480,945660,2908048,154048,570445,250100,933682,147613,1836943,2108149,1642041,1608102,137201,779837,1657324,1013822,2104300,402649,457928,333880,652306,239340,1539065,2680503,1363134,216553,421356,9433,477676,505103,975741,1208079,731636,107881,184555,852521,209656,842974,2179,662482,609263,2777235,400715,2120205,59381,26604,156101,961608,35286,1135394,616728,936789,1238387,712208,424303,42357,17871,464064,2658535,198244,95711,745818,2559313,798170,491934,194841,1836159,1153,208035,1050401,751151,341510,5313,1246006,1593947,474690,800194,376645,454196,106797,192217,938312,1453,91993,309545,3423341,812422,315117,388593,2485075,23276,274594,246198,164398,919858,86421,1286667,3009884,1449,704847,677327,543693,14720,627579,926279,1135878,727870,1524858,389552,2318121,644992,1040802,663061,2495028,71066,3482069,3803677,807037,85624,395850,1342487,1755108,5966,338734,1246592,97276,2097381,960978,516229,2555273,2473047,458483,352327,176880,2719837,447619,1469808,843766,291180,704990,18891,106765,142578,747536,609875,519557,18961,251902,399470,1122064,226953,57135,216779,2206839,1017768,474825,94272,243673,182748,324446,161002,2148471,313193,2387970,160256,2015270,848225,1489912,1289454,205345,587953,2135235,1402137,2434812,789782,17324,100776,725866,133474,873058,184077,231844,179157,84768,399111,2679175,125382,83654,3092676,2246506,2171147,365458,1866674,708935,20134,497483,747320,5645,12349,1231840,2321098,573336,1939935,1677610,5953,1727593,2359643,304499,421216,511418,519095,2812317,384724,1630684,584485,1152449,82952,429091,2280576,1406964,1381577,1218630,94607,114994,274701,394282,208030,631079,345600,1535248,12484,510395,675552,197473,498466,228298,792779,2066459,221018,1519241,374658,1704212,881626,1014766,177489,2344714,12830,1895861,1146955,184700,1119597,108928,695999,1628923,936030,2970028,84740,1454911,68701,735496,266609,3116854,176748,233895,160671,1245380,1902010,1006107,938516,432332,961943,49472,107380,1556148,1307245,3596514,108064,11429,2311,605819,1260266,864244,2682662,501856,1088124,591166,602701,104149,181247,1473287,33848,586983,2495290,900961,75095,492701,2038288,1500012,3771,783978,68043,747799,1794846,1584861,324307,7847,1513169,908367,396815,426609,480988,25071,715242,794212,550309,2311664,1112079,992425,503804,3464723,1323052,559371,3426326,152543,17028,51115,53501,2543637,799917,1020819,697582,13097,852561,1042856,2722100,313323,4662,390066,479701,2329993,933810,279713,1422305,570014,1852614,767598,139661,3421247,3286599,391855,682840,112620,423351,616761,534126,1050515,243418,105917,1806825,2522147,921975,171490,586809,677620,565847,763775,1092630,225239,654199,6372,603502,1298864,2879838,1739678,759517,2453020,251287,777884,1285303,697660,92325,133442,2184066,548083,286673,1914,895332,1405258,2701,389096,697449,870996,1925567,877078,535363,1322902,865998,2926686,1514,102009,407782,521846,114514,1756405,2407439,224343,1347326,734479,1305915,1532381,282405,332589,612211,710281,68612,176235,210886,688321,1649780,706905,87123,514061,477399,645533,709163,422080,1589521,381010,792575,1303388,2525460,1487815,663320,675078,88189,826731,953653,700744,436167,788260,1892878,72522,251892,886416,71263,1276505,229891,58530,84805,793140,399304,892903,380592,160828,3530129,1437622,729382,2390655,2200800,381620,2023058,388092,560110,1386324,3434911,9306,1191377,1274859,203883,1133630,265438,839436,1703780,1341139,1403553,868232,419587,470838,1431073,1242785,1046560,1586718,28068,981097,2108018,1289350,1463649,406295,602554,458227,87796,802077,242858,621516,1349074,1030498,1274908,129064,937147,1181761,992018,2619018,1424556,570291,2015662,152730,835636,873472,640423,203766,16593,1092767,97358,503596,297119,552036,1139320,555699,2679800,899048,1337844,469249,437115,839355,3267186,316856,2056338,262262,1293821,718229,503589,1399696,1231827,3154610,914711,659614,412099,590809,1371395,27179,3076888,1316573,341335,341629,923592,512782,1036087,2692003,352485,2626173,44840,47525,778877,1475820,758312,1954236,3248,684926,85776,683200,209920,425523,188567,1464957,352362,2266979,645028,52534,1824639,251096,1403849,595362,32120,343439,167350,3670017,580599,1021177,895733,1308537,672380,177388,1649856,595770,216345,236228,51782,489381,3066911,1570970,3735747,1551741,3482800,226006,176496,22448,1778054,96286,296167,1298400,798138,2855935,714708,597015,2004526,247151,670736,90685,1245804,1477994,676046,1058935,918608,1930838,801325,622129,1467082,1437767,84762,641985,428704,810706,689448,211097,567572,52263,125222,553134,454421,1424450,496220,1046195,262106,2981504,224447,879231,821610,435090,1175932,318741,294435,91196,1124338,162944,2536455,1332394,7424,787958,683205,2680334,98654,205908,449044,1508134,1621476,1267262,2124371,235360,404006,359365,1920391,969967,461954,203720,1646,10223,170381,1204646,746874,786714,104198,695823,424397,1013214,382849,612126,2060125,1212101,1214914,1001985,437566,154680,3939756,21814,643482,1200544,3873934,565514,481275,140396,135787,1134695,3430660,611582,923540,2805425,1054259,982257,55452,1096751,1196339,2290977,1747267,1114,203557,1603383,42685,1624911,1060646,986673,193987,1104684,848360,276328,3524941,492543,75439,433234,792789,3482194,3401,19467,1666183,2288136,244815,697827,680876,1008655,28904,181372,634586,61532,701303,2073796,150136,571563,5319,1535647,1403814,984655,3791581,1172023,2916802,528473,1299234,1467867,2322199,1734072,1608128,11767,1086928,2912714,832312,350094,4773,617653,3728018,304620,465511,592259,1088652,956671,943752,236258,25637,1631587,18779,220889,358692,783043,1055852,732673,1030669,1457552,27153,206644,1433996,623738,111506,159338,951784,2343615,136758,257235,1259985,555425,2288123,250335,1769607,2158269,2800203,894160,537998,391130,870782,623874,1419514,1316483,47274,906424,960102,738746,1795646,556440,383015,42135,1062833,1261365,610775,3102825,178377,1437636,646602,888750,1215133,1712292,43151,1422239,196262,719506,133443,1779682,98828,1353091,868317,507775,265684,177553,156629,1914055,836347,1619747,496103,1243038,1894878,1297059,3598150,101801,799753,1460859,424422,1661150,587920,712886,1715767,2033294,335869,2399138,884410,321589,629521,149078,1384931,12603,61504,2495063,307359,313716,1212291,813154,161369,771978,2365720,2394879,2235531,217126,442820,897291,1641373,1532752,489401,674065,1756892,2418681,81195,374589,859686,659661,527777,1040794,164865,963340,353397,1200336,245859,1269260,1698557,454464,105788,111348,1919858,1792694,1353811,821498,293796,659829,74911,718195,94128,1027808,850353,1612359,2855918,581135,455430,126808,1214655,2249725,3251351,1846065,1830698,2144841,2121659,576335,2125229,8815,1733288,1169813,1997726,1177901,89548,154583,1102246,148673,2930,3329958,780501,945790,3096369,812698,1922553,608419,1747329,2039791,353709,1335233,1840000,364181,2762707,1136565,3576276,1592879,2041893,149239,415943,537083,513031,2425652,1253265,2124389,638972,766040,1202739,150605,793633,618477,655256,1086144,112246,3472643,704791,1123294,459946,1793007,714239,3617318,483815,77352,673430,508608,1877767,2218219,195423,1791801,830077,912712,3326719,1600818,217955,1897261,768847,3512535,1657433,496559,91745,983061,2336637,1378218
)
and year(p.CreationDate)>=2010 and p.PostTypeId=2
GROUP BY u.Id,year(p.CreationDate),month(p.CreationDate)
ORDER BY SO_ID,PY,PM ASC

fork query

edited nov 21 14

created nov 20 14 anonymous