Última hora
:
 
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 13:02:21' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2017-09-21 13:02:21' ) AND c.id=150 ORDER BY i.title, cast(i.metakey as SIGNED) DESC

Grandes Tiradas en

  • 1