Top Users by Country

0

Please login or register to vote for this query.

(click on this box to dismiss)

Created by samliew (http://stackoverflow.com/users/584192/samuel-liew)

Mathematica

Q&A for users of Mathematica

SELECT
    Users.Id as [User Link]
    , Users.DisplayName
    , COUNT (atags.Id) AS Number_of_Tag_Badges
FROM 
    tags atags
    --INNER JOIN Tags ON Tags.TagName = Badges.Name
    --INNER JOIN Users ON Users.Id = atags.UserId
    --INNER JOIN Users ON Users.Id = p.owneruserid
	
	inner join posttags pt on pt.tagid = atags.id
	inner join posts p on pt.postid in (p.id, p.parentid)
	INNER JOIN Users ON Users.Id = p.owneruserid
WHERE LOWER(Users.Location) LIKE 'malaysia'
GROUP BY Users.DisplayName, Users.Id
ORDER BY Number_of_Tag_Badges DESC

Enter Parameters

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