with T as (select tagname, count(*) cnt from posts p join...

0

Please login or register to vote for this query.

(click on this box to dismiss)

elementary OS Meta

Q&A for developers and users of elementary OS and applications

with T as (select tagname, count(*) cnt
from posts p
join posttags pt on p.id = pt.postid
join tags t on t.id = pt.tagid
where lower(tags) like '%<mysql>%' and lower(T.tagname) <> 'mysql'
group by tagname)

select * from T Where cnt = (select MAX(cnt) from T);

Enter Parameters

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