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, parentid,creationdate
FROM Posts  
   where PostTypeId=2 and id in
   (Select Postid from posthistory where posthistorytypeid=16 and
   year(Creationdate) in (2014,2015,2016,2017,2018)
   order by creationdate

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results