1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

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

fork query

edited may 24

created may 24 Unionhawk