SELECT us.*,tuser.Score,Id [User Link] From Users us join...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Webmasters

Q&A for pro webmasters

SELECT us.*,tuser.Score,Id [User Link]
From Users us
join
((SELECT Answers.OwnerUserID AS UserID, SUM(Answers.Score) AS Score
  FROM Tags
  JOIN PostTags ON Tags.ID = PostTags.TagID
  JOIN Posts ON Posts.ID = PostTags.PostID
  JOIN Posts Answers ON Answers.ParentID = Posts.ID
  WHERE Tags.TagName
  IN ('kafka','apache kafka','apache-kafka')
  Group by answers.owneruserid
  ) union
(select u.id as Userid, 0 AS score
From Users u
Where lower(u.AboutMe) like '%kafka%'
))
tuser ON tuser.userid = us.id
WHERE
lower(location) like 'india' OR
lower(location) like 'gurgaon' OR
lower(location) like 'bangalore' OR
lower(location) like 'bengaluru' OR
lower(location) like 'mumbai' OR
lower(location) like 'delhi' OR
lower(location) like 'hyderabad' OR
lower(location) like 'secunderabad' OR
lower(location) like 'karnataka' OR
lower(location) like 'tamil' OR
lower(location) like 'maharashtra' OR
lower(location) like 'andra' OR
lower(location) like 'telangana' OR
lower(location) like 'kerala' OR
lower(location) like 'cochin' OR
lower(location) like 'trivandrum' OR
lower(location) like 'coimbatore' OR
lower(location) like 'mysore' OR
lower(location) like 'mysuru' OR
lower(location) like 'maharashtra' OR
lower(location) like 'ahmedabad' OR
lower(location) like 'kolkata' OR
lower(location) like 'ncr' OR
lower(location) like 'chennai' OR
lower(location) like 'pune'
Order BY tuser.score DESC

Enter Parameters

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