User's first questions


Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

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