# Wed Dec 17 11:20:34 2008
# Query_time: 3  Lock_time: 0  Rows_sent: 21  Rows_examined: 145
use theclari_rugProd;
SELECT a.title AS title, a.created AS created, CONCAT(a.introtext, a.`fulltext`) AS text, CONCAT_WS( "/", u.title, b.title ) AS section, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(":", b.id, b.alias) ELSE b.id END as catslug, u.id AS sectionid, "2" AS browsernav FROM jos_content AS a INNER JOIN jos_categories AS b ON b.id=a.catid INNER JOIN jos_sections AS u ON u.id = a.sectionid WHERE ( (LOWER(a.title) LIKE '%tania%' OR LOWER(a.introtext) LIKE '%tania%' OR LOWER(a.`fulltext`) LIKE '%tania%' OR LOWER(a.metakey) LIKE '%tania%' OR LOWER(a.metadesc) LIKE '%tania%') ) AND a.state = 1 AND u.published = 1 AND b.published = 1 AND a.access <= 0 AND b.access <= 0 AND u.access <= 0 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-12-17 18:20:31' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-12-17 18:20:31' ) GROUP BY a.id ORDER BY a.created DESC LIMIT 0, 50