0

Please login or register to vote for this query.

(click on this box to dismiss)

A list of users with tag-based gold badges in a given country

Q&A for professional and enthusiast programmers

SELECT
    distinct
    Users.Id AS [User Link],
    Reputation
FROM
    Users, Badges
WHERE
    LOWER(Users.Location) LIKE LOWER('%##CountryName##%')
    AND Users.Id = Badges.UserId
    -- AND Badges.Class = 1
    AND Badges.name = '##TagName##'
ORDER BY
    Reputation DESC;

fork query

edited apr 29 17 57skies

created nov 16 16 anonymous