Find possible Spam-Users

0

Please login or register to vote for this query.

(click on this box to dismiss)

This query lists 1-Rep-Users which wrote at least 3 answers with a link in it or referred to Google.

Stack Overflow

Q&A for professional and enthusiast programmers

-- Find possible Spam-Users
-- This query lists 1-Rep-Users which wrote
-- at least 3 answers with a link in it
-- or referred to Google.

SELECT
  u.Id AS [User Link],
  COUNT(u.Id)
FROM
  Posts AS p
  JOIN Users AS U
  ON p.OwnerUserId = u.Id
WHERE
  p.PostTypeId = 2 AND
  (p.Body LIKE '%http:%' OR p.Body LIKE '%Google%') AND
  u.Reputation = 1
GROUP BY
  u.Id,
  u.DisplayName
HAVING
  COUNT(u.Id) >= 2
ORDER BY
  u.DisplayName ASC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results