tags distribution on the major legal tags non-legal related

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top 10 t.tagname 
     , count(*) as [Number of Question]
from posttags pt 
inner join posttags bpt on pt.postid = bpt.postid
inner join tags bt on bt.id = bpt.tagid
inner join tags t on t.id = pt.tagid and t.id <> bt.id
where bt.tagname = '##tag##'
and t.tagname not in 
( 'licensing'
, 'gpl'
, 'open-source'
, 'lgpl'
, 'legal'
, 'mit-license'
, 'apache-license'
, 'commercial'
, 'gplv3'
, 'license-key'
, 'bsd-license' 
)
group by t.tagname
order  by count(*) desc

Enter Parameters

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