0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for folks dedicated to a lifestyle that can be maintained indefinitely without depleting available resources

select a.owneruserid, count(*) from posts a, posts b
where 
a.posttypeid = 2 and b.posttypeid = 1 
and 
a.parentid = b.id
and
(b.tags like '%<java>%<thread%' or b.tags like '%<java>%<inheritance%' or b.tags like '%<java>%<string%')
and
a.owneruserid in 
(select distinct owneruserid from Posts where posttypeid = 2 and 
parentid 
in (11640025,15587818,5464330,13157584,6510724,9105358,15382347,16152311,6081670,21375659,9378394,3640254,15125003,11678779,18462826,13475388,2939427,24859500,4886091,838987,6112419,2297347,11221515,32112980,21724072,12962515,372547,18744226,3243721,9446704,4431911,27465731,14930073,31696168,898405,31549669,5234147,10366856,13990941,9662170,21037263,5061611,14040646,20404710,13821578,3184244,5445874,11908037,11180866,36324289,6174259,30482503,6219263,6418095,11893659,10928387,19378658,24733222,5389200,27210280,2441501,6712587,3879160,7161534,8560248,30132902,5433027,4260723,4672806,11930474,18711896,31206851,9583467,2784267,15111420,6653961,27192215,18453458,12758106,6684665,22272863,4413132,2219439,3075743,7817951,3442090,6258270,599161,7786397,15815587,2968,26641809,2818796,19484406,18623801,29037240,22203111,19279586,13001971,25630425,8967382,11149759,2272169,22323384,32854968,30689811,4173951,2920525,11131081,7476535,15225908,7633552,28250559,12120002,1833581,21548741,2158627,119328,35993541,6215486,7887464,12625422,24614762,16919501,1911902,18766857,13111698,18838781,1978933,3321526,1096621,1527856,22120747,3422673,3652369,29948645,9406775,23419087,12132604,7940337,11700598,10748440,7280351,12443540,1617005,17531362,1635659,20515911,5071040,2598129,10524352,785091,3307549,12278323,8154366,15378392,5596458,2018556,28752489,9098022,4469984,31455706,600733,14742641,32000960,6650650,93091,32564322,7021074,1308137,8336856,17366882,3695230,6775016,21923361,9007365,22110707,7935858,10091790,5324007,11300203,2910336,9950800,16581977,2124324,1102891,5835386,34509566,1167982,5182451,10672402,3034757,25503907,36376044,1149703,8396177,6257316,11588916,11942368,1538755,1475807,31868404,338206,14602062,15979026,231917,10074298,3350804,26555346,10666537,16620354,6122013,33996988,10154305,5803454,10647520,531779,16686488,11580035,4838730,6682518,29771825,14278170,5769669,4397328,213985,2175064,22969348,10196942,5688042,3939561,1200783,10275769,5238491,5457146,4199298,14447637,8046045,18061100,4283351,277364,11408427,2164804,10563202,31635378,6558285,7446994,14338965,15492353,13255041,703396,5733931,13361692,15370288,4832056,1367322,4416425,7853502,12106757,22326923,8788143,12702249,41107,2800739,5054995,9868482,13578738,9872002,2890989,12925988,36326373,7610689,359625,35143748,4893313,2938945,9112999,21159711,248938,2275004,16641554,4041266,24686940,106591,130506,182316,309396,641906,706048,791986,799023,826161,840165,867660,896789,1006655,1050592,1094867,1202444,1218790,1323408,1326014,1429681,1490919,1609126,1660834,1662185,1739614,1739799,1770166,2202735,2423622,2476002,2622804,2623453,2688099,107823,117690,314580,565893,578904,671049,989839,991904,1223072,1531073,1600572,1617963,1669453,1888160,1904072,1946520,2020992,2289885,2332537,2335702,2340114,2388850,2463429,2758612,3041345,3042549,3256269,3330430,3693197,3882342,3885657,4034201,4083787,118371,249867,574240,634102,883284,931650,1418033,1649133,2187626,2193310,2275819,2484425,2554549,2733356,3157852,3227040,3409608,3463658,3489543,3578604,3822608,4051185,4107839,4491606,4561951,4586181,4670664,4819855,5054265,5233893,5868999,5942233,6005137,6206472,88036,121762,181615,533783,534919,819138,1252190,1532826,1553886,1742325,1895881,1961095,2022170,2326695,2612054,2663419,2785964,2793175,2820592,2834355,3098786,3148186,3179733,3212255,3310834,3768554,4259391,4397269,4604003,4766179,4877292,4922173,190559,226455,289804,878577,1064596,1085709,1149928,1172113,1596009,1758664,2095418,2131043,2262803,2383710,2428725,2674174,2960581,3026127,3047564,3397722,3402895,3406839,3419380,3493752,4691132,5169101,5568304,5856694,5958767,6123024,6223389,6347474,6507944,6789477,50561,125333,152342,164088,258901,385195,426758,484182,591627,609826,967124,1749018,1881714,1922290,1923512,2068876,2107616,2170520,2205015,2275443,2300579,2306059,2308181,2644688,2713407,2787094,3106452,3130701,3194227,3318750,3398988,3836937,4348438,247455,416183,462697,519099,532360,973518,2012259,2077771,2120248,2264476,2437141,2631791,2688629,2779484,2822004,3038203,3086467,3286626,3439485,3602783,3820647,3835830,3855393,3910595,4183582,4329818,4492273,4691367,4756536,5022100,5117778,5143307,5258948,5905252,184147,491323,625241,801993,807223,938926,1164678,1394631,1537116,1664446,1679579,1702386,1811782,1849972,1914898,1950080,1980832,2117072,2187464,2300433,2333407,2522198,2653458,2810054,3018165,3237701,3311587,3488703,3929361,3966229,5180114,5297813,5493399,5517413,104184,141284,281855,461896,990948,1111527,1194606,1234429,1250643,1431573,1492069,1800317,1939229,2074299,2436142,2531938,2784009,2852614,2860889,2894381,2958621,3153574,3163117,3332832,3376586,3449918,3535754,3800146,3940164,3964211,4283270,4427398,59787,1387207,1622219,2207070,2229033,3556652,5763750,5867287,6008472,6308931,6896504,8467494,9130796,11245674,13131592,16946733,18391844,19433364,23484767,23976797,25916796,31389295,31904739,43579567,268929,364936,370695,2042050,3540640,5536583,5668429,6851612,7477553,9646397,9810445,12628251,14464226,14475329,14925261,16856064,17540386,19976487,20712782,24188517,24488455,24719880,24846017,27556863,31655052,34593186,659872,1069528,1500827,1589522,1902195,2543551,5892229,7988756,8152574,10054403,10090167,10465646,10659208,10698516,11110631,11143404,11175058,11786632,12978798,15682457,17068389,17937003,18151540,18392885,19398862,20435868,22052330,27471284,27504925,31398444,239645,519914,917974,2261954,2370685,2598009,3671753,3806822,4090834,4288942,4604978,4679314,4733443,4859523,6308178,6661045,8035877,8537018,9089065,10021603,10589828,11163968,12542193,13990462,15367152,17174003,18512304,19546357,21377859,23573726,26339237,27537189,29912230,31323115,32555441,35412873,37467384,541749,662598,1297972,1763129,2143220,3052280,3245142,3351666,4460355,4716040,4747292,6063749,6304056,6427126,6462343,9546208,11034035,11379115,12133817,12160540,16202884,19047248,19349391,19895304,21016776,21086417,23340414,24378375,32931030,34531180,35910026,321864,1296235,1624084,2853316,2922257,3005383,3029766,3108182,3330390,3348225,4033118,5667764,7857832,9797212,10442665,17217965,17311842,19312641,22096052,23081671,23948009,27410216,30501237,38009060,2000478,2066917,2515477,4140065,4745798,6596772,6908360,7982129,8632148,9122785,9494380,9546188,12216138,12434393,14739586,15668032,16652966,21282318,21824402,34255329,218744,1916019,2700680,3255464,6587621,6711363,6860378,7000428,8531292,10843383,11321404,13040650,13167394,13475172,15353086,17806342,17839332,21681094,23005656,25632356,26822618,32113173,34519878,43612264,385551,740873,1038314,1865800,2020270,2464104,5215873,5937249,7073093,7081742,7761513,8647248,8694848,9421247,10594052,10839131,11343840,11732422,11905630,15998335,16683408,17152967,17980696,21818544,22874640,25891022,31242036,33784097,36158826,36509590,40322931,869449,899414,902922,2883033,4060842,4458868,6924426,7336920,7738171,9957102,10635279,13950648,14272026,16795374,23103498,25169175,26722212,30470067,31774694,32821479,32822379,37681829,2192711,2953529,3095562,4897298,5176294,5417958,5804843,6156141,7700573,7962398,8318231,8858656,8913406,9458123,9863835,9893481,10703310,11974428,12308674,14042319,15121643,19421193,24552319,28400408,28964109,30007480,30878334,31076008,32337055,32422923,39005336,696350))
group by a.owneruserid

fork query

edited oct 18 17

created oct 18 17 anonymous