0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for SharePoint enthusiasts

SELECT
    q.Id AS QuestionId,
    q.Title AS QuestionTitle,
    q.Body AS QuestionBody,
    q.AnswerCount,
    q.CommentCount,
    q.CreationDate AS QuestionCreationDate,
    q.FavoriteCount,
    q.LastActivityDate AS QuestionLastActivityDate,
    q.LastEditDate AS QuestionLastEditDate,
    q.LastEditorDisplayName AS QuestionLastEditorDisplayName,
    q.LastEditorUserId AS QuestionLastEditorUserId,
    q.OwnerDisplayName AS QuestionOwnerDisplayName,
    q.OwnerUserId AS QuestionOwnerUserId,
    q.Score AS QuestionScore,
    q.Tags AS QuestionTags,
    q.ViewCount AS QuestionViewCount,
    a.Id AS AnswerId,
    a.CreationDate AS AnswerCreationDate,
    a.Score AS AnswerScore,
    a.Body AS AnswerBody
FROM
    Posts q
INNER JOIN
    Posts a ON q.Id = a.ParentId
WHERE
    q.PostTypeId = 1
    AND a.PostTypeId = 2
    AND q.Id IN (
        565425, 239905, 263818, 910465, 335888, 386874, 441350, 59926, 1119656, 471257, 
        1082053, 438704, 18351166, 693270, 594004, 1252448, 139199, 512174, 289979, 1078397, 
        893767, 309615, 1236511, 537596, 260236, 363370, 888052, 316367, 18693477, 544239, 
        868482, 18508155, 265722, 885686, 986403, 601300, 582002, 196150, 1126669, 531186, 
        34896, 956993, 1320682, 242421, 982216, 318219, 295825, 473924, 116415, 228476, 
        1082852, 323456, 534764, 284163, 1176951, 1293499, 1259536, 830929, 731738, 642443, 
        168886, 754205, 181948, 449922, 332365, 489119, 826981, 442634, 1240718, 844508, 
        595873, 1263218, 500090, 22704, 667263, 186106, 823821, 541620, 877583, 763498, 
        62816, 807866, 236242, 18640114, 247304, 1321821, 232228, 317967, 10731, 372933, 
        1314521, 1235883, 106001, 772888, 309497, 129677, 1056547, 1263125, 1264367, 1220509, 
        1097781, 692500, 619991, 464317, 968064, 1303856, 1024073, 793692, 451623, 596057, 
        455109, 207819, 110458, 320923, 485023, 901214, 1238763, 679249, 155220, 1139772, 
        733237, 703856, 863869, 627918, 60174, 831618, 1099391, 354161, 488804, 1199886, 
        1287329, 1107338, 614476, 209927, 110575, 606099, 1029057, 350177, 704194, 836459, 
        1329639, 585891, 76359, 18520795, 810283, 199613, 693288, 886593, 824139, 1105971, 
        444248, 304413, 495970, 71756, 1146396, 633109, 659384, 52830, 252156, 1256349, 
        149848, 1055650, 1033947, 394214, 70170, 884047, 1081025, 274375, 45093, 890897, 
        407771, 1060956, 615704, 1144300, 252258, 1122072, 854961, 534742, 793487, 1116128, 
        305044, 96945, 1211592, 859218, 1256001, 1192485, 511885, 268182, 1201247, 481098, 
        365168, 779917, 670919, 1220182, 352172, 896821, 229889, 860954, 1335503, 636248, 
        306668, 1131332, 945095, 1259561, 331856, 601209, 216324, 687787, 200545, 579130, 
        949569, 811460, 533237, 46841, 134099, 180239, 1012036, 526745, 680783, 75696, 
        535175, 398179, 1075973, 1062642, 88962, 1266367, 921943, 1275814, 1284386, 1284, 
        397789, 852117, 665086, 915922, 143750, 929612, 622646, 1275393, 910617, 318475, 
        681583, 757857, 350697, 533082, 1067159, 237816, 1316738, 786029, 1321887, 148964, 
        1129984, 609455, 339180, 1136772, 72166, 1141040, 1329963, 253238, 18270834, 173329, 
        1070491, 486964, 645735, 929744, 796934, 650101, 372834, 1155411, 210691, 897020, 
        947618, 139046, 52239, 889410, 1007308, 616042, 1007401, 815003, 492523, 436715, 
        699499, 881928, 115503, 802459, 1129102, 1194318, 349668, 699716, 981573, 630183, 
        1283476, 1168947, 1169173, 1224806, 332833, 945584, 967497, 775702, 1056190, 678400, 
        633853, 479535, 283594, 64432, 973357, 1008579, 561454, 1167149, 583592, 457014, 
        1175585, 994371, 1216593, 283589, 1244607, 650979, 272003, 1268339, 539692, 566350, 
        1284522, 1288628, 57261, 1185187, 539816, 157924, 196177, 269253, 1246760, 1115739, 
        820004, 308236, 714704, 525156, 617833, 732561, 274659, 51124, 915910, 295945, 
        93100, 540311, 782197, 254935, 440289, 1168052, 146839, 508100, 539960, 380114, 
        1226406, 1228924, 149876, 935032, 810523, 345450, 369981, 602625, 1017321, 937503, 
        1077438, 648307, 526576, 775755, 623960, 1235829, 339591, 862187, 1183161, 537103, 
        303149, 2102209, 1932387, 2023854, 1659470, 2055258, 2020737, 1947177, 1984784, 
        1960179, 1487439, 3800703, 1677336, 1349474, 2087182, 1796434, 2086288, 1719255, 
        1719399, 1778778, 2068155, 2051987, 2248928, 2203987, 1815620, 2052960, 1837934, 
        2118846, 1482926, 1876650, 2064972, 1690550, 1822529, 1784578, 1911818, 1963078, 
        1892607, 1575807, 2095633, 1790918, 2101498, 1359973, 1373574, 2327931, 2252612, 
        2148936, 1795099, 1924714, 2044645, 1718388, 2105375, 1381118, 1952904, 2030926, 
        1739875, 1477944, 2164425, 2148924, 2197300, 2170359, 1908909, 2018151, 2057655, 
        1683843, 1841978, 1757341, 2103350, 2053272, 2194848, 1973897, 1996344, 1392023, 
        3224232, 1911697, 2074094, 2138687, 2216107, 2043677, 2176440, 2165024, 1457374, 
        1612430, 2017865, 3341588, 2092193, 1677465, 2276059, 3261880, 2163658, 2055684, 
        1893405, 1473626, 2111097, 1723721, 2144778, 1439403, 2161246, 1527296, 2225238, 
        1615792, 1357553, 2125251, 2300036, 2326584, 2161610, 2234310, 1421871, 2130045, 
        2265199, 2224852, 1582161, 2131252, 2140244, 3332670, 2107162, 2275445, 2172569, 
        1529835, 1394467, 2120028, 2113262, 1400968, 2199997, 2017904, 1459412, 2305353, 
        2224270, 1409858, 2282142, 1544910, 1456704, 1363452, 3681357, 2238666, 1540707, 
        2211685, 1787629, 1358109, 2306113, 1528538, 1583728, 2054973, 2225047, 1778977, 
        1381013, 1349586, 2203588, 1507096, 1518348, 2109852, 2238506, 1373813, 1514282, 
        1824579, 1981414, 1535053, 2059795, 1460060, 1535326, 2214843, 1834396, 1812891, 
        1832908, 1779663, 1593183, 1652956, 1800013, 1379437, 1579160, 2258781, 2038993, 
        1847239, 1443557, 1374288, 1451519, 1857465, 1589289, 1813078, 1446629, 1932493, 
        2030610, 1457773, 1619418, 1977237, 1869588, 1390209, 1714640, 1618289, 2214235, 
        2221787, 1819122, 2000500, 1831478, 1749753, 1823536, 1855661, 1524101, 1676280, 
        1797677, 2004817, 2164759, 1422891, 2296423, 1510435, 2275244, 1555076, 1862036, 
        1726512, 1384282, 1431903, 1441525, 1641911, 2022775, 1828001, 1968293, 1764497, 
        1678216, 2127028, 1780823, 1890310, 1837750, 1587540, 1517650, 1752222, 1966127, 
        2200256, 1810172, 2230189, 1740277, 1872451, 1716979, 1953736, 2312051, 1876076, 
        1604684, 2206054, 1923352, 1413320, 2078776, 1884091, 1686309, 2319588, 2080976, 
        1828908, 1608522, 1741376, 1560306, 2222084, 2284317, 1674937, 1871485, 1426861, 
        2329499, 1871774, 1499134, 1962130, 1467338, 1582511, 1393436, 1751152, 2609043, 
        2767596, 2533262, 2531116, 2513279, 2737685, 2493213, 2829209, 2959384, 3015619, 
        2951938, 2546879, 2863034, 2825885, 2616344, 2844630, 2398675, 2616610, 2846916, 
        2688675, 2763233, 2754473, 3003396, 2640564, 2691947, 2835075, 3189239, 2364424, 
        3042644, 2629256, 2784391, 2803921, 2394141, 2858274, 2763324, 2905679, 2649094, 
        2828491, 2792084, 7620109, 2472211, 2389658, 3200784, 7078308, 2608743, 2724537, 
        2856682, 3187166, 2929996, 2527877, 2776138, 2758181, 2388256, 2336633, 2864007, 
        3149599, 2778323, 2854168, 2629443, 3123994, 2799495, 2879712, 2779051, 2400469, 
        2730853, 3140060, 2958922, 2715421, 2446475, 7031971, 3197607, 2781012, 2890452, 
        3047393, 2357897, 2861402, 7061129, 3150375, 3179021, 2934959, 2791147, 2913551, 
        2818156, 2802298, 3143410, 3061848, 2433602, 2852530, 2779326, 2748685, 2961262, 
        2870081, 3142393, 2936245, 2803364, 2423433, 2953015, 2873065, 2573332, 2387950, 
        2639215, 3062897, 2920812, 2624665, 2943701, 2967354, 2621703, 2550589, 2987011, 
        2389064, 2981762, 2915036, 2609749, 3022529, 2937867, 2505225, 3132493, 3209252, 
        2626467, 2404808, 2768692, 3200617, 3037016, 2505149, 2401748, 3090476, 2589820, 
        2423338, 2990846, 3011217, 3021306, 2496398, 3040405, 2498136, 2750534, 2703996, 
        2388654, 2787600, 7108210, 2380054, 3025228, 2380785, 7126731, 2547514, 2993027, 
        2992189, 3040174, 2581116, 3102076, 3142602, 2458582, 2592700, 2635421, 3114853, 
        3191538, 2715143, 2775595, 2520667, 3005404, 2446292, 3014371, 3149437, 3007086, 
        3017581, 2557585, 3200936, 2356866, 2735749, 2834206, 2908914, 2790897, 2847850, 
        2580491, 2694524, 3173298, 2731054, 2428259, 2581465, 3031678, 2897878, 3101307, 
        3204186, 2602846, 2657404, 3073202, 2540165, 3183868, 3059153, 3204456, 2869589, 
        2647158, 2965430, 2390224, 2701954, 2456123, 3087071, 2336008, 2351315, 3097536, 
        3150069, 2473716, 2516250, 3148616, 2468464, 2890114, 3113691, 2705940, 2942619, 
        2772454, 3120178, 2749108, 3149301, 3150524, 2533471, 2806438, 2773441, 3162084, 
        2504995, 2864713, 2731871, 2416227, 3164746, 2898249, 2534526, 3177541, 3152363, 
        2686877, 3170925, 3183502, 2807118, 2765165, 2822592, 3197348, 2770328, 2819445, 
        3176515, 2346558, 2703060, 3168369, 2745525, 2370163, 3216920, 2769716, 2351698, 
        3144011, 2797692, 2351791, 2564334, 3118661, 2382358, 3199577, 2453908, 2928187, 
        2541230, 3118876, 2389389, 2822449, 2389910, 2993135, 3173650, 2558243, 2940030, 
        2923594, 2409792, 3184563, 3211625, 2739306, 2765027, 2916722, 3102972, 2571620, 
        2855277, 2962263, 2412183, 3448778, 3592418, 3533665, 3962815, 3650207, 3959736, 
        3983580, 3490566, 3690390, 3580591, 4011097, 126, 3637969, 3710951, 3720599, 
        3900061, 3568240, 3561697, 3775964, 3674584, 3503024, 3324798, 3601963, 3486740, 
        3601742, 3980393, 3575160, 3650073, 3619963, 147, 3635550, 3784202, 3963894, 
        3577555, 3544484, 3711953, 3674980, 3801514, 3719042, 4045868, 3655008, 3304363, 
        3262592, 3743197, 3806169, 3354242, 3401409, 3305378, 3243194, 3870966, 3317989, 
        3573370, 3772554, 3445910, 3830294, 3591317, 3810459, 3623756, 3340020, 3891309, 
        3979385, 3985531, 3826360, 3677303, 3996243, 3818255, 3987552, 3334941, 3636286, 
        3441193, 3520669, 3319007, 3704056, 3778453, 3527539, 197, 3834202, 3571673, 
        3526155, 3484896, 3764105, 3953056, 3424752, 3220149, 3565378, 3953082, 3652195, 
        3731755, 3731389, 3993121, 3401219, 3306902, 3447760, 3772793, 3814665, 4018174, 
        3746431, 3828140, 3831509, 3761411, 3917923, 3552680, 3850420, 3979231, 3750607, 
        3531561, 3448441, 3439760, 3451704, 4033080, 3236596, 3775453, 3638689, 4007846, 
        3986980, 3883737, 3878499, 4019614, 3635200, 4022676, 3940197, 3268598, 3527601, 
        3588484, 3975223, 3489710, 3737887, 3808493, 3799778, 3951133, 3984274, 3949557, 
        3862113, 3244488, 3265391, 3863320, 3749083, 577, 3657765, 3246637, 3996944, 
        3363344, 3639086, 3717977, 3579687, 3317984, 4005566, 3877423, 3479268, 3471652, 
        3951366, 3651561, 3473841, 3653788, 3936805, 3390528, 3911880, 3299054, 3999785, 
        3403136, 3890091, 4020033, 4026856, 3814770, 3752104, 3383573, 3496581, 4002986, 
        3524571, 3736831, 3527656, 3795731, 3661465, 4023097, 4021302, 553, 4029803, 
        3302548, 3382107, 3646399, 4029556, 3748043, 3368075, 3307362, 3554660, 3219907, 
        3524185, 4031120, 3579542, 3674160, 3913837, 3684184, 3482942, 3610592, 3657639, 
        3844477, 3529446, 3795209, 3670453, 3787651, 3470415, 4040028, 3778067, 3865446, 
        3686621, 3468194, 3533314, 3833228, 3970290, 3591220, 4004086, 3934735, 3848658, 
        3482725, 3928920, 122, 3844518, 3239767, 3658330, 3636478, 3599442, 3797613, 
        3644524, 3247240, 3888065, 3917617, 3731171, 3807474, 3335364, 3290851, 3690781, 
        3748151, 3761064, 3557928, 3974268, 3533486, 3720720, 3560707, 3554296, 3419717, 
        3436710, 3705399, 3735016, 3607682, 3744582, 3975481, 3954767, 3622111, 3731211, 
        4799182, 4141304, 4337015, 4491656, 4358693, 4143625, 4160601, 4171059, 4658599, 
        4517962, 4331025, 4729422, 4238891, 4573486, 4359668, 4210495, 4257875, 19899680, 
        4179110, 4073445, 4243657, 4407346, 4238952, 4262953, 4536685, 4753433, 4277281, 
        4223980, 4606677, 4302717, 4325932, 4311342, 4349879, 4421016, 4410999, 4836821, 
        4600954, 4609305, 4509957, 4433023, 4683814, 4538870, 4228648, 4275882, 4396771, 
        4674734, 4359701, 4404253, 4103809, 4606437, 4628081, 4571884, 4806450, 19936293, 
        4572031, 4687204, 4742212, 4359918, 4614327, 4428068, 4442229, 4593563, 4814438, 
        4690539, 4362453, 4672684, 4683414, 4369942, 4831390, 4379667, 4561249, 4715202, 
        4307723, 4436763, 4671897, 4463528, 4386545, 4749588, 4597659, 4453014, 4486055, 
        4353037, 4638201, 4231075, 4809608, 4807926, 4321587, 20243757, 4674547, 4520176, 
        4382002, 4465022, 4507492, 4197253, 4398627, 4719681, 4494234, 4246076, 4054008, 
        4120030, 4604496, 4167604, 4520303, 4486936, 4506406, 4527196, 4533280, 4569060, 
        4535955, 4550977, 4593495, 20343789, 4259676, 4080382, 4355716, 4046302, 4807058, 
        4396761, 4556066, 4637025, 4556672, 4679934, 4642376, 20125786, 4153696, 4573843, 
        4719775, 4831364, 4060999, 4694513, 4796681, 4585824, 4603155, 4761827, 4348244, 
        4776720, 4834469, 4720990, 4289717, 4450747, 4084563, 4338259, 4320975, 4383135, 
        4707047, 4104734, 4091721, 4772006, 4663061, 4657305, 4812292, 4613272, 4745474, 
        4196727, 4709610, 4152582, 4620450, 4695650, 4636317, 4345275, 4351881, 4721435, 
        4658421, 4159256, 4191346, 4395923, 4820425, 4241668, 4830366, 4056316, 4085724, 
        4686402, 4723460, 4243164, 4428202, 4446919, 4688693, 4312492, 4841845, 4295740, 
        4092048, 4525558, 4103506, 4756413, 4146864, 4793043, 4102752, 4123239, 4333015, 
        4308570, 4793111, 4202882, 4161961, 4777070, 4285651, 4494428, 4137826, 4232447, 
        4643085, 4822472, 4703770, 4323737, 4701611, 4454403, 4840725, 4292991, 4620742, 
        4168969, 4645258, 4102387, 4068201, 4119075
    );

fork query

created oct 22 anonymous