0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

-- Enter Query Title
-- Enter Query Description
--select pt.PostId, p.Title, COUNT(p.Tags) as TagsCount from PostTags pt 
--inner join Posts p on pt.PostId = p.Id
--where pt.TagId=131229
--group by p.Tags, pt.PostId, p.Title

select count(*), t.tagname from PostTags pt
inner join Posts p on pt.PostId = p.Id
inner join Tags t on pt.TagId = t.Id
where p.Id in (SELECT pt.PostId from PostTags pt WHERE pt.TagId=1386)
AND p.Id in (SELECT pt.PostId from PostTags pt WHERE pt.TagId=17)
Group by t.tagname

-- SELECT Id, TagName FROM Tags WHERE TagName = 'android' or TagName = 'kotlin' or TagName = 'java'

fork query

edited may 31

created oct 1 14 anonymous