Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

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

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results