with t as (select owneruserid, count(distinct tagname) nu...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Chess

Q&A for serious players and enthusiasts of chess

with t as 
(select owneruserid, count(distinct tagname) num from posts p join users u 
on p.owneruserid=u.id
join posttags pt on pt.postid=p.id
join tags tg on tg.id=pt.tagid
where p.posttypeid=1
group by owneruserid)

select * from t where num=(select max(num) from t)

Enter Parameters

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