User's first questions


Please login or register to vote for this query.

(click on this box to dismiss)

Linguistics Meta

Q&A about the site for professional linguists and others with an interest in linguistic research and theory

with firstpostids_cte as (
SELECT MIN(Id) AS MinId, OwnerUserId
FROM Posts
WHERE PostTypeId=1
GROUP BY OwnerUserId

SELECT Top 100
p.Id AS [Post Link], p.OwnerUserId AS [User Link], p.CreationDate, p.ClosedDate
FROM firstpostids_cte fp JOIN Posts p ON fp.MinId=p.Id
ORDER BY p.CreationDate DESC

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results