DECLARE @start_date DATE DECLARE @end_date DATE SET @star...


Please login or register to vote for this query.

(click on this box to dismiss)

Anime and Manga

Q&A for anime and manga fans

DECLARE @start_date DATE
DECLARE @end_date DATE
SET @start_date = '2011-01-01'
SET @end_date = DATEADD(m , 12 , @start_date)

SELECT p.Id, p.CreationDate, p.Title, p.Body, p.Tags,
p.ViewCount, p.CommentCount, p.AnswerCount, p.Score 
FROM Posts as p
LEFT JOIN PostTypes as t ON p.PostTypeId =
WHERE p.CreationDate between @start_date and @end_date
AND t.Name = 'Question'
AND p.ViewCount > 20
AND p.CommentCount > 5
AND p.AnswerCount > 1
AND p.Score > 5
AND len(p.Tags) > 0

Enter Parameters

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