0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to bypass life's everyday problems with simple tricks

SELECT closeddate, title, id, posttypeID, score, viewcount
FROM posts
WHERE postTypeID = 1
AND CreationDate BETWEEN '2008-01-01' AND '2008-12-31'
AND ClosedDate IS NOT NULL
AND (Score >= 250 OR ViewCount >= 150000)
ORDER BY ViewCount Desc

view current version

edited nov 23 12

created nov 23 12 SamtheBrand