DECLARE @initial_date DATE DECLARE @final_date DATE SET @...

0

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

DECLARE @initial_date DATE
DECLARE @final_date DATE
SET @initial_date = '2021-01-01'
SET @final_date = DATEADD(m , 12 , @initial_date)

SELECT TOP 500000 Title, Body, CreationDate, Tags, Id, Score, ViewCount, FavoriteCount, AnswerCount
FROM Posts 
WHERE PostTypeId = 1
AND CreationDate between @initial_date and @final_date
AND ViewCount > 10 
AND FavoriteCount > 0
AND Score > 5 
AND AnswerCount > 0 
AND LEN(Tags) - LEN(REPLACE(Tags, '<','')) >= 0
AND CommentCount > 5

Enter Parameters

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