One character links (potentially spam links)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- 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, p.Body
  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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results