Posts from unregistered or one-time users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Drupal Answers Meta

Q&A about the site for Drupal developers and administrators

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 main site
loading Hold tight while we fetch your results