Story-Identification questions asked and answered by the same user at the same time

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

--1=Q 2=A
select Q.Id as [Post Link],Q.OwnerUserId as [User Link]
     , Q.Score,Q.Title,Q.AnswerCount,Q.ClosedDate, Q.CreationDate, A.CreationDate 
from Posts Q, Posts A, PostTags T
where Q.Id=A.ParentId
and T.PostId=Q.Id
and T.PostId=A.ParentId
and T.TagId=130 -- story-identification
and Q.OwnerUserId=A.OwnerUserId
and Q.PostTypeId=1 and A.PostTypeId=2
and Q.CreationDate = A.CreationDate

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results