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 (
        16331494, 16292593, 16367940, 16557785, 16514071, 16193348, 16222353, 16327680, 
        16408209, 16499498, 16189001, 10064037, 16106960, 16213243, 16150097, 16347910, 
        16361593, 16545321, 16291649, 16047381, 16368249, 16369170, 16466208, 16350653, 
        16515420, 16384345, 16139879, 16221308, 16501332, 16517772, 16302417, 16091293, 
        16275942, 16411250, 16426076, 16423030, 16516509, 16532154, 16570384, 16481216, 
        16308075, 16496822, 16516879, 16329294, 9686294, 16511134, 16082420, 16280081, 
        16084119, 9796106, 16271783, 16202006, 16149486, 16090525, 16175743, 16165702, 
        16385015, 16094943, 16487216, 16515366, 16157758, 16043774, 16492182, 16496199, 
        16049300, 16438784, 16234207, 16249727, 16298511, 16549012, 16250791, 16575268, 
        16441595, 16459668, 16376180, 16551654, 16515718, 16300154, 9760725, 16570965, 
        16154039, 16246970, 16459772, 16213172, 16182217, 16183385, 16189481, 16524150, 
        16298804, 16408567, 16499227, 16136420, 16423065, 16120856, 16321930, 9715764, 
        16496503, 16233185, 16311339, 16424432, 16564954, 16155188, 16131762, 16183806, 
        16160765, 16123993, 16297330, 16148667, 16433383, 16348839, 16243953, 16042879, 
        16101183, 16392263, 16445791, 16363610, 16458090, 16130289, 16215990, 16181447, 
        16096138, 16075519, 16177209, 17046818, 16749414, 16947591, 17073482, 16984376, 
        16813893, 16761562, 16996228, 16708355, 16941946, 16629693, 16645008, 16714245, 
        17039628, 16984850, 16631904, 16996667, 16880189, 16869277, 16945820, 16885987, 
        16777828, 13877011, 17043233, 16980551, 16985406, 16591046, 16632413, 16817520, 
        16951992, 17076202, 16629629, 16830138, 17024323, 16789727, 16927598, 16686124, 
        17055531, 17088902, 16732646, 16688813, 16930541, 14295485, 16693741, 16874614, 
        16601683, 16958511, 16657968, 17041974, 16802408, 16972968, 17079744, 16846918, 
        16621370, 17070960, 16999911, 16873074, 16869842, 17024831, 16746818, 16810229, 
        16650324, 16780711, 16880794, 16918816, 17119439, 17102848, 16957657, 16625603, 
        16729346, 17033028, 16706219, 16926493, 16873522, 16823137, 16759516, 16979871, 
        16726672, 17090522, 16903907, 16835761, 16633972, 17086565, 17036393, 16768645, 
        16933403, 16799539, 17019024, 16735981, 17048761, 16766282, 16715799, 17007279, 
        16670204, 16624894, 13885959, 17067751, 17031493, 16964996, 16879245, 16979346, 
        16942138, 17099648, 16866874, 17030555, 16795905, 14259767, 16788764, 16629932, 
        16589780, 16802210, 17096272, 16855054, 16616498, 16610759, 16764293, 16841469, 
        16691840, 16817793, 17033872, 16675337, 16890556, 16619598, 16981154, 16647851, 
        17013532, 17075424, 16915648, 16693473, 16881085, 16603559, 16668341, 16670587, 
        17023141, 16718029, 16873695, 16953200, 16842305, 16674644, 16985054, 16904797, 
        16725796, 17059037, 16772338, 17064042, 16579901, 14274145, 17110025, 16830310, 
        17098516, 16866076, 17123304, 16977171, 16764611, 16682065, 17083383, 17080853, 
        16690571, 16715600, 16994115, 16885992, 16726752, 17085470, 17081213, 17009516, 
        17081232, 17045852, 16943823, 16677641, 17101444, 16639770, 16598787, 16804155, 
        17098095, 16819097, 17051050, 17059362, 17000804, 17113712, 14012743, 16580119, 
        17042848, 16993048, 16848607, 16626443, 17184194, 17443205, 17269949, 17386947, 
        17300689, 17479608, 17179905, 17486456, 17263654, 17130730, 17314250, 17666567, 
        17580843, 17249797, 17534892, 17376561, 17283659, 17488527, 17441410, 17439121, 
        17425331, 17336587, 17544937, 17331046, 17546826, 17332849, 17273405, 17660620, 
        17315251, 17334100, 17608555, 17553237, 17538871, 17196779, 17626883, 17388003, 
        17210196, 17484071, 17590396, 17201619, 17444476, 17596948, 17201312, 17640481
    );

fork query

edited oct 22

created oct 22 anonymous