0

Please login or register to vote for this query.

(click on this box to dismiss)

List of StackOverflow users from Turkey.

Q&A about the site for software quality control experts, automation engineers, and software testers

SELECT *
    FROM 
		Users U2
		left join
		(
			select count(P.UserId) as posts, U.Id
			from Users U
			inner join PostHistory P
			on (U.Id = P.UserId)
			group by U.Id
		) as Counted
		on (Counted.Id = U2.Id)
   WHERE    
lower(location) like '%united kingdom%' or
(lower(location) like '%england%' 
and lower(location) not like '%new england%'
) 
or
(lower(location) like '%london%' 
and lower(location) not like 'london%on' 
and lower(location) not like '%ontario%'
and lower(location) not like '%canada%'
)
or
(lower(location) like '%uk%' 
and lower(location) not like '%ukraine%' )
or
lower(location) like '%sussex%'
or
lower(location) like '%bristol%'

ORDER BY Reputation DESC

fork query

edited sep 26 13 haveaguess

created dec 4 11 Emre Erkan