SELECT SQL_CALC_FOUND_ROWS i.title AS ContentTitle, i.id AS ContentID, i.description AS ContentDescription, i.image AS ContentImage, ADDDATE(i.created, INTERVAL 0 HOUR) AS ContentCreated, c.title AS CategoryTitle, c.id AS CategoryID, c.alias AS CategoryAlias, c.parent_id AS CategoryParent FROM #__djmt_items AS i JOIN #__djmt_albums AS c ON (i.catid = c.id) ORDER BY i.created DESC