Get users by location

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow Meta en español

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

SELECT users.*
FROM users
JOIN Posts ON users.id = Posts.OwnerUserId
WHERE users.CreationDate < '2019-06-01 00:00:01'
AND users.LastAccessDate > '2022-09-09 00:00:01'
AND users.LastAccessDate < '2022-09-25 00:00:01'
AND Tags LIKE '%c#%'
AND users.DisplayName NOT IN (
  'Sinatr', 
  'Shahbaz', 
  'citronas', 
  'blindmeis', 
  'Maciek', 
  'Tar',
  'Fluffy',
  'James123',
  'stefan.at.wpf',
  'vernou',
  'Moe Sisko',
  'NoChance',
  'mark',
  'Sören Kuklau',
  'Uwe Keim',
  'Rebecca',
  'Heinrich Ulbricht',
  'fguillen',
  'Jürgen Steinblock',
  'thmshd',
  'RedX',
  'Mo B.',
  'Waescher',
  'Kirill Rakhman',
  'Enrique Moreno Tent',
  'Venson',
  'ygoe',
  'Sebastian Krysmanski',
  'Arndt Bieberstein',
  'Roland Weisleder',
  'Tom el Safadi',
  'Raul',
  'Denis Schaf',
  'Spontifixus',
  'Shi Jie Tio',
  'Mohamad Haidar',
  'Matt Mills',
  'Utkarsh Srivastav',
  'dani herrera',
  'Aaron Thomas',
  'Vikram Bose',
  'Mike Perrenoud',
  'John Livermore',
  'René Vogt',
  'Nikita Sivukhin',
  'Jim Evans',
  'Ronan Thibaudau',
  'Mong Zhu',
  'Harald Coppoolse',
  'David Brown',
  'Nick Peppers',
  'Jesús López',
  'Marco Luzzara',
  'John S',
  'Ian Kemp',
  'Alex Zaitsev',
  'Dejan Janjušević',
  'Charles Okwuagwu',
  'Tobias Knauss',
  'Daniel Möller',
  'Tom Regan',
  'INDRAJITH EKANAYAKE',
  'Peter B',
  'Yuriy Gavrishov',
  'Jesse de Wit',
  'Luke Vo',
  'Andrew Stephens',
  'roberto tomás',
  'Ardent Coder',
  'Code Pope',
  'Christoph Sonntag',
  'Subliminal Hash',
  'Ben Junior'
  
  
)
AND Reputation < 100000 AND Reputation > 2000
AND Location Not In (
  'London, UK', 
  'Iowa', 
  'Redmond, Washington, USA', 
  'South Africa'
)
AND Location Not LIKE '%USA%'
AND Location Not LIKE '%United Kingdom%'
AND Location Not LIKE '%Sweden%'
AND Location Not LIKE '%India%'
AND Location Not LIKE '%Italy%'
AND Location Not LIKE '%London%'
AND Location Not LIKE '%Stockholm%'
AND Location Not LIKE '%Lisbon%'
AND Location Not LIKE '%Paris%'
AND Location Not LIKE '%Singapore%'
AND Location Not LIKE '%Canada%'
AND Location Not LIKE '%Russia%'
AND Location Not LIKE '%New Zealand%'
AND Location Not LIKE '%Lithuania%'
AND Location Not LIKE '%Jackson%'
AND Location Not LIKE '%Czech Republic%'
AND Location Not LIKE '%San Jose%'
AND Location Not LIKE '%United States%'
AND Location Not LIKE '%Boston%'
AND Location Not LIKE '%San Francisco%'
AND Location Not LIKE '%Seattle%'
AND Location Not LIKE '%Australia%'
AND Location Not LIKE '%Rochester Hills%'
AND Location Not LIKE '%Oklahoma%'
AND Location Not LIKE '%Copenhagen%'
AND Location Not LIKE '%Czechia%'
AND Location Not LIKE '%San Diego%'
AND Location Not LIKE '%Israel%'
AND Location Not LIKE '%Spain%'
AND Location Not LIKE '%Los Angeles%'
AND Location Not LIKE '%Ireland%'
AND Location Not LIKE '%Champaign%'
AND Location Not LIKE '%Austria%'
AND Location Not LIKE '%Turkey%'
AND Location Not LIKE '%Brazil%'
AND Location Not LIKE '%Norway%'
AND Location Not LIKE '%Swizerland%'
AND Location Not LIKE '%Switzerland%'
AND Location Not LIKE '%Brazil%'
AND Location Not LIKE '%Drammen%'
AND Location Not LIKE '%South Africa%'
AND Location Not LIKE '%Taiwan%'
AND Location Not LIKE '%Netherlands%'
AND Location Not LIKE '%Philippines%'
AND Location Not LIKE '%Silicon Valley%'
AND Location Not LIKE '%Iran%'
AND Location Not LIKE '%Pakistan%'
AND Location Not LIKE '%België%'
AND Location Not LIKE '%Hong Kong%'
AND Location Not LIKE '%Connecticut%'
AND Location Not LIKE '%Minnesota%'
AND Location Not LIKE '%Houston, TX%'
AND Location Not LIKE '%Michigan%'
AND Location Not LIKE '%Belgium%'
AND Location Not LIKE '%Davic, CA%'
AND Location Not LIKE '%Hungary%'
AND Location Not LIKE '%Finland%'
AND Location Not LIKE '%Dubai%'
AND Location Not LIKE '%Mexico%'
AND Location Not LIKE '%Ukraine%'
AND Location Not LIKE '%Serbia%'
AND Location Not LIKE '%Chile%'
AND Location Not LIKE '%Japan%'
AND Location Not LIKE '%Bulgaria%'
AND Location Not LIKE '%California%'
AND Location Not LIKE '%France%'
AND Location Not LIKE '%Greece%'
AND Location Not LIKE '%Schweiz%'
AND Location Not LIKE '%Egypt%'
AND Location Not LIKE '%Poland%'
AND Location Not LIKE '%Denmark%'
AND Location Not LIKE '%Danmark%'
AND Location Not LIKE '%Lebanon%'
AND Location Not LIKE '%Slovenia%'
AND Location Not LIKE '%Minneapolis%'
AND Location Not LIKE '%Manchester%'
AND Location Not LIKE '%New York%'
AND Location Not LIKE '%Texas%'
AND Location Not LIKE '%Österreich%'
AND Location Not LIKE '%Armenia%'
AND Location Not LIKE '%Polska%'
AND Location Not LIKE '%Emirates%'
AND Location Not LIKE '%Tunisia%'
AND Location Not LIKE '%Malaysia%'
AND Location Not LIKE '%Baltimore%'
AND Location Not LIKE '%Bethlehem%'
AND Location Not LIKE '%Romania%'
AND Location Not LIKE '%Budapest%'
AND Location Not LIKE '%Cambridge%'
AND Location Not LIKE '%Vienna%'
AND Location Not LIKE '%Viena%'
AND Location Not LIKE '%Vancouver%'
AND Location Not LIKE '%Utah%'
AND Location Not LIKE 'UK'
AND Location Not LIKE '%Slovakia%'
AND Location Not LIKE '%Chicago%'
AND Location Not LIKE '%Portugal%'
AND Location Not LIKE '%England%'
AND Location Not LIKE '%Montenegro%'

AND WebsiteUrl LIKE ''
AND Score > 2
AND Posts.CreationDate > '2020-01-01 00:00:01'
--AND Tags LIKE '%wpf%'
AND ProfileImageUrl NOT IN (
'https://i.stack.imgur.com/DvyHk.jpg',
  'https://i.stack.imgur.com/tYAbK.jpg?s=128&g=1',
  'https://i.stack.imgur.com/9ACqB.jpg?s=128&g=1',
  'https://i.stack.imgur.com/dUwhF.jpg',
  'https://i.stack.imgur.com/kUHuC.jpg?s=128&g=1',
  'https://i.stack.imgur.com/xRBvI.jpg?s=128&g=1',
  'https://i.stack.imgur.com/4qBtA.png?s=128&g=1',
  'https://i.stack.imgur.com/oCXzU.jpg?s=128&g=1',
  'https://i.stack.imgur.com/w2sc2.jpg?s=128&g=1',
  'https://i.stack.imgur.com/utfmN.jpg?s=128&g=1',
  'https://i.stack.imgur.com/RsJjQ.jpg?s=128&g=1'
)

GROUP BY users.Id, users.Reputation, users.CreationDate, users.DisplayName, 
users.LastAccessDate, users.WebsiteUrl, users.Location, users.AboutMe, users.Views,
users.UpVotes, users.DownVotes,
users.ProfileImageUrl, users.EmailHash, 
users.AccountId


ORDER BY users.Location ASC;

Enter Parameters

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