access-vba posts with >5 tags after retagging

0

Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

SELECT p.Id As [Post Link], p.Tags
FROM Posts p
  INNER JOIN PostTags pt ON p.Id = pt.PostId
WHERE 
  pt.TagId = 16957 --access-vba
  AND EXISTS (
    SELECT 1
    FROM PostTags pt2
    WHERE pt2.PostId = p.Id
    AND Not pt2.TagId IN(930, 1449) --vba, ms-access
    HAVING COUNT(*) >= 5 --Number of tags must be 5, not counting vba and ms-access
  )

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results