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-05-29 11:24:08' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2017-05-29 11:24:08' ) AND c.id IN (137,138,172) AND i.featured != 1 ORDER BY i.id DESC, cast(i.metakey as SIGNED) DESC