Q&A about the site for professional and enthusiast programmers
SELECT p.Id AS [Post Link], p.OwnerUserId AS [User Link], p.CreationDate FROM Posts p INNER JOIN ( SELECT DISTINCT h.PostId FROM PostHistory h WHERE h.Text LIKE '%<featured>%' ) f ON p.Id = f.PostId WHERE LOWER(p.Title) LIKE '%blog%' OR LOWER(p.Body) LIKE '%blog%' AND CONVERT(DATE, p.CreationDate) <> '2017-01-29' ORDER BY p.CreationDate DESC