select id, name, location, score from ( select Users.id a...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

select id, name, location, score
from (
    select Users.id as id, Users.location as location, Users.displayname as name,  sum(p1.score) as score
    from Users
        inner join Posts p1 on p1.owneruserid = Users.id
        inner join Posts p2 on p2.id = p1.parentid
    where (Users.location like '%oscow%' or Users.location like '%Russia%' or Users.location like '%russia%' or Users.location like '%росси%' or Users.location like '%Росси%' or Users.location like '%осква%')
    and (p2.tags like '%python%' or p2.tags like '%Python%')
	        and p1.posttypeid = 2
        and p2.posttypeid = 1
    group by Users.id, Users.location, Users.displayname
) as tags where score > 0
order by score desc

Enter Parameters

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