0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for users of TeX, LaTeX, ConTeXt, and related typesetting systems

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

fork query

created dec 14 17 anonymous