1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

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 '%enter image description here%'
      OR p.Body LIKE '%alt=""%')
    AND COALESCE(q.ClosedDate, p.ClosedDate) IS NULL
  ORDER BY 2 DESC

fork query

created aug 30 22 Glorfindel