Most Views


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 ID, Title, parentid,Creationdate from posts where posttypeid=2 and id in (
select Postid from posthistory where posthistorytypeid=16 
and year(creationdate) in (2018,2017,2016,2015))
order by Creationdate

Enter Parameters

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