0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for linguists, teachers and students of the Ukrainian language

SELECT ext_t.TagName, COUNT(ext_pt.PostId) as PostCount
FROM PostTags ext_pt 
  INNER JOIN Tags ext_t ON ext_pt.TagId = ext_t.Id
WHERE ext_pt.PostId IN (
      SELECT p.Id
      FROM Posts p 
        INNER JOIN PostTags pt ON p.Id = pt.PostId
        INNER JOIN Tags t on pt.TagId = t.Id
      WHERE t.TagName = 'jms' 
      AND t.TagName = 'ibm-mq'
  )
GROUP BY ext_t.TagName
ORDER BY PostCount DESC

fork query

edited aug 17 19

created aug 14 19 anonymous