Users who recently posted their first post

1

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

;  with firstpost_cte as
(SELECT
  OwnerUserId AS uid,
  OwnerDisplayName AS udn,
  MIN(Id) AS minid
FROM Posts
  WHERE PostTypeId IN (##types?1,2##)
---types?1,2 both Q&A
---types?1 Q
---types?2 A
GROUP BY OwnerUserId, OwnerDisplayName)

SELECT TOP(##num?500##)
  f.uid AS [User Link],
  f.udn AS [Display Name],
  f.minid AS [Post Link],
  p.CreationDate,
  p.Score, p.ViewCount,
  p.Tags
FROM firstpost_cte f INNER JOIN Posts p ON p.Id=f.minid
ORDER BY p.Id DESC

Enter Parameters

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