0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

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

view current version

edited may 4 23

created may 4 23 galacticninja