0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for information security professionals

SELECT 
  [User Link] = u.[Id]
  , u.[Reputation]
  , u.[CreationDate]
  , u.[DisplayName]
  , u.[LastAccessDate]
  , u.[WebsiteUrl]
  , u.[Location]
  , u.[AboutMe]
  , u.[Upvotes]
  , u.[DownVotes]
FROM dbo.Users u
WHERE u.[DisplayName] LIKE N'Spammer%'
  AND u.[Reputation] <= 1
  AND u.[UpVotes] = 0
  AND u.[DownVotes] = 0
  AND u.[LastAccessDate] < DATEADD(DAY, -10, GETDATE())
  AND NOT EXISTS
  (
    SELECT 1
    FROM dbo.Posts p
    WHERE p.[OwnerUserId] = u.Id
  )
ORDER BY u.[CreationDate] DESC;

fork query

edited mar 31

created mar 31 Hannah Vernon