Please login or register to vote for this query.

(click on this box to dismiss)

Bicycles Meta

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

SELECT u.Id AS [User Link],       -- The link to the user's profile
       u.Reputation,              -- The reputation score of the user
       u.DisplayName,             -- The name of the user
       u.Location,                -- The location of the user
       u.WebsiteUrl               -- The website URL provided by the user
FROM Users u                      -- The table containing user information
WHERE u.Location LIKE '%##Location##%' -- Condition to filter users by location pattern
  AND u.WebsiteUrl <> ''          -- Condition to ensure the website URL is not empty
ORDER BY u.Reputation DESC;       -- Sorting the results by reputation in descending order

Enter Parameters

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