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 Users.Id as [User Link], count(*) as effectif
FROM 
Users JOIN Posts ON Users.Id = Posts.OwnerUserId
JOIN PostTags ON PostTags.PostId = Posts.Id
JOIN Tags ON Tags.Id = PostTags.TagId 
WHERE LOWER(Users.Location) LIKE '%france%'
AND LOWER(Tags.TagName) LIKE '%python%'
AND Posts.PostTypeId=2
GROUP BY Users.Id
ORDER BY effectif desc;

fork query

edited aug 3

created aug 3 anonymous