Productos que satisfacen los criterios de la búsqueda

1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'

select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '2' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%guin:%' or p.products_autor like '%guin:%' or p.products_isbn like '%guin:%' or m.manufacturers_name like '%guin:%' or pd.products_description like '%guin:%') and (pd.products_name like '%toni%' or p.products_autor like '%toni%' or p.products_isbn like '%toni%' or m.manufacturers_name like '%toni%' or pd.products_description like '%toni%') and (pd.products_name like '%matas%' or p.products_autor like '%matas%' or p.products_isbn like '%matas%' or m.manufacturers_name like '%matas%' or pd.products_description like '%matas%') and (pd.products_name like '%/%' or p.products_autor like '%/%' or p.products_isbn like '%/%' or m.manufacturers_name like '%/%' or pd.products_description like '%/%') and (pd.products_name like '%ilustraciones:%' or p.products_autor like '%ilustraciones:%' or p.products_isbn like '%ilustraciones:%' or m.manufacturers_name like '%ilustraciones:%' or pd.products_description like '%ilustraciones:%') and (pd.products_name like '%picanyol%' or p.products_autor like '%picanyol%' or p.products_isbn like '%picanyol%' or m.manufacturers_name like '%picanyol%' or pd.products_description like '%picanyol%') and (pd.products_name like '%/%' or p.products_autor like '%/%' or p.products_isbn like '%/%' or m.manufacturers_name like '%/%' or pd.products_description like '%/%') and (pd.products_name like '%color:%' or p.products_autor like '%color:%' or p.products_isbn like '%color:%' or m.manufacturers_name like '%color:%' or pd.products_description like '%color:%') and (pd.products_name like '%carlos%' or p.products_autor like '%carlos%' or p.products_isbn like '%carlos%' or m.manufacturers_name like '%carlos%' or pd.products_description like '%carlos%') and (pd.products_name like '%rojas%' or p.products_autor like '%rojas%' or p.products_isbn like '%rojas%' or m.manufacturers_name like '%rojas%' or pd.products_description like '%rojas%') )

[TEP STOP]