1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Drupal developers and administrators

SELECT *,
CONCAT('https://stackoverflow.com/users/', Id) AS profile
FROM Users 
WHERE /* knows clojure */
      LOWER(AboutMe) LIKE '%clojure%' AND 
      /* might be looking for a job */
      (
        LOWER(AboutMe) LIKE '%freelance%' OR
        LOWER(AboutMe) LIKE '%opportunity%' OR
        LOWER(AboutMe) LIKE '%offer%' OR
        LOWER(AboutMe) LIKE '%my next%' OR
        LOWER(AboutMe) LIKE '%jobs%' OR
        LOWER(AboutMe) LIKE '%remote%'
      ) AND
      /* not from the US */
      LOWER(Location) NOT LIKE '%united states%' AND
      Location NOT LIKE '%US%' AND
      Location NOT LIKE '%, AL%' AND
      Location NOT LIKE '%, AK%' AND
      Location NOT LIKE '%, AZ%' AND
      Location NOT LIKE '%, AR%' AND
      Location NOT LIKE '%, CA%' AND
      Location NOT LIKE '%, CO%' AND
      Location NOT LIKE '%, CT%' AND
      Location NOT LIKE '%, DE%' AND
      Location NOT LIKE '%, FL%' AND
      Location NOT LIKE '%, GA%' AND
      Location NOT LIKE '%, HI%' AND
      Location NOT LIKE '%, ID%' AND
      Location NOT LIKE '%, IL%' AND
      Location NOT LIKE '%, IN%' AND
      Location NOT LIKE '%, IA%' AND
      Location NOT LIKE '%, KS%' AND
      Location NOT LIKE '%, KY%' AND
      Location NOT LIKE '%, LA%' AND
      Location NOT LIKE '%, ME%' AND
      Location NOT LIKE '%, MD%' AND
      Location NOT LIKE '%, MA%' AND
      Location NOT LIKE '%, MI%' AND
      Location NOT LIKE '%, MN%' AND
      Location NOT LIKE '%, MS%' AND
      Location NOT LIKE '%, MO%' AND
      Location NOT LIKE '%, MT%' AND
      Location NOT LIKE '%, NE%' AND
      Location NOT LIKE '%, NV%' AND
      Location NOT LIKE '%, NH%' AND
      Location NOT LIKE '%, NJ%' AND
      Location NOT LIKE '%, NM%' AND
      Location NOT LIKE '%, NY%' AND
      Location NOT LIKE '%, NC%' AND
      Location NOT LIKE '%, ND%' AND
      Location NOT LIKE '%, OH%' AND
      Location NOT LIKE '%, OK%' AND
      Location NOT LIKE '%, OR%' AND
      Location NOT LIKE '%, PA%' AND
      Location NOT LIKE '%, RI%' AND
      Location NOT LIKE '%, SC%' AND
      Location NOT LIKE '%, SD%' AND
      Location NOT LIKE '%, TN%' AND
      Location NOT LIKE '%, TX%' AND
      Location NOT LIKE '%, UT%' AND
      Location NOT LIKE '%, VT%' AND
      Location NOT LIKE '%, VA%' AND
      Location NOT LIKE '%, WA%' AND
      Location NOT LIKE '%, WV%' AND
      Location NOT LIKE '%, WI%' AND
      Location NOT LIKE '%, WY%' AND
      Location NOT LIKE '%, DC%' AND
      Location NOT LIKE '%, AS%' AND
      Location NOT LIKE '%, GU%' AND
      Location NOT LIKE '%, MP%' AND
      Location NOT LIKE '%, PR%' AND
      Location NOT LIKE '%, VI%'
ORDER BY Reputation DESC

fork query

edited jan 19

created jan 19 marmor