Tags Query

0

Please login or register to vote for this query.

(click on this box to dismiss)

Philosophy Meta

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

-- Select TagName, [Count]
-- From Tags
-- Where [Count]>10
-- Order By Count Desc;

-- Select TagName, [Count]
-- From Tags
-- Where TagName like '%oracle%'
-- Order By Count Desc;

SELECT TOP(50)
  q.Id AS [Post Link],
  q.ViewCount, q.Score,
  q.OwnerUserId AS [User Link],
  q.OwnerDisplayName,
  q.Tags
FROM Posts q 
INNER JOIN PostTags pt ON q.Id = pt.PostId
INNER JOIN Tags t ON pt.TagId = t.Id
WHERE (q.PostTypeId=1)
---only questions (although answers do not have tags, so this is not necessary)
  AND (t.TagName in ('arm', 'arm-template','arm64','armv7','armv6','armcc','archlinux-arm','gnu-arm','arm9','armasm','scala-arm','arm-linux'))  
ORDER BY q.ViewCount ASC;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results