1

Please login or register to vote for this query.

(click on this box to dismiss)

This query will find instances of the @user auto-link functionality that once existed.

Q&A for anime and manga fans

-- Find the magical ping markup
-- This query will find instances of the @user auto-link functionality that once existed.

SELECT
  Id as [Post Link],
  LastEditDate,
  CreationDate
FROM Posts
WHERE
  PostTypeId = 2
  AND Body LIKE '<p>@<a href="#%'
ORDER BY
  LastEditDate DESC,
  CreationDate DESC

fork query

created nov 3 11 Mark Trapp