Posts from unregistered or one-time users


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for SharePoint enthusiasts

SELECT p.Id AS [Post Link], p.CreationDate, u.Id AS [User Link]
FROM Posts p
LEFT JOIN Users u ON p.OwnerUserID = u.Id
WHERE DATEDIFF(hour, u.CreationDate, u.LastAccessDate) <= 1
AND p.CreationDate >= '2022-01-01'
AND u.Id > 0
AND u.Reputation < 100
ORDER BY p.CreationDate

Enter Parameters

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