Find up-vote-bot users

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT Users.Id as [User Link], Users.Reputation, Users.CreationDate, Users.LastAccessDate, 
       Users.Views, Users.UpVotes, Users.AboutMe
FROM Users
WHERE Users.Reputation < 30
  AND Users.Reputation >= 10
  AND Users.UpVotes >= 10
  AND Cast(Users.CreationDate as Date) = Cast(Users.LastAccessDate as Date)
  AND Users.Id NOT IN (
    SELECT OwnerUserId 
    FROM Posts
    WHERE OwnerUserId IS NOT NULL
    GROUP BY OwnerUserId
  )
ORDER BY CreationDate

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached