JMS details

0

Please login or register to vote for this query.

(click on this box to dismiss)

Constructed Languages

Q&A for designers and users of artificial or invented languages, consciously developed instead of having developed naturally

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 IN ('jms')
        INTERSECT
        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 IN ('activemq')
        
  )
GROUP BY ext_t.TagName
ORDER BY PostCount DESC

Enter Parameters

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