0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for linguists, teachers and students of the Ukrainian language

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

created jan 10 12 YnR