0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

SELECT TOP 500000 Id, CreationDate, Score, ViewCount, AnswerCount, CommentCount, FavoriteCount, Title, Body, Tags

FROM Posts

WHERE PostTypeId = 1

AND Score > 5

AND ViewCount > 10

AND AnswerCount > 0

AND CommentCount IS NOT NULL

AND FavoriteCount IS NOT NULL

AND LEN(Tags) - LEN(REPLACE(Tags, '<','')) >= 4


ORDER BY CreationDate

fork query

edited feb 3

created feb 3 anonymous