One character links (potentially spam links)

2

Please login or register to vote for this query.

(click on this box to dismiss)

Project Management

Q&A for project managers

-- See https://chat.stackexchange.com/transcript/message/52231124
-- for a bunch of posts detected with this query
SELECT p.Id AS [Post Link], p.CreationDate, p.Score,
  p.OwnerUserId AS [User Link], u.Reputation
  FROM Posts AS p
  INNER JOIN Users AS u
    ON p.OwnerUserId = u.Id
  WHERE p.Body LIKE '%>_</a>%'
    AND p.CreationDate BETWEEN ##fromDate:string?2001-01-01##
                           AND ##tillDate:string?2999-12-31##
    AND u.Reputation <= 100 -- to reduce the # of false positives
    AND p.Score < 5

Enter Parameters

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