0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for musicians, students, and enthusiasts

SELECT TOP 50000 Title, Body, Tags, Id, Score, ViewCount, FavoriteCount, AnswerCount, CreationDate
FROM Posts 
WHERE PostTypeId = 1 AND ViewCount > 10 AND FavoriteCount > 10
AND Score > 5 AND AnswerCount > 0 AND LEN(Tags) - LEN(REPLACE(Tags, '<','')) >= 5
ORDER BY CreationDate DESC

fork query

created jul 20 anonymous