SELECT pq.Id as postid, p...

0

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 = pq.id             WHERE pq.ParentId IS NULL             AND CreationDate > '2020-01-01 00:00:00'             AND CreationDate < '2020-04-30 23:59:59'             AND Id > 61449222              AND Id < 61499222

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results