Posts from unregistered or one-time users

1

Please login or register to vote for this query.

(click on this box to dismiss)

Economics

Q&A for those who study, teach, research and apply economics and econometrics

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

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