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

0

Please login or register to vote for this query.

(click on this box to dismiss)

Chinese Language Meta

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Chinese language

select *
     -- 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
 lower(location) like '%saudi%' or
(lower(location) like '%saudi arabia%' 
) 
--group by u.id
--order by sum(score) desc

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results