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.

Q&A for anime and manga fans

-- 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
  ROW_NUMBER() OVER (ORDER BY u.DisplayName ASC, u.Id ASC),
  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,
  u.Id ASC

fork query

created apr 20 11 Bobby