1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,COERCIBLE) for operation 'like'
SELECT p.* FROM (
select p2.products_id, p2.manufacturers_id,
count(indice) as totalesAciertos,
group_concat(palabra) as palabras from (select p0.*, 'MINI�' as palabra from (
SELECT p.products_id, p.manufacturers_id, 0 as indice
FROM products p
JOIN products_search_keywords psk ON psk.products_id = p.products_id
AND psk.keywords LIKE '%MINI�%'
AND psk.languages_id = 3
AND (p.products_status=1 OR (p.products_status=0 AND DATE(p.products_date_available)>=CURDATE())) AND (p.products_type!='4' AND p.products_type!='8') AND (p.is_exclusive = '0')
AND p.manufacturers_id NOT IN (
SELECT manufacturers_id
FROM manufacturers_excluidos_por_idioma
WHERE profile_id=0
AND language_id=3
)
UNION ALL
SELECT p.products_id, p.manufacturers_id, 0 as indice
FROM products p
JOIN products_description pd ON p.products_id = pd.products_id
AND pd.products_name LIKE '%MINI�%'
AND pd.language_id = '3'
LEFT JOIN products_description pdi ON p.products_id=pdi.products_id AND pdi.language_id='3' AND pdi.publicar=1
LEFT JOIN products_description_templates_to_products pdt ON p.products_id=pdt.products_id
WHERE (p.products_status=1 OR (p.products_status=0 AND DATE(p.products_date_available)>=CURDATE())) AND (p.products_type!='4' AND p.products_type!='8') AND (p.is_exclusive = '0')
AND p.manufacturers_id NOT IN (
SELECT manufacturers_id
FROM manufacturers_excluidos_por_idioma
WHERE profile_id=0
AND language_id=3
) AND (pdi.language_id IS NOT NULL /*OR (pd.publicar=1 AND '3'!='4' AND p.is_exclusive=0)*/) AND ('3'!='15' OR pd.ya_editado='1')
UNION ALL
SELECT p.products_id, p.manufacturers_id, 0 as indice
FROM products p
JOIN manufacturers m ON
m.manufacturers_name LIKE '%MINI�%'
AND p.manufacturers_id = m.manufacturers_id
and (p.products_status=1 OR (p.products_status=0 AND DATE(p.products_date_available)>=CURDATE())) AND (p.products_type!='4' AND p.products_type!='8') AND (p.is_exclusive = '0')
AND p.manufacturers_id NOT IN (
SELECT manufacturers_id
FROM manufacturers_excluidos_por_idioma
WHERE profile_id=0
AND language_id=3
)
UNION ALL
SELECT p.products_id, p.manufacturers_id, 0 as indice
FROM products p
WHERE p.ref_catalogo LIKE '%MINI�%'
and (p.products_status=1 OR (p.products_status=0 AND DATE(p.products_date_available)>=CURDATE())) AND (p.products_type!='4' AND p.products_type!='8') AND (p.is_exclusive = '0')
AND p.manufacturers_id NOT IN (
SELECT manufacturers_id
FROM manufacturers_excluidos_por_idioma
WHERE profile_id=0
AND language_id=3
)
UNION ALL
SELECT p.products_id, p.manufacturers_id, 0 as indice
FROM products p
LEFT JOIN products_stock ps ON
p.products_id=ps.products_id
WHERE (p.barcode LIKE '%MINI�%' or ps.barcode LIKE '%MINI�%')
and (p.products_status=1 OR (p.products_status=0 AND DATE(p.products_date_available)>=CURDATE())) AND (p.products_type!='4' AND p.products_type!='8') AND (p.is_exclusive = '0')
AND p.manufacturers_id NOT IN (
SELECT manufacturers_id
FROM manufacturers_excluidos_por_idioma
WHERE profile_id=0
AND language_id=3
)
) p0 group by products_id
UNION ALL select p1.*, 'MINI' as palabra from (
SELECT p.products_id, p.manufacturers_id, 1 as indice
FROM products p
JOIN products_search_keywords psk ON psk.products_id = p.products_id
AND psk.keywords LIKE '%MINI%'
AND psk.languages_id = 3
AND (p.products_status=1 OR (p.products_status=0 AND DATE(p.products_date_available)>=CURDATE())) AND (p.products_type!='4' AND p.products_type!='8') AND (p.is_exclusive = '0')
AND p.manufacturers_id NOT IN (
SELECT manufacturers_id
FROM manufacturers_excluidos_por_idioma
WHERE profile_id=0
AND language_id=3
)
UNION ALL
SELECT p.products_id, p.manufacturers_id, 1 as indice
FROM products p
JOIN products_description pd ON p.products_id = pd.products_id
AND pd.products_name LIKE '%MINI%'
AND pd.language_id = '3'
LEFT JOIN products_description pdi ON p.products_id=pdi.products_id AND pdi.language_id='3' AND pdi.publicar=1
LEFT JOIN products_description_templates_to_products pdt ON p.products_id=pdt.products_id
WHERE (p.products_status=1 OR (p.products_status=0 AND DATE(p.products_date_available)>=CURDATE())) AND (p.products_type!='4' AND p.products_type!='8') AND (p.is_exclusive = '0')
AND p.manufacturers_id NOT IN (
SELECT manufacturers_id
FROM manufacturers_excluidos_por_idioma
WHERE profile_id=0
AND language_id=3
) AND (pdi.language_id IS NOT NULL /*OR (pd.publicar=1 AND '3'!='4' AND p.is_exclusive=0)*/) AND ('3'!='15' OR pd.ya_editado='1')
UNION ALL
SELECT p.products_id, p.manufacturers_id, 1 as indice
FROM products p
JOIN manufacturers m ON
m.manufacturers_name LIKE '%MINI%'
AND p.manufacturers_id = m.manufacturers_id
and (p.products_status=1 OR (p.products_status=0 AND DATE(p.products_date_available)>=CURDATE())) AND (p.products_type!='4' AND p.products_type!='8') AND (p.is_exclusive = '0')
AND p.manufacturers_id NOT IN (
SELECT manufacturers_id
FROM manufacturers_excluidos_por_idioma
WHERE profile_id=0
AND language_id=3
)
UNION ALL
SELECT p.products_id, p.manufacturers_id, 1 as indice
FROM products p
WHERE p.ref_catalogo LIKE '%MINI%'
and (p.products_status=1 OR (p.products_status=0 AND DATE(p.products_date_available)>=CURDATE())) AND (p.products_type!='4' AND p.products_type!='8') AND (p.is_exclusive = '0')
AND p.manufacturers_id NOT IN (
SELECT manufacturers_id
FROM manufacturers_excluidos_por_idioma
WHERE profile_id=0
AND language_id=3
)
UNION ALL
SELECT p.products_id, p.manufacturers_id, 1 as indice
FROM products p
LEFT JOIN products_stock ps ON
p.products_id=ps.products_id
WHERE (p.barcode LIKE '%MINI%' or ps.barcode LIKE '%MINI%')
and (p.products_status=1 OR (p.products_status=0 AND DATE(p.products_date_available)>=CURDATE())) AND (p.products_type!='4' AND p.products_type!='8') AND (p.is_exclusive = '0')
AND p.manufacturers_id NOT IN (
SELECT manufacturers_id
FROM manufacturers_excluidos_por_idioma
WHERE profile_id=0
AND language_id=3
)
) p1 group by products_id
) p2 GROUP BY p2.products_id
) p
LEFT JOIN manufacturers m ON
m.manufacturers_id=p.manufacturers_id AND (m.manufacturers_name LIKE "%tutete%" OR m.manufacturers_id="1064")
ORDER BY totalesAciertos DESC, ISNULL(m.manufacturers_id), products_id DESC LIMIT 80
Español
Italiano
Inglés
Portugués
Francés
