select q.Id as [Post Link], q.Tags, q.Score, q.CreationDa...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select q.Id as [Post Link], q.Tags, q.Score, q.CreationDate, DateDiff(second,q.CreationDate,a.CreationDate)
from Posts q
Join Posts a
on a.ParentId=q.Id
and a.OwnerUserId <> q.OwnerUserId
and a.CreationDate > q.CreationDate
where a.PostTypeId=2
and q.PostTypeId=1
and q.DeletionDate IS NULL
and q.ClosedDate IS NULL
and q.Tags NOT LIKE '%<riddle>%' and q.Tags not like '%<rebus>%' and q.Tags not like '%<lateral-thinking>%'
and q.Score > 0
and q.CreationDate > '20130101'
order by DateDiff(second,q.CreationDate,a.CreationDate)

Enter Parameters

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