Q&A for Joomla! administrators, users, developers and designers
select id, posttypeid from posts where creationdate like '%2017%';