Вопросы и ответы о сайте для программистов
-- 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