SELECT SQL_CALC_FOUND_ROWS i.title AS ContentTitle, i.idk2item AS ContentID, ADDDATE(i.created, INTERVAL 0 HOUR) AS ContentCreated, c.name AS CategoryTitle, c.id AS CategoryID, c.alias AS CategoryAlias, c.access AS CategoryAccess, c.parent AS CategoryParent FROM #__db4searchk2cz AS i JOIN #__k2_categories AS c ON (i.catid = c.id) AND c.access <= 5 AND i.published = 1 AND i.trashed = '0' AND i.catid IN (2,3,4,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,78,85,95,97,98,99,101,109) ORDER BY i.created DESC

 

 

  Chercher seulement dans le titre

Du

Au

Au