0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

SELECT TOP 15000 p.Id as [Post Link], COALESCE(q.ViewCount, p.ViewCount)
  FROM Posts AS p
  LEFT OUTER JOIN Posts AS q
    ON p.ParentId = q.Id
  WHERE (p.Body LIKE '%//i.sstatic.net%')
    AND COALESCE(q.ClosedDate, p.ClosedDate) IS NULL
  ORDER BY 2 DESC

fork query

edited oct 27 anonymous

created aug 30 22 Glorfindel