Most popular tags in last year

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

Q&A for Joomla! administrators, users, developers and designers

SELECT
  COUNT(PostId) AS Rate, TagName
FROM
  Tags, PostTags, Posts
WHERE 
  Tags.TagName = 'Python'
  
  AND
  Posts.CreationDate > 2018
GROUP BY 
  TagName, Posts.CreationDate
ORDER BY
  Rate DESC

Enter Parameters

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