0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for aircraft pilots, mechanics, and enthusiasts

SELECT p1.Id as [Post Link] FROM Posts p1
WHERE 
    p1.OwnerUserId = 5052365
    AND NOT EXISTS (
      SELECT * FROM PostTags
      INNER JOIN Posts p2 ON p2.ParentId = PostTags.PostId
      WHERE p2.Id = p1.Id AND PostTags.TagId = 16
      )
ORDER BY p1.Score DESC

fork query

edited jul 7

created jul 7 anonymous