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