HNQ hits with proposed autofilters

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

SELECT 
  MIN(ph.CreationDate) as [Date],
  p.Id AS [Post Link],
  MIN(ph2.CreationDate) as [Removed],
  MIN(p.ClosedDate) as [Closed]
FROM PostHistory ph
JOIN Posts p ON p.Id = ph.PostId
LEFT JOIN PostHistory ph2
  ON p.Id = ph2.PostId
  AND ph2.PostHistoryTypeId = 53 -- HNQ removal event
WHERE
  p.PostTypeId = 1 -- Question
  AND ph.PostHistoryTypeId = 52 -- HNQ hit event
  AND p.Title NOT LIKE '%$%$%' -- MathJax titles are already exluded from HNQ
  -- The following list is from https://math.meta.stackexchange.com/questions/31425/autofilters-for-hot-network-questions
  AND p.Title NOT LIKE '%this%'
  AND p.Title NOT LIKE '%problem%'
  AND p.Title NOT LIKE '%question%'
  AND p.Title NOT LIKE '%puzzle%'
  AND p.Title NOT LIKE '%contest%'
  AND p.Title NOT LIKE '$advice%'
  AND p.Title NOT LIKE '%help%'
  AND p.Title NOT LIKE '%please%'
  AND p.Title NOT LIKE '%the following%'
  AND p.Title NOT LIKE '%exercise%'
  AND p.Title NOT LIKE '%easy%'
  AND p.Title NOT LIKE '%opinion%'
  AND p.Title NOT LIKE '%solve%'
  AND p.Title NOT LIKE '%solving%'  
  AND p.Title NOT LIKE '%difficult%'
  AND p.Title NOT LIKE '%urgent%'
  AND p.Title NOT LIKE '%tricky%'
  AND p.Title NOT LIKE '%simplify%'
GROUP BY p.Id
ORDER BY MIN(ph.CreationDate) DESC

Enter Parameters

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