select u.id, u.DisplayName, u.location, u.Reputation, p.t...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

select u.id, u.DisplayName, u.location, u.Reputation, p.tags 
from Users u join posts p
on u.id = p.id
where u.location like '%India%' or 
u.location like '%çhennai%' 
and p.tags = 'ios'
--and p.tags in ('ios', 'swift', 'mvvm', 'python', 'django', 'javascript', 'react.js') 
--,'%india%','%Chennai%','%India%')

Enter Parameters

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