(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('') 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='390' AND
pt.tag NOT IN('RUBRIC', 'ALBUMLIST') AND
(p.id IN(SELECT page_id FROM products WHERE prodid LIKE '%%') OR
LOWER(s.txt) REGEXP '[[:<:]][[:>:]]' > 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='390' AND
(LOWER(p.alt1) REGEXP '[[:<:]][[:>:]]' > 0 OR
LOWER(p.name1) REGEXP '[[:<:]][[:>:]]' > 0 OR
LOWER(p.filename) REGEXP '[[:<:]][[:>:]]' > 0 )
)
LIMIT 0, 30
Illegal argument to a regular expression.