Users from Tamil Nadu

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT Reputation, DisplayName, Location FROM Users WHERE (Location 
LIKE '%Ariyalur%' OR Location 
LIKE '%Tamil Nadu%' OR Location 
LIKE '%Tamil nadu%' OR Location
LIKE '%TN%' OR Location
LIKE '%Chennai%' OR Location
LIKE '%chennai%' OR Location
LIKE '%Coimbatore%' OR Location 
LIKE '%Cuddalore%' OR Location 
LIKE '%Dharmapuri%' OR Location 
LIKE '%Dindigul%' OR Location 
LIKE '%Erode%' OR Location 
LIKE '%Kanchipuram%' OR Location 
LIKE '%Kanniyakumari%' OR Location 
LIKE '%karur%' OR Location 
LIKE '%Krinshnagiri%' OR Location 
LIKE '%krinshnagiri%' OR Location 
LIKE '%Madurai%' OR Location 
LIKE '%Nagapattinam%' OR Location 
LIKE '%Namakkal%' OR Location 
LIKE '%Nilgiris%' OR Location 
LIKE '%Nilgiri%' OR Location 
LIKE '%The Nilgiris%' OR Location 
LIKE '%Perambalur%' OR Location 
LIKE '%Salem%' OR Location 
LIKE '%Sivaganga%' OR Location 
LIKE '%Thanjavur%' OR Location 
LIKE '%Theni%' OR Location 
LIKE '%Thoothukudi%') AND Location
LIKE '%Theni%' OR Location
LIKE '%Thoothukudi%' OR Location
LIKE '%Thiruvarur%' OR Location
LIKE '%Thirunelveli%' OR Location
LIKE '%Thiruchirappalli%' OR Location
LIKE '%Thiruchy%' OR Location
LIKE '%Thrichy%' OR Location
LIKE '%Thiruvallur%' OR Location
LIKE '%Tiruppur%' OR Location
LIKE '%Tiruvannamalai%' OR Location
LIKE '%Vellore%' OR Location
LIKE '%Villupuram%' OR Location
LIKE '%Virudhunagar%' OR Location
LIKE '%Nagercoil%' OR Location
NOT LIKE '%New Mexico%' AND Reputation > 10
ORDER BY Reputation DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results