Q&A about the site for administrators, end users, developers and designers for Craft CMS
select a.*,b.* from posts a,tags b where a.Id=b.Id and year(a.CreationDate)=2017;