Q&A for Drupal developers and administrators
----based on https://data.stackexchange.com/mathoverflow/query/901680/finding-possible-suspended-users DECLARE @minBadges int = '##MinBadges?10##' ;With CTE AS ( SELECT UserId,COUNT(*) AS TotalBadges FROM Badges GROUP BY UserId ) SELECT ID AS [User Link], DisplayName, Reputation, TotalBadges FROM Users JOIN CTE ON Users.ID = CTE.UserId WHERE Users.Reputation = 1 AND TotalBadges >= @minBadges ORDER BY TotalBadges DESC, Users.ID