Most Tags for a given Date

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 *,(100.0*anzahl/sum(anzahl)over())as ratings
from (
  select tagname,count(tagname) anzahl
  from (
    select id
    from posts 
    where month(creationdate)=##pMonth## and year(creationdate)=##pYear##) q1
  join posttags on q1.id=postid
  join tags t on tagid=t.id
  group by tagname) q2
order by anzahl desc

Enter Parameters

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