0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

SELECT COUNT(*) AS 'QsAtElection', OwnerUserId
FROM PostsWithDeleted
WHERE (PostTypeId = 1) AND CreationDate BETWEEN '2008-01-01' AND '2011-01-18'
AND OwnerUserId IN (420,423,522,831,891,1088,1133,1321,1394,1477,1561,1702,1719,1892,1973,2006,2451,2608,2640,2697,2929,2936,2937,3117,3181,3211,3407,3445,3590,3851,4004,4166,4226,4267,4288,4574,4718,4923,4943,5116,5191,5216,5277,5445,5721,6165,6282,6326,6403,6475,6649,6682,6727,6803,6897,7028,7154,7293,7297,7759,7841,8146,8758,8761,8766,9116,9664,10156,10157,10258,10264,10478,455874,1661459,1837197,10837,11164,11374,11910,12255,12516,12540,12541,13054,13338,13365,13635,14015,14186,2038447,14535,15073,15392,15422,15519,15599,15910,16059,16709,16787,17028,17175,17647,18044,18068,18424,18942,18981,19088,19193,19221,19658,19859,20102,20229,20579,21061,21096,21348,21592,343291,22093,22352,22680,23024,23213,23684,23820,23850,23852,23970,24386,24497,24602,24628,24862,173449,25299,25445,25636,26070,26345,26463,26579,27355,27395,27569,27570,85292,28471,29031,29159,393334,29821,30005,30036,30213,30342,30357,30530,761503,30674,30697,31001,31155,31529,31667,31925,32134,32289,32671,32771,32835,33013,33327,155970,34901,35091,35281,35290,35781,35818,79101,261917,36537,36614,36723,36902,37225,37292,37334,37725,38087,38218,38351,39210,39255,39939,40406,2171150,40985,41014,41104,41356,41687,42100,42229,42568,42876,43560,44083,45031,45345,45648,46372,46407,46693,46970,48774,49668,50120,50635,50638,51440,51717,52086,53378,53561,53948,54288,55640,55688,55938,56137,56269,56430,56701,57256,405555,57374,58170,58193,59035,59143,59203,59364,60072,60358,60392,60890,61505,61989,62389,63013,63030,63151,63345,63653,64140,64376,64573,64633,64750,65805,66168,66288,66450,66525,66753,66908,67451,67618,67869,68387,68426,68443,69634,69714,69957,69998,445105,70440,70605,70801,70939,71126,71217,72491,72510,72873,73480,73594,74185,74216,74310,74483,74676,74679,75033,75059,75924,76702,76826,79438,79496,79813,80514,80577,80756,80885,80908,81000,81108,81501,81687,82328,82541,82555,82881,82906,83028,327627,83414,83541,85311,85803,85931,86424,87027,87306,87530,87640,87721,88105,89367,89556,89717,91757,92069,92092,92176,92882,93036,93039,93777,94099,94607,95532,95970,96223,96766,96825,97095,97154,97208,97551,97592,98064,98180,98247,98657,99212,99265,99565,134490,100207,100603,100996,101059,101306,102041,102399,102469,102526,102647,102916,102957,103431,103857,104267,104469,104588,104969,105582,105672,105744,105752,105849,105940,106231,106535,106680,107544,107587,108062,108354,108691,108727,109072,109163,109711,109823,109859,109892,109914,110341,110396,110648,110769,110980,111033,111288,111603,1238060,111794,112936,113325,113658,114446,114472,114556,407240,114626,114780,114930,114962,116047,116522,116618,116987,373700,118461,118737,118935,118999,119084,119092,119509,119609,120541,121035,121183,121231,121273,121576,121974,122211,122668,122867,122980,123280,123285,123471,123518,123709,124384,124651,125179,125231,126056,126163,126310,126974,127203,127474,127499,128250,128935,128988,129386,129774,129852,130281,130554,130767,130933,131146,131560,131664,131928,132096,132112,132366,132610,133497,133840,134445,329269,135116,135594,135642,135870,135972,136065,136303,136431,136533,136536,136655,136667,136699,136966,137067,137635,137965,138069,2136033,139046,168647,140223,140277,140489,141378,141390,141800,142360,2650569,142822,144449,144450,144560,144882,145501,145888,145912,146042,146651,146705,146786,146836,147003,147024,147057,147381,147655,148715,149035,149864,150290,150340,150450,150509,150664,443793,150767,150955,151643,151652,151791,152824,153105,153487,153580,154636,154989,155538,155929,156448,156879,157115,157976,158209,158822,159267,160245,160737,160823,160841,160858,160909,160942,160955,160972,160990,302274,161468,161737,161743,161896,161967,162963,163430,163967,1965110,164611,164967,165115,165783,166301,166397,166562,166926,167575,168044,168256,168460,168472,168568,168703,169015,169178,169201,169250,170286,171440,172217,172390,172536,172670,172938,173542,173562,173578,173649,173754,182897,340639,174034,174084,174310,400462,174818,174923,175053,175679,175932,176761,177232,177333,177415,177917,178805,179011,179021,179345,179630,179746,179878,180135,180261,180604,598930,180881,181002,181017,181310,181417,181769,181825,181903,182489,182779,183036,183315,183510,183880,183934,184673,184739,185099,185453,185568,185818,185823,185946,186039,187014,187112,187364,187569,187922,187972,188006,188407,188442,188549,188704,189071,189418,189665,189672,190244,190321,190367,190398,190507,190637,190868,190895,190908,655472,191014,191341,191594,784403,191967,192415,192794,192942,192973,192985,193204,193474,193710,193734,193892,193907,193973,194020,194085,194378,194518,194624,194832,194904,194976,430936,4373282,195353,195569,195755,196211,196306,196634,196684,197035,197617,240706,197802,198219,198555,198666,198898,198932,199690,199697,199901,199952,200082,200228,200597,200778,200901,201284,201329,201331,201519,201693,201695,202207,202375,202709,202761,202820,202841,202912,203449,203453,203667,204033,204596,204627,205098,205112,205177,205533,205577,205599,206257,206713,206883,206918,207048,207393,207507,207675,207811,208388,208436,209035,209101,209339,209512,209526,209576,210008,210031,210048,210073,210119,210121,210194,210219,210380,210622,210958,211026,211029,211067,838018,211259,211319,211780,211790,211990,212264,212520,212590,212708,212756,212788,212903,213234,213261,213302,213341,213369,213409,213662,213729,213770,214219,214874,214983,215020,215150,215155,215293,215576,215727,216009,216064,2438460,216383,216662,216857,217124,217145,217244,244978,217722,217771,217933,218065,218074,219072,219138,219435,219710,219736,219876,220140,220152,220288,220464,220625,220627,220904,220970,221080,221244,221378,221515,221520,222667,222773,222820,222850,223274,223488,224124,224534,224626,225680,225979,225992,226028,226097,226404,227228,227624,227664,227802,227887,228138,228343,228693,229044,229145,229695,230001,230013,991727,230701,230787,231019,231034,231259,231432,231503,231565,231697,398701,231967,232122,232265,232286,232636,232800,232812,232949,233191,233617,233556,234060,234689,234715,235234,235450,235825,235909,235926,235946,236004,236280,236396,236573,236635,236888,237160,237613,237712,237843,279691,238723,238828,238965,239199,240205,381590,241172,241213,241214,241635,241821,242020,242491,242778,242983,243135,243345,243408,243735,244326,244361,244435,244822,244841,244933,244970,245120,2465579,245319,1959348,246163,246284,246589,246793,246815,246992,247256,247472,247802,247878,248031,248163,248562,248925,249109,249221,249230,249347,249978,250079,250104,251267,250442,250872,251272,251394,251549,251556,251656,251670,251985,252034,252171,252254,252372,452047,252630,252898,252959,253216,253367,253462,253727,254036,254274,254434,254858,255392,255493,255728,255817,256442,256469,256494,256727,257480,257656,257908,258098,258443,258607,258672,258732,258775,2438186,258902,258958,259162,259296,259458,259559,259682,260104,260358,260411,260550,260551,260622,260768,260981,261096,261157,261166,261520,261534,261574,261701,261871,262029,262680,262707,262983,263530,264017,264078,264229,264607,264636,265024,265043,265270,265288,265340,265806,265880,265948,266246,266326,266930,266991,267013,267027,267254,267505,267530,268084,268419,268592,269070,269268,269679,269876,269989,269999,270207,270405,270614,270723,271059,271067,271186,271290,271296,271451,271745,271826,271840,272322,272367,272736,272890,272931,273053,273430,273463,336508,274021,274042,274200,274390,274437,274561,274568,274677,274789,275011,275188,275287,275416,275690,275700,276267,520751,276584,276982,277095,277113,277282,277428,277489,277535,277662,278827,278981,279199,279356,279512,582593,280264,280382,280408,281089,281445,281760,281875,282259,282446,282561,282728,282808,282976,283075,283181,283563,284238,284380,284474,285381,285460,285758,286028,286298,286595,286615,286737,286890,287154,287161,287262,287302,287546,287792,287935,446973,288149,288478,288787,288833,289477,289519,289657,289943,290004,290324,290704,290820,290850,291206,291293,291505,291720,292064,292666,334841,292857,293259,293608,293691,293697,294026,294118,294283,294308,294314,943393,294459,294653,295153,295206,894890,295444,295454,295558,295633,295654,295757,295813,296108,296174,296858,296920,1184899,297029,297046,297115,297387,297411,297432,297754,298059,298693,299114,299462,299494,299500,299502,299642,299699,299724,299726,299781,299913,300309,300345,300350,300587,300985,301013,301061,301111,301192,301194,301203,301269,301277,301679,301913,302235,302277,302548,302898,450720,302968,303015,303032,303391,303517,303992,304207,304250,304417,304571,304785,305268,305727,306434,306443,306867,306929,307093,307359,307688,307766,307930,307961,308185,308431,309151,309436,309442,309918,309983,310045,310092,310205,310301,310764,310911,311143,311160,311218,311326,311367,311445,1017259,311487,311562,312353,312415,312558,313066,313217,2376034,313355,313453,313774,313781,313783,314000,314082,314085,314333,314360,314570,314944,375025,315204,315227,315700,315707,315855,316191,316477,316568,316621,316663,316679,316949,317017,317050,317119,317349,317384,317745,317940,318344,318349,318456,318605,318635,318741,318857,318935,318950,319044,319293,319383,319699,320157,320703,320837,320859,321559,321882,321893,322053,322159,1216201,322896,322926,323005,323127,323191,323269,323286,323616,323620,2631832,324127,484487,536272,324742,325137,325369,325382,325605,326145,326220,326264,326334,326643,326645,326962,327527,328213,328375,328397,329056,329084,329492,329584,329910,329950,330065,330305,330602,330696,330791,331332,331391,331404,331759,331839,331982,331983,332057,332251,332823,332907,1267180,333028,333175,333577,333807,333891,333926,359793,1964381,334369,334819,389426,335296,336094,336184,336312,336335,336711,336718,336928,336943,337504,337545,337682,337763,372013,428057,337838,338059,338184,338247,338452,338470,338633,338645,338908,339107,339669,339921,340505,340779,340798,340850,340939,341152,341426,341778,342316,342354,342423,342525,342676,342765,342866,342887,343274,343494,344248,344405,344490,344534)
AND OwnerUserID IN (344561,344570,344720,345484,345588,345883,345925,346219,346415,346476,346530,346627,347104,347245,347438,347828,348109,348243,348424,348464,348695,348749,348898,349189,349197,349528,350096,350118,350438,350491,350692,350749,350755,350771,350837,351117,351167,351174,351790,351965,352397,352864,353073,353267,353406,353410,353442,353548,353652,353672,353696,354007,2267272,354680,354838,354888,355038,355153,355552,355694,355866,1151267,356016,356495,356690,356864,357003,357246,357344,357613,357764,358286,358287,358687,358745,358811,358914,639424,703402,359138,359400,359451,359656,359762,359981,360263,360351,360496,360565,360591,360628,360684,360874,361197,361490,361530,361640,361762,361925,362104,362116,362274,362817,363042,363157,363508,363511,363527,363531,363605,364034,364046,5140804,364211,364296,364425,364620,364759,364821,364974,365030,365041,365082,365092,365142,365261,365403,365627,365694,365781,365904,366298,366469,366493,366514,366690,366842,367067,367570,367770,367842,368025,368077,368305,368392,369096,369198,369312,369387,369416,369466,369658,369665,370008,370228,370262,370539,370606,1283554,371009,371069,371074,371320,371553,371653,371716,794024,371770,372073,372107,372653,373048,373087,373144,373439,373512,373612,373659,499163,745153,373829,374642,374804,374916,374943,375098,375232,375269,375481,375847,375997,376065,376071,376087,376769,376973,377077,377464,377478,377546,377647,378001,378110,378392,379058,379081,379444,379535,379865,379871,380245,380757,380839,381150,381209,381286,381480,381529,382023,383003,383258,383382,383623,383638,383679,383914,383919,383934,384152,384195,384302,384417,384618,384824,384892,385387,385467,385468,385862,385984,386041,386074,386107,386219,386334,386452,386760,556659,640636,387380,387746,388085,461669,467984,388692,388921,388981,388999,389062,811063,389113,389459,389787,389896,389913,461263,390357,390450,391143,391227,391456,391572,391579,391702,391889,392016,429898,392190,392384,392576,393107,393121,393488,393681,393948,394200,394227,396004,394563,395167,395490,395659,395861,396028,396050,396560,396646,397229,397518,397639,397665,397694,397722,397878,397999,398035,398165,399004,399234,399267,399510,399644,399659,399815,399940,400327,400456,400651,401124,400912,401059,401446,401516,401659,401803,401810,402076,402249,402452,402640,402744,403036,403074,403614,404175,404539,404586,404650,404680,404822,404844,405115,573110,405213,405316,405458,405700,405810,405876,405937,405977,406042,406043,406237,406301,1654450,406340,407184,407194,407464,407471,407605,407989,408163,408454,408725,408992,409038,409050,409230,409679,409796,410242,410262,410315,410469,410572,410842,410850,410962,411127,411499,411501,411518,411972,412427,412723,412985,413141,413162,413543,891942,413582,413910,414314,414566,414750,414821,415248,415311,415868,415911,415977,416165,416386,416409,416431,416475,416553,416742,417212,417308,417424,417855,418281,418305,418307,418520,418662,418759,419258,419422,426051,420265,420517,420664,420857,421087,421157,421405,421889,421905,422798,422833,422915,423068,423103,423136,423165,423205,423478,423633,423663,424122,424233,424994,425287,425374,425646,425963,426392,426645,427082,427246,427469,427617,427641,427810,428101,428322,428361,428625,428962,429070,429463,429641,429687,429766,429934,1723138,430144,430625,430626,431049,431736,432507,432956,433213,433249,433502,433790,433852,433855,459638,434222,434253,434371,434894,434904,435056,435121,435153,435479,435967,436121,436243,436528,436561,436671,436680,437190,437272,437379,437635,437728,437768,437861,438157,438308,438441,438517,439021,439058,439166,1730237,439682,439692,439757,440606,440630,441064,441138,441526,441616,441784,441809,441908,442049,442284,442339,442436,442538,442576,442823,442851,443150,443228,443583,443609,443672,443911,826702,443927,444480,444589,444653,444749,444792,445126,445206,445359,445378,446032,446483,446729,446743,446746,869112,447238,447333,447391,447398,447933,448352,448867,564242,449377,449449,449572,449592,449806,449865,449881,449943,1146522,450742,451040,451293,451492,451624,451725,452005,452056,452102,452797,452891,453027,453122,453226,2579970,453709,454029,454306,508148,454545,454778,454786,454836,455936,456017,457069,457290,457542,457862,458111,458483,458703,458854,459185,459339,459505,459544,459662,459818,459883,460121,460753,460801,460857,460987,461215,461317,461832,462075,462157,462372,462521,462620,463257,463505,463683,463692,463721,463996,464109,464207,464441,464520,464703,464721,464961,465535,466146,466185,466652,466818,466938,467102,467252,467526,467790,467795,468009,468118,468467,468680,468774,468889,469064,469185,469303,469385,469515,470056,470281,470314,470707,471736,470824,471077,471160,471208,471218,1067182,471380,471464,471659,471695,471824,472058,472290,472723,472772,473104,473270,473332,473502,473517,473614,473675,473833,618439,473948,474054,474489,474642,474877,474883,475220,475350,475830,476502,476557,476772,477212,477361,477367,477572,477625,477666,477816,477882,478066,478085,478428,478441,478483,478499,478699,478921,478943,479127,479220,479381,479659,479846,479886,479980,480044,480787,480797,481031,481272,481810,481896,482170,482481,482581,482850,483105,483107,483117,483253,483401,483664,483929,484044,484192,484592,484647,484822,484879,485010,485105,485191,485364,485530,485570,485590,485711,485807,485904,488049,488102,488143,958263,488413,488474,488541,488614,488965,489019,489024,489351,489356,489605,489744,490497,490672,490687,490694,490731,490874,491112,491152,491439,491538,491561,491629,491732,492294,492305,492315,492628,492827,493055,493178,493332,493652,493765,493830,494064,494314,494582,494679,494876,494954,495047,495141,495531,495756,495888,496045,496297,496393,496423,496435,496460,496491,496600,496719,496762,496925,496950,497111,497673,497675,497794,497807,497836,498052,498154,498195,498203,498304,498402,498529,498728,499304,499450,499665,499826,499987,500181,500407,500515,500962,501069,501401,501461,501644,501869,502259,502627,502691,503323,503345,503381,503633,503718,503752,503899,504341,504445,504813,504858,505322,505383,505570,505808,506174,506332,506608,506678,506687,506953,507348,507615,507689,1149481,507954,507989,508006,508013,508060,508729,508777,509470,509060,509070,509239,509769,509775,510032,510044,510067,510071,510100,510315,510948,511054,511062,511271,511738,512081,512394,512603,512631,512943,513141,513182,513262,513310,513360,513618,514064,514101,514141,514296,514297,514624,514922,515083,515086,515232,515338,515785,516316,516414,516711,516841,517203,517499,518131,518186,518302,518503,518525,518572,518848,518865,518874,518909,518978,519004,519724,520340,520471,520628,520681,520713,520806,521051,521188,521238,521482,521584,521756,521809,521862,522070,522158,522257,522329,522337,522498,522626,522742,522934,523374,523559,523722,523723,523906,523965,523967,524181,524272,524416,524496,524506,524533,524929,525385,525467,525658,525762,526153,526584,527098,527334,527386,527484,527506,527585,527634,527804,527996,528049,528110,528166,528233,528266,529018,529119,529148,529224,529295,529585,529878,530028,530630,530698,530898,531036,531158,2253418,531605,531640,532065,532344,532347,532848,532868,532969,532993,533531,533744,533984,534127,534157,534332,534943,535361,1646250,536047,536169,536205,536291,536665,536733,536812,537051,537166,537304,537593,537732,537913,537974,537998,538163,538205,538208,538302,538327,538339,538409,538598,538708,539041,539045,539193,539465,539694,539859,539894,839971,539980,540024,540131,540247,540795,541156,541254,541306,541383,541550,542190,542465,542481,542501,613282,1343450,542802,543208,543275,543311,543479,543551,543730,543752,543841,543847,543942,543979,544067,544641,544652,544745,544860,545160,545664,545722,545831,545897,545980,546160,546488,546725,546865,555071,547398,547549,547606,547897,548265,548680,548915,549074,549356,549798,550066,550138,550255,550913,550974,551661,551906,552111,552469,552503,552529,552812,552898,552995,553525,554012,554126,554213,554245,554355,554455,554906,555086,555329,555566,555993,556236,556279,556686,556760,557164,557258,557555,557599,558088,557789,558305,558314,558369,558379,558415,558501,558525,558773,558925,559021,559299,559501,561424,559696,560373,560432,560437,560697,560754,560821,561334,561498,561511,561757,561843,562034,562071,562088,562146,562237,562266,562355,563763,563918,564468,565014,565110,565330,565340,565497,566064,566236,566292,566335,566602,566618,566849,567072,567430,567630,567655,567684,567770,567864,568003,568088,568108,568124,568246,568253,568415,568688,568697,568793,568852,568858,568990,569191,569294,569500,569630,569823,570170,570179,570242,570583,570725,570753,570936,570981,570984,571009,571155,571594,571817,572038,2300413,572065,572562,572764,573421,573461,573468,573473,573660,574224,574301,574423,574696,574823,574865,575082,575151,575244,575321,575329,575695,576031,576190,576393,576562,576686,576864,577244,577549,577587,577669,578079,578227,578299,578318,578579,578646,578802,578968,579008)
Group by OwnerUserId

fork query

edited aug 14

created aug 14 anonymous