Users located in Missouri

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- retrieves users who give Missouri as part of their location
select displayName, Reputation, WebsiteUrl, Location, AboutMe from Users 
where (upper(location) like '%MISSOURI%' and upper(location) <> 'MISSOURI CITY, TX')
or (location like '%MO%'
and not (upper(location) like '%MOROCCO')
and not (upper(location) like 'MOHALI%')
and not (upper(location) like 'HERMOSILLO%')
and not (upper(location) like '%RUSSIA')
and not (upper(location) in (
'SNEGIRI, MO, RUSSIA',
'UNDEMOCRACY CHINA',
'MOTHER RUSSIA',
'AMOY.CN',
'MOGI GUAÇU',
'SPMO, COSTA RICA',
'$_SERVER[''REMOTE_ID''];')))
order by Reputation desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results