Q&A for Joomla! administrators, users, developers and designers
select p.Id, t.TagName From Posts p LEFT JOIN PostTags pt ON p.Id = pt.PostId LEFT JOIN Tags t ON pt.TagId = t.Id ORDER BY p.CreationDate Desc