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 Title, Body, Tags, Id, Score, ViewCount, FavoriteCount, AnswerCount, CreationDate, CommentCount

FROM Posts

WHERE PostTypeId = 1

AND Score > 5

AND ViewCount > 10

AND AnswerCount IS NOT NULL

AND CommentCount IS NOT NULL

AND FavoriteCount IS NOT NULL

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

fork query

edited feb 3

created feb 3 anonymous