0

Please login or register to vote for this query.

(click on this box to dismiss)

A simply query to find users in your city or country. Added user links to the original version.

Q&A about the site for electronic hardware hacking enthusiasts

select DISTINCT  u.Id [User Link],
                 u.Reputation,
                 u.DisplayName,
                 u.Location,
                 u.AboutMe
from (Users as u LEFT JOIN Comments as c on u.id = c.userId)
      LEFT JOIN Posts as p on c.PostId = p.id
where upper(u.Location) like '%##Location##%' 
      AND 
        (    upper(u.AboutMe) like '%##LANG##%'
         OR  upper(p.Tags)    like '%##LANG##%'
        )

order by Reputation desc

fork query

edited oct 23 17 anonymous

created aug 13 10 georg.fritzsche