Belarus Users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Monero Meta

Q&A for developers and users of the secure, private and untraceable cryptocurrency Monero

SELECT
    ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], 
    Users.Id AS [User Link],     
    Users.Reputation,
    COUNT(case PostTypes.Name when 'Answer' then 1 else null end) AS 'A',
    COUNT(case PostTypes.Name when 'Question' then 1 else null end) AS 'Q',
    MAX(case PostTypes.Name when 'Answer' then Posts.Score else null end) AS 'MxA',
    MAX(case PostTypes.Name when 'Question' then Posts.Score else null end) AS 'MxQ',
    Users.Views,
    Users.LastAccessDate
FROM
    Users, Posts, PostTypes
WHERE
    (LOWER(Location) LIKE LOWER('%belarus%') OR LOWER(Location) LIKE LOWER('%minsk%')) AND
    Reputation > 15 AND
    Posts.OwnerUserId = Users.Id AND
    Posts.PostTypeId = PostTypes.Id
GROUP BY
    Users.Id, Users.Reputation, Users.Views, Users.LastAccessDate
ORDER BY
    Reputation DESC;

Enter Parameters

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