1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for amateur radio enthusiasts

WITH Q AS (
  SELECT DISTINCT
    COALESCE(Posts.ParentId, Posts.Id) AS Id
  FROM Posts
  LEFT JOIN PostTags ON COALESCE(Posts.ParentId, Posts.Id) = PostTags.PostId
  LEFT JOIN Tags ON Tags.Id = PostTags.TagId
  WHERE
    Tags.TagName LIKE 'mod%'
    AND
    LOWER(Posts.Body) LIKE '%<img src="%'
)
SELECT
  Q.Id AS [Post Link],
  Posts.*
FROM Q
LEFT JOIN Posts ON Q.Id = Posts.Id
ORDER BY Posts.LastActivityDate;

fork query

edited may 26 17

created may 26 17 peterh