0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

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 (1238019,1548051,9576186,20126,172261,2314073,2396539,7884305,155137,172861,588071,23903,84704,5496973,1003917,857807,1586880,392949,133910,3410,176761,11522,245860,44269,5597,208880,1984039,1131467,112671,286871,235885,207661,966550,330565,962891,217288,2795592,1552748,3679490,1737,265261,1195080,45249,200266,188031,119634,170365,172211,2238,1851712,78182,725418,492901,5641669,4281779,72631,1438733,1435869,726863,781707,110026,904393,1209018,108796,62937,5089204,1253844,13154,134713,32484,779513,287047,1463,26160,1207195,111307,34855,522663,220147,778560,1191259,14444,624900,64174,1082681,314020,20745,520162,6482561,61624,49018,4653379,750987,52626,845092,269476,821679,432745,159270,921204)
   )
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;

fork query

edited oct 31

created oct 24 anonymous