Posts about 18.04 closed as off topic before release

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT q.Id AS [Post Link],
       q.Score AS Score,
       q.AnswerCount AS Answers,
       q.ViewCount AS Views,
       q.Tags AS Tags
       
FROM Posts q

JOIN PostHistory ph ON ph.PostId = q.Id

WHERE q.PostTypeId = 1
      AND q.Body LIKE '%18.04%'
      AND q.CreationDate > '2018-01-01'
      AND q.CreationDate < '2018-05-01'
      AND q.ClosedDate IS NOT NULL
      AND ph.Comment LIKE '102'
      
ORDER BY q.CreationDate ASC

Enter Parameters

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