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 '%texto:%' or p.products_autor like '%texto:%' or p.products_isbn like '%texto:%' or m.manufacturers_name like '%texto:%' or pd.products_description like '%texto:%') and (pd.products_name like '%daniel%' or p.products_autor like '%daniel%' or p.products_isbn like '%daniel%' or m.manufacturers_name like '%daniel%' or pd.products_description like '%daniel%') and (pd.products_name like '%londoo%' or p.products_autor like '%londoo%' or p.products_isbn like '%londoo%' or m.manufacturers_name like '%londoo%' or pd.products_description like '%londoo%') and (pd.products_name like '%silva%' or p.products_autor like '%silva%' or p.products_isbn like '%silva%' or m.manufacturers_name like '%silva%' or pd.products_description like '%silva%') 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 '%fredy%' or p.products_autor like '%fredy%' or p.products_isbn like '%fredy%' or m.manufacturers_name like '%fredy%' or pd.products_description like '%fredy%') and (pd.products_name like '%bernal%' or p.products_autor like '%bernal%' or p.products_isbn like '%bernal%' or m.manufacturers_name like '%bernal%' or pd.products_description like '%bernal%') )

[TEP STOP]