0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientific skepticism

SELECT c.Id AS CommentId,
       c.PostId AS AnswerId,
       c.CreationDate,
       c.UserId AS CommenterUserId,
       u.DisplayName AS CommenterName,  -- Fetches the commenter's name
       c.Text AS CommentText
FROM Comments c
JOIN Posts p ON c.PostId = p.Id
LEFT JOIN Users u ON c.UserId = u.Id  -- Joins with Users to get the display name
WHERE p.Id IN (12453584, 2988271, 521708, 604182, 142266, 191104, 4728162, 262396, 895095, 141100, 166052, 12214880, 56136591, 60018731, 11475779, 1748651, 32749, 11884806, 194482, 59727, 244933, 45630, 600719, 3289606, 335936, 538823, 110337, 159559, 3295972, 25607, 31581387, 11664675, 1139981, 16699042, 926270, 572011, 51071, 1045147, 357449, 1260813, 6663292, 1323426, 32878, 599914, 472622, 463161, 8702435, 983942, 3673447, 5898031, 1319353, 301784, 1057065, 856658, 95259, 209899, 182091, 268700, 229157, 5475224, 60780210, 11784778, 31632745, 2998544, 319953, 241975, 156868, 1293673, 69642922, 1263129, 3627815, 479795, 46046703, 55110, 1165320, 489465, 27227718, 8127777, 105099, 341050, 33558141, 5829377, 278606, 1060005, 428714, 906529, 158672, 510907, 317945, 389734, 279385, 2755273, 543322, 1068851, 30287, 4528110, 19008548, 13998534, 2561008, 10207, 6468505, 301581, 8977109, 13869233, 393957, 42690573, 140725, 1144418, 57807, 159786, 190373, 240315, 164934, 1592581, 20270, 36158079, 1253939, 817430, 953381, 381771, 151075, 8777, 315175, 3940137, 51031070, 139626, 476674, 54997, 640604, 23734295, 619262, 5899544, 191152, 204882, 765976, 223320, 101447, 749374, 189558, 6767329, 52273, 41096943, 1174325, 70030, 1267145, 7816439, 406595, 8385658, 279014, 114589, 7353335, 129522, 890877, 100307, 6496, 1309268, 102511, 3392370, 934008, 52062, 287661, 11497391, 511029, 444393, 505326, 8244949, 1270500, 435000, 508953, 38490727, 86771, 347906, 5262769, 388753, 86341, 209931, 156685, 15333283, 494878, 316932, 23978968, 315595, 18979314, 47865626, 846598, 6167353, 907078, 17743548, 530468, 30557040, 7197643, 146472, 180217, 1078931, 15839, 12207352, 39133654, 477308, 6718435, 52880211, 5537942, 185146, 351876, 4765242, 1100653, 85342, 2277363, 1101597, 352488, 298852, 1781590, 22029, 46011113, 557405, 548083, 268332, 277047, 219780, 499192, 4584180, 361670, 865272, 10103, 45808255, 957829, 700198, 15179418, 453034, 226036, 1019572, 194414, 1713101, 468798, 508446, 437563, 2264722, 126570, 223068, 358705, 537736, 14390676, 188678, 16269635, 981624, 27844237, 574814, 516329, 1190656, 22949613, 651735, 414090, 3877312, 138260, 326469, 22284921, 169568, 4295743, 24176022, 33874511, 12141207, 7643, 96651, 327596, 13827087, 120716, 4935945, 24903067, 4581997, 574360, 14058475, 4149444, 31885295, 224675, 37103131, 414005, 13633860, 697762, 888576, 32148, 475873, 361483, 15345969, 34803630, 10149358, 24085681, 10344231, 141216, 142483, 1377652, 1095174, 908443, 14487936, 239107, 3233356, 62888, 21311, 820636, 36142844, 126110, 70545, 121489, 580048, 241189, 32101507, 73819, 298208, 31360218, 18424933, 58302703, 310625, 11427183, 27256, 8909233, 630739, 13562327, 69822584, 42642326, 51953411, 23996414, 69527217, 360963, 641874, 427370, 5337329, 247160, 228983, 434731, 16878364, 23051095, 47290, 37262973, 176039, 164750, 75502, 323058, 20612691, 397997, 359634, 40914267, 53954986, 538909, 62285234, 1290376, 199572, 300831, 32427, 54358758, 283994, 12739974, 244547, 17558764, 84987, 19801806, 332765, 1025435, 59385935, 9058322, 25389754, 473009, 207066, 484086, 29814281, 40105714, 575486, 8294654, 12555510, 70099102, 421383, 17142719, 220565, 683642, 37961120, 805113, 44072944, 18393879, 369009, 92165, 28052583, 550997, 370199, 41573588, 35904211, 16054, 8272643, 8609238, 104881, 11479840, 9788, 41220267, 194889, 45662992, 3148376, 237084, 221941, 528251, 8637972, 502388, 65266270, 467919, 1326002, 80503, 62529343, 31599276, 50193944, 280517, 5214587, 333166, 666228, 6260097, 281280, 550552, 934502, 258697, 3542894, 144184, 165728, 1207461, 153146, 21285575, 237724, 147950, 1230699, 10202789, 337846, 47285378, 25802742, 29934, 219801, 336913, 178092, 1133013, 48374171, 703985, 520556, 15618520, 7604717, 15699761, 27232309, 71110028, 343774)
  AND p.PostTypeId = 2 -- PostTypeId = 2 indicates answers
ORDER BY c.CreationDate DESC;

fork query

edited nov 11

created nov 11 anonymous