Please login or register to vote for this query.

(click on this box to dismiss)

you were the first commenter on a new user's first question

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

select as qID,
  p.owneruserid as Asker, as cID,
  c.userid as Commenter,
  p.score as qScore,
  case when closeddate is null then '' else 'closed' end as closed,
  case when deletiondate is null then '' else 'deleted' end as closed
from postswithdeleted p left outer join comments c on
where p.posttypeid=1 and p.owneruserid is not null and c.userid is not null
order by,

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results