1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users, experts, and developers of the Tezos blockchain project

select t.tagname
from posts p
join users u on u.id = p.owneruserid
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) > 10
and count(case when lower(u.location) like '%iceland%' then 1 end) > 15

fork query

created dec 9 19 Kamushek