Select answers for given tag for a user between two dates, includes whether accepted answer


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for users of Iota, the open-source cryptocurrency for IoT that does not use a blockchain

select as [User Link]
     , sum(score) as totalscore
from posts p
inner join posttags pt on pt.postid = 
                       or pt.postid = p.parentid
inner join tags t on = pt.tagid
inner join users u on = p.owneruserid
where tagname = ##tag1:string## collate SQL_Latin1_General_CP1_CI_AI 
and lower(location) like '%saudi%' or
(lower(location) like '%saudi arabia%' 
group by
order by sum(score) desc

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results