with new as( select t.TagName name, count(p.Id) cnt from ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Homebrewing

Q&A for dedicated home brewers and serious enthusiasts

with new as( select t.TagName name, count(p.Id) cnt
from Posts p join PostTags pt on p.Id=pt.PostId
     join Tags t on pt.TagId=t.Id
where p.Tags like '%<mysql>%' and t.TagName <>'my sql'
group by t.TagName)
select name, cnt
from new
/*where cnt = (select max(cnt)
           from new)*/

Enter Parameters

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