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


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

Switch sites:
loading Hold tight while we fetch your results