Търсене

(SELECT SQL_CALC_FOUND_ROWS DISTINCT p.id, p.url, IF(p.islink=1, p.url,p.url1full) AS fullurl, IFNULL(p.title1,p.title1) AS title, IF(p.shortdescription1='' OR p.shortdescription1 IS NULL, p.shortdescription1,p.shortdescription1) AS shortdescription, IFNULL(p.text1,p.text1) AS txt, pt.tag AS typetag, IF(pt.tag='PRODUCT',(SELECT filename FROM productimages AS pi INNER JOIN products AS pp ON pp.id=pi.product_id WHERE pp.page_id=p.id ORDER BY pi.weight DESC limit 1),r.filename) AS filename, MATCH(s.txt) AGAINST('12V') AS position, s.lang_id FROM searchindex AS s INNER JOIN pages AS p ON p.id=s.page_id INNER JOIN pagetypes AS pt ON pt.id=p.type_id LEFT JOIN resources AS r ON r.id=p.image_id WHERE s.lang_id=1 AND p.deleted=0 AND p.hidden=0 AND p.islink=0 AND p.published=1 AND p.showinsearch=1 AND p.site_id='117' AND pt.tag NOT IN('RUBRIC', 'ALBUMLIST') AND (p.id IN(SELECT page_id FROM products WHERE prodid LIKE '% 12V%') OR LOWER(s.txt) REGEXP '[[:<:]]12v[[:>:]]' > 0 ) ORDER BY position DESC ) UNION ALL ( SELECT pg.id, pg.url, pg.url1full AS fullurl, IFNULL(p.name1,p.name1) AS title, '' AS shortdescription, IFNULL(p.alt1,p.alt1) AS txt, 'IMAGE' AS typetag, p.filename, 0 AS position, 0 AS lang_id FROM galleryphotos AS p INNER JOIN galleries AS g ON g.id=p.gallery_id INNER JOIN pages AS pg ON pg.id=g.page_id WHERE p.deleted=0 AND p.isactive=1 AND pg.site_id='117' AND (LOWER(p.alt1) REGEXP '[[:<:]]12v[[:>:]]' > 0 OR LOWER(p.name1) REGEXP '[[:<:]]12v[[:>:]]' > 0 OR LOWER(p.filename) REGEXP '[[:<:]]12v[[:>:]]' > 0 ) ) LIMIT 0, 30

Illegal argument to a regular expression.