SELECT pq.Id as postid, p...


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT                 pq.Id as postid,                 pq.Tags as tags,                 pq.Title as title,                 pq.Body as question,                 pa.Body as answers,                 pq.CreationDate as creation_date             FROM posts pq             LEFT JOIN (             SELECT pa.ParentId, STRING_AGG(pa.Body, CHAR(10)) as body             FROM posts pa             WHERE ParentId IS NOT NULL              GROUP BY pa.ParentId             ) pa ON pa.ParentId =             WHERE pq.ParentId IS NULL             AND CreationDate > '2020-01-01 00:00:00'             AND CreationDate < '2020-04-30 23:59:59'             AND Id > 61249222              AND Id < 61299222

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results