how many users total, lastYear, last2months and last month

0

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

select p.id, case when aa.body like '%<code>%' then 1 else null end
from posts p left outer join posts aa on (p.AcceptedAnswerId=aa.Id)
where p.id in (
25595492,26705784,27007353,27347820,27489124,27838280,27865238,28339882,29071226,29434226,29636094,30739851,31095177,31104540,31201083,31317470,31404820,31764926,31786040,32334161,32392202,32470907,32529742,32574103,32741333,32863771,33118913,33125508,33798965,34023438,34301614,34439201,34450732,34586306,34640611,34676168,34774290,34794630,34973135,35135884,35172625,35264620,35314963,35324974,35409492,35501600,35555602,35585519,35589045,35617996,35639882,35673254,35743527,35882330,36129008,36272482,36479452,36541906,36573857,36642718,36681094,36812791,36871886,36957369,
37143689,37159662,37180375,37523631,37679132,37830008,37854185,37864255,37915326,38049334,38453830,38492388,38627025,38687434,38820356,39154613,39172786,39260387,39305118,39593580,39668149,39839881,40010594,40068318,40205675,40208887,40377076,40377377,40457443,40542220,40660618,40735590,40832097,40876048,40890804,40910259,40932850,40938088,41008507,41019199,41262716,41287712,41329351,41431506,41445442,41640621,41745636,41850142,41881610,41914911,42053559,42134186,42140285,42230797,42311050,42353292,42393102,42394690,42498492,42527724,42539505,42788267,42822348,43179951,
43208872,43246560,43252404,43369008,43396744,43532494,43612866,43633659,43655652,43700905,43850359,43910795,43939970,44085454,44114755,44131588,44313956,44350408,44554638,44610425,44619634,44642751,44785105,44797253,44939302,44965110,44988481,45072041,45146319,45208766,45241581,45301310,45351222,45441593,45474338,45510905,45515650,45534252,45567201,45630225,45848118,45866422,45928269,45998405,46143509,46199874,46370014,46464455,46803321,47017657,47050984,47089196,47146939,47162798,47181503,47271002,47295217,47311911,47330878,47366889,47398736,47566338,47766808,47860278,
47938835,48071720,48134800,48144298,48167778,48201224,48277437,48279479,48294450,48344922,48347363,48635782,48667874,48731168,48743105,48763985,48833778,48836908,48838101,48959272,48984289,48993781,49107497,49113488,49260669,49292843,49469599,49476498,49488573,49531349,49534740,49580394,49606124,49637598,49638004,49659871,49698823,49944789,50010287,50159354,50217813,50312750,50390452,50454109,50484157,50555353,50571546,50635469,50645878,50686734,50700178,50849415,51017946,51026313,51189616,51371678,51524648,51541318,51726683,51924926,51976057,52011686,52031350,52070247,
52161774,52210810,52274308,52298830,52349494,52366559,52368590,52402591,52463529,52475303,52475493,52705424,53043023,53075715,53109442,53149896,53193632,53266337,53397918,53551495,53595219,53763907,54124170

)

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results