select t.tagname from posts p join users u on p.owneruser...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans

Q&A for music historians, critics, and fans

select t.tagname
from posts p
join users u on p.owneruserid = u.id
join posttags pt on pt.postid = p.id
join tags t on t.id = pt.tagid
where p.posttypeid = 1
group by t.tagname 
having count(case when lower(u.location) like 'nigeria' then 1 end) > 100
and count (case when lower(u.location) like 'iceland' then 1 end) > 15

Enter Parameters

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