Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

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

select DISTINCT COUNT(Posts.Id) from Posts 
join PostTags on PostTags.PostId=Posts.Id
join Tags on Tags.Id = PostTags.TagId 
where PostTypeId = 1 and CreationDate > '2015-01-01' and CreationDate < '2016-12-31'and (Tags.TagName LIKE ##tag:string##)

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results