Q&A for users, experts, and developers of the Tezos blockchain project
select u.id as [User Link] , sum(score) as totalscore from posts p inner join posttags pt on pt.postid = p.id or pt.postid = p.parentid inner join tags t on t.id = pt.tagid inner join users u on u.id = p.owneruserid where tagname = ##tag1:string## collate SQL_Latin1_General_CP1_CI_AI and location like '%'+ ##location:string## + '%' collate SQL_Latin1_General_CP1_CI_AI group by u.id order by sum(score) desc