Erro manipulação executar! select count(*) tot from tb10produto where ac10sit <> "N" and an10preco > 0.00 and (ac10nome like "%Cha%" or ac10palavra like "%Cha%") and (ac10nome like "%de%" or ac10palavra like "%de%") and (ac10nome like "%rosa%" or ac10palavra like "%rosa%") and (ac10nome like "%mosqueta∨d=3%" or ac10palavra like "%mosqueta∨d=3%")
1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'Erro manipulação executar! select ac10codigo, ac10nome, ac10ref, an10preco, an10prom, ad10prom_fim, ad10prom_ini, ac10prom, ac10estoque, ac10sit, ac10opcao, ac10orcamento, ac10url, (select if(sum(an12saldo) > 0,1,0) from tb12prod_opcao where ac12produto=ac10codigo) sald, coalesce((select count(*) from tb20venda inner join tb21vendaitem on (an21pedido=an20codigo) where ac21prod=tb.ac10codigo and ac10sit<>"N"),0) vendido from tb10produto tb where ac10sit <> "N" and an10preco > 0.00 and (ac10nome like "%Cha%" or ac10palavra like "%Cha%") and (ac10nome like "%de%" or ac10palavra like "%de%") and (ac10nome like "%rosa%" or ac10palavra like "%rosa%") and (ac10nome like "%mosqueta∨d=3%" or ac10palavra like "%mosqueta∨d=3%") order by ac10sit, sald desc, ad10cadastro desc limit 0 , 25
1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'

Busca: "Cha de rosa mosqueta∨d=3"

FILTRAR