0

Please login or register to vote for this query.

(click on this box to dismiss)

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.Title AS [Post Title],
  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 DESC;

fork query

edited jan 18

created jan 17 anonymous