[Mod-only] Users with only suggested edits and a lot of upvotes [v1.0.0]

2

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

-- Find users that appear to only have made suggested edits (we can't see their deleted posts)
-- but whom have voted a fair amount of times.
-- This tool is designed for moderator use, as only moderators can identify if
-- an account is problematic. Several columns in the result table lead to moderator-only pages on the site.

-- DateRange: How far into the past should the query look in days
-- MinReputation: Users below this reputation will be excluded from results
-- MaxReputation: Users above this reputation will be excluded from results
-- MinUpvoteCount: How many upvotes have been cast by the user

select 
	users.id as [User Link], 
	users.reputation, 
    users.creationdate,
	users.upvotes, 
	users.downvotes,
    FORMATMESSAGE('site://admin/show-user-votes/%d', users.id) AS [Reputation Link],
    FORMATMESSAGE('site://admin/xref-user-ips/%d?daysback=0&threshold=2', users.id) AS [XRef],
    users.location, 
	users.aboutme
from users
inner join suggestededits 
	on suggestededits.owneruserid = users.id 
left outer join posts
    on posts.owneruserid = users.id
where 
	users.creationdate > DATEADD(dd, -##DateRange:int?730##, GETDATE())
	and reputation >= ##MinReputation:int?10## and reputation <= ##MaxReputation:int?100##
	and upvotes >= ##MinUpvoteCount:int?10##
group by 
	users.id, 
	users.reputation, 
	users.creationdate, 
	users.displayname, 
	users.location, 
	users.aboutme, 
	users.upvotes, 
	users.downvotes
having count(distinct suggestededits.id) >= 3
   and count(distinct posts.id) = 0
order by users.upvotes desc

Enter Parameters

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