0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

SELECT 
      u.Id AS [User Link],
      u.Location AS [Location],
      u.LastAccessDate AS [Last Access],
      u.WebsiteUrl AS [URL],
      u.Reputation AS [Rep]
FROM 
    Users u 
    INNER JOIN Tags t  ON t.Id =  u.Id
    INNER JOIN Posts p ON p.Id =  u.Id    
WHERE 
     Location like '%##Location##%' OR
     u.AboutMe like '%##Location##%'
ORDER BY 
  Reputation DESC

fork query

edited feb 1 13 anonymous

created jan 12 13 jon.doe10275