0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited mar 1 17

created mar 1 17 anonymous