Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences
WITH CommentBatch AS ( SELECT c.Id AS CommentId, c.Text, p.Title, p.OwnerUserId AS UserId, u.DisplayName, u.Location, t.TagName, ROW_NUMBER() OVER (PARTITION BY p.Id ORDER BY c.CreationDate DESC) AS CommentRowNum FROM Comments c INNER JOIN Posts p ON c.PostId = p.Id INNER JOIN Users u ON p.OwnerUserId = u.Id INNER JOIN PostTags pt ON p.Id = pt.PostId INNER JOIN Tags t ON pt.TagId = t.Id WHERE t.TagName IN ('python', 'java', 'csharp', 'php', 'javascript', 'go', 'swift') -- Programming languages filter AND p.OwnerUserId IN (961113,17160,1749403,315935,1090562,10676716,3293881,320615,1687119,521799,250259,1704166,95706,328193,76217,576911,4604579,1197518,4983450,2684539,1679863,253056,82294,324584,43089,87189,140750,584518,5741205,5577765,5486,2587435,36565,505154,243782,616443,14104,434551,135589,635608,452307,2836621,230513,2372064,383904,5202563,575376,615,893780,41661,1873365,1745001,2970947,1084437,153982,850848,244296,1103872,7108653,1676363,13070,8690857,2147,869736,367456,4653,128165,546861,10035985,164835,1270695,3171,949476,4639,7429447,48082,1694,13531,454533,5157454,23528,2308683,266304,260127,114066,17516,44330,89391,2648,145190,62076,2319407,425275,82187,582,9990,465183,416467,3333,721269) ) SELECT cb.CommentId, cb.Title AS CommentTitle, cb.Text AS CommentText, cb.UserId, cb.DisplayName AS UserName, cb.Location AS UserCountry, cb.TagName AS CommentTag FROM CommentBatch cb WHERE cb.CommentRowNum BETWEEN 1 AND 500;