0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for followers of the Hindu religion and those interested in learning more about Hinduism

SELECT TOP 10000 Users.DisplayName, Users.Location, Users.Id, Users.Reputation, Users.WebsiteUrl, Users.AboutMe
FROM
  Users
  JOIN Posts ON Posts.OwnerUserId = Users.Id
  JOIN PostTags ON Posts.id = PostTags.PostId
  JOIN Tags ON PostTags.TagID = Tags.Id
  WHERE
    Tags.TagName LIKE '%c++%'
    OR
    Tags.TagName LIKE '%objective-c%'
    AND NOT(
      Users.WebsiteUrl = ''
      AND Users.AboutMe = ''
    )
GROUP BY Users.DisplayName, Users.Location, Users.Id, Users.WebsiteUrl, Users.AboutMe, Users.Reputation
ORDER BY Reputation DESC;

fork query

edited jan 11 12 anonymous

created jan 10 12 YnR