dates

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 top 10 t.TagName, count(p.tags)
from (select TagName
      from tags 
      where (TagName = '%android%'))as t
left join (select tags,CreationDate
          from posts
          where (tags = 'android') 
          AND (year(CreationDate) = 2017)) as p
    on p.Tags like CONCAT('%', t.TagName ,'%')
group by t.TagName
order by count(p.Tags) desc

Enter Parameters

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