Hi,
habe mal bei der Suche "shop" eingegeben..... Ergebnis:
SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created, a.images as images, CONCAT(jrm.rel_path,jrm.filename,".",jrm.file_extension) AS jrmimage, jrm.media_type AS mtype,CONCAT(a.introtext,a.fulltext) AS text,c.title AS section, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, '2' AS browsernav FROM #__content AS a INNER JOIN #__categories AS c ON c.id=a.catid LEFT JOIN #__jreviews_media AS jrm ON jrm.listing_id=a.id INNER JOIN #__jreviews_content AS jrc ON jrc.contentid=a.id WHERE ((a.title LIKE '%shop%' OR a.introtext LIKE '%shop%' OR a.fulltext LIKE '%shop%' OR a.metakey LIKE '%shop%' OR a.metadesc LIKE '%shop%' OR jrc.jr_firmenname LIKE '%shop%' OR jrc.jr_strasse LIKE '%shop%' OR jrc.jr_plzort LIKE '%shop%' OR jrc.jr_land LIKE '%shop%'))AND a.state=1 AND c.published = 1 AND a.access IN (1,1,5) AND c.access IN (1,1,5) AND (a.catid NOT IN (2,8,18)) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-10-22 19:38:21') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-10-22 19:38:21') GROUP BY a.id, a.title, a.metadesc, a.metakey, a.created, a.introtext, a.fulltext, c.title, a.alias, c.alias, c.id ORDER BY a.created DESC LIMIT 0, 50
Gruss
Robert
