Le utlime notizie sportive - Calcissimo

issara SELECT i.*, CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams FROM #__k2_items as i LEFT 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 c.language IN ('it-IT','*') AND i.language IN ('it-IT','*') AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2013-06-20 06:23:55' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2013-06-20 06:23:55' ) AND i.id IN (SELECT itemID FROM #__k2_tags_xref WHERE tagID=7) AND i.catid IN(1) ORDER BY i.id DESC