Q&A about the site for people organizing, marketing or licensing open source development projects
DECLARE @tagName nvarchar(35) = '##tagName##' SELECT top 100 ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Users.DisplayName as UserName, TagName, Location, Reputation FROM Tags INNER JOIN PostTags ON PostTags.TagId = Tags.id INNER JOIN Posts ON Posts.ParentId = PostTags.PostId INNER JOIN Users ON Posts.OwnerUserId = Users.Id INNER JOIN Votes ON Votes.PostId = Posts.Id WHERE Tags.TagName = @tagName AND LOWER(Location) LIKE LOWER('% Bangalore, INDIA%') AND Posts.CommunityOwnedDate IS NULL GROUP BY TagName, DisplayName, Location, Reputation ORDER BY Reputation DESC