test

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

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

SELECT
Count(DISTINCT Users.Id),
Tags.TagName as Tag_Name
FROM
Users, Posts, PostTags, Tags
WHERE
Posts.OwnerUserId = Users.Id AND
PostTags.PostId = Posts.Id AND
Tags.Id = PostTags.TagId AND
Posts.Score > 15 AND
Posts.CreationDate BETWEEN '1/1/2018' AND '1/1/2019' AND
Tags.TagName IN ('python', 'r', 'java', 'perl', 'sql', 'c#', 'c
++')
GROUP BY
Tags.TagName

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results