User's first questions

1

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

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

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