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-04-28 04:35:36' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2017-04-28 04:35:36' ) AND c.id IN (124,112,113,114,115,116,118,120,121,122,123,136) AND i.featured != 1 ORDER BY i.id DESC, cast(i.metakey as SIGNED) DESC

Grandes Tiradas en

  • 1
  • 2
  • 3