Erro manipulação executar! select count(*) tot from tb10produto where ac10sit <> "N" and an10preco > 0.00 and (ac10nome like "%OLEO∨d=1%" or ac10palavra like "%OLEO∨d=1%")
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 "%OLEO∨d=1%" or ac10palavra like "%OLEO∨d=1%") 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: "OLEO∨d=1"

FILTRAR