1

Please login or register to vote for this query.

(click on this box to dismiss)

Useful for finding astroturfing or just general cleanup

Q&A about the site for music historians, critics, and fans

SELECT
  Id as [Post Link],
  *
FROM Posts as p
WHERE
  p.Body LIKE '%<p>#' + ##hashtag:string?[Aa]pache-[Aa]ge## + '%'
  AND DateDiff(day, p.CreationDate, GetDate()) < ##MaxDaysAgo?30##
  AND DateDiff(day, p.CreationDate, GetDate()) > ##MinDaysAgo?0##

fork query

edited jan 4 24

created jan 4 24 General.Grievance