SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams FROM #__k2_items as i RIGHT JOIN #__k2_categories AS c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1,1) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,1) AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2017-09-21 23:00:34' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2017-09-21 23:00:34' ) AND c.id IN (162) ORDER BY i.publish_up DESC, cast(i.metakey as SIGNED) DESC