Q&A for amateur radio enthusiasts
SELECT a.body, b.CloseReasonTypeId, c.Name FROM posts a JOIN pendingflags b ON (b.postid is NULL) INNER JOIN CloseReasonTypes as c ON (b.CloseReasonTypeId = c.Id) WHERE YEAR(a.CreationDate) = '2019' AND MONTH(a.CreationDate) = 2 AND DAY(a.CreationDate) = 1 /*UNION ALL SELECT TOP 500 a.body, 0 as 'CloseReasonTypeId', 'Not Flagged' as 'Name' FROM posts a LEFT JOIN pendingflags b ON (a.id = b.postid) WHERE YEAR(a.CreationDate) = '2019' AND b.postid IS NULL*/