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)

Poker Meta

Q&A for serious players and enthusiasts of poker

select distinct p.id 
from posts p inner join posts a on (a.ParentId=p.id)

where p.id in (
48838101,49113488,49606124,50217813,50454109,51541318,52298830,26705784,27347820,27489124,27838280,33798965,34586306,35324974,35555602,36479452,36681094,36812791,37679132,39172786,39593580,39668149,40542220,40735590,40832097,40876048,40910259,41329351,41745636,42230797,42311050,42394690,42539505,42822348,43655652,44131588,44313956,44350408,44642751,45301310,45441593,45474338,45630225,45866422,45998405,46143509,46370014,47181503,47366889,47766808,47860278,48277437,48344922,48743105,48833778,48836908,48959272,48984289,49107497,49476498,49488573,49580394,49659871,49698823,50010287,50159354,50555353,50571546,50635469,50645878,50686734,50849415,51017946,51924926,52011686,52070247,52402591,52705424,53043023,
53075715,53551495,29434226,30739851,31095177,32392202,32863771,34439201,34450732,34676168,34774290,34973135,35135884,35585519,35589045,35639882,36272482,37854185,38049334,38492388,41019199,41850142,42134186,43369008,43633659,44619634,44939302,45146319,45928269,46199874,46803321,47017657,47271002,47330878,48071720,48347363,48993781,49531349,50390452,50484157,51026313,51976057,52366559,52463529,53266337,53595219,54124170,32574103,35314963,37159662,40377076,40890804,40932850,41008507,41914911,43252404,43396744,45241581,45351222,45567201,47295217,48134800,48201224,49534740,
50312750,50700178,28339882,34301614,35264620,36642718,40457443,41445442,42498492,52031350,35673254,39154613,47311911,47938835,32470907,34023438,35172625,37523631,38627025,40938088,42140285,43179951,44610425,45510905,52349494,35882330,36957369,37830008,40205675,52274308,53109442,53149896,40660618,45515650,32741333,52161774,45208766,48635782,43612866,25595492
)
and
(p.Body like '%@%'
or a.Body like '%@%'
or p.Body like '%annota%'
or a.Body like '%annota%'
)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results