0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

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

fork query

created may 27 anonymous