0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for committed Christians, experts in Christianity and those interested in learning more

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
      )
    AND p1.Score > 0
ORDER BY p1.Score DESC

fork query

edited jul 7 20

created jul 7 20 anonymous