Find users with Website by location

0

Please login or register to vote for this query.

(click on this box to dismiss)

Network Engineering

Q&A for network engineers

-- Find users with Website by location

Select u.id as [User Link], u.DisplayName, u.reputation,
u.Location, u.WebsiteUrl, u.aboutme
from Users u
where (u.Location like ##Location:string## 
OR u.aboutme like ##Location:string##)
and u.websiteurl like 'http://%' 
and u.websiteurl not like 'http://%google.%' 
and u.websiteurl not like 'http://stackoverflow.%'
order by u.reputation desc

Enter Parameters

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