0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

Select * FROM

(select TOP 10000 t.TagName, year(p.CreationDate) as QuestionYear,
p.Score, p.ViewCount, p.AnswerCount, p.CommentCount, p.FavoriteCount,
(datediff(s, p.CreationDate, x.CreationDate)*1.0) as AnswerDelta, 
x.Score as AnswerScore

FROM Posts p, Tags t, PostTags pt, Posts x
WHERE p.AcceptedAnswerId = x.Id
AND pt.PostId = p.Id
AND pt.TagId = t.Id
AND year(p.CreationDate) = '2020'
and p.Score > 0
and t.Count > 100
and p.PostTypeId = 1
and p.CommunityOwnedDate is Null
ORDER BY rand()) as res

UNION ALL

Select * FROM

(select TOP 10000 t.TagName, year(p.CreationDate) as QuestionYear,
p.Score, p.ViewCount, p.AnswerCount, p.CommentCount, p.FavoriteCount,
(datediff(s, p.CreationDate, x.CreationDate)*1.0) as AnswerDelta, 
x.Score as AnswerScore

FROM Posts p, Tags t, PostTags pt, Posts x
WHERE p.AcceptedAnswerId = x.Id
AND pt.PostId = p.Id
AND pt.TagId = t.Id
AND year(p.CreationDate) = '2019'
and p.Score > 0
and t.Count > 100
and p.PostTypeId = 1
and p.CommunityOwnedDate is Null
ORDER BY rand()) as res

UNION ALL

Select * FROM

(select TOP 10000 t.TagName, year(p.CreationDate) as QuestionYear,
p.Score, p.ViewCount, p.AnswerCount, p.CommentCount, p.FavoriteCount,
(datediff(s, p.CreationDate, x.CreationDate)*1.0) as AnswerDelta, 
x.Score as AnswerScore

FROM Posts p, Tags t, PostTags pt, Posts x
WHERE p.AcceptedAnswerId = x.Id
AND pt.PostId = p.Id
AND pt.TagId = t.Id
AND year(p.CreationDate) = '2018'
and p.Score > 0
and t.Count > 100
and p.PostTypeId = 1
and p.CommunityOwnedDate is Null
ORDER BY rand()) as res

UNION ALL

Select * FROM

(select TOP 10000 t.TagName, year(p.CreationDate) as QuestionYear,
p.Score, p.ViewCount, p.AnswerCount, p.CommentCount, p.FavoriteCount,
(datediff(s, p.CreationDate, x.CreationDate)*1.0) as AnswerDelta, 
x.Score as AnswerScore

FROM Posts p, Tags t, PostTags pt, Posts x
WHERE p.AcceptedAnswerId = x.Id
AND pt.PostId = p.Id
AND pt.TagId = t.Id
AND year(p.CreationDate) = '2017'
and p.Score > 0
and t.Count > 100
and p.PostTypeId = 1
and p.CommunityOwnedDate is Null
ORDER BY rand()) as res

fork query

edited jul 24 21

created jul 24 21 m1735