0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gardeners and landscapers

/*
SELECT Tags.TagName, COUNT(*) as TagCount
FROM
  Posts
  JOIN PostTags ON Posts.id = PostTags.PostId
  JOIN Tags ON PostTags.TagID = Tags.Id
  WHERE
    Tags.TagName LIKE '%c++%'
GROUP BY Tags.TagName
ORDER BY TagCount DESC;
*/

SELECT TOP 100 Users.DisplayName, Users.WebsiteUrl, Users.AboutMe, COUNT(*) as PostCount
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++%'
/*    AND NOT(
      Users.WebsiteUrl = ''
      AND Users.AboutMe = ''
    )
*/
GROUP BY Users.DisplayName, Users.WebsiteUrl, Users.AboutMe
ORDER BY PostCount DESC;

view current version

edited jan 11 12

created jan 10 12 YnR