Top Tags, May 2010

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

-- merge below with above for top ten/month
select (select TagName from Tags where Tags.id=tgs.tagid), count(tgs.tagid)
from posttags tgs, posts questions
where questions.id=tgs.postid
and year(questions.creationdate) = 2010
and month(questions.creationdate) = 5
group by tgs.tagid
order by count(tgs.tagid) desc

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results