0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

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