Mod tools images, v1

1

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

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;

Enter Parameters

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