Posts with a specific hashtag in them

1

Please login or register to vote for this query.

(click on this box to dismiss)

Useful for finding astroturfing or just general cleanup

Computational Science

Q&A for scientists using computers to solve scientific problems

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##

Enter Parameters

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