0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for administrators, end users, developers and designers for Craft CMS

SELECT TOP 100 DisplayName,Reputation,TagName,COUNT(1) AS foo
  FROM Users 
  INNER JOIN Posts
    ON Posts.Id = Users.Id
  INNER JOIN Votes
    ON Posts.Id = Votes.PostId
  INNER JOIN PostTags
    ON Posts.Id = PostTags.PostId
  INNER JOIN Tags
    ON PostTags.TagId = Tags.Id
    AND TagName IN ('scipy','ipython','numpy','machine-learning','scikit-learn')
  WHERE  
      (
        Location LIKE '%London%'
        OR Location LIKE '%london%'
        OR Location LIKE '%United Kingdom%'
      ) AND Location NOT LIKE '%ntario%'
  GROUP BY DisplayName,Reputation,TagName
  ORDER BY COUNT(1) DESC

fork query

edited jul 2 14

created jul 2 14 anonymous