Erro manipulação executar! select count(*) tot from tb10produto where ac10sit <> "N" and an10preco > 0.00 and (an10preco * 1)>=1499.00 and (an10preco * 1))<=111111.11 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')<=111111.11' at line 1
Erro manipulação executar! select ac10codigo, ac10nome, ac10ref, an10preco, an10prom, ad10prom_fim, ad10prom_ini,
ac10prom, ac10estoque, ac10sit, ac10opcao, ac10orcamento, ac10url, ac10pronta, an10pix, ac10montagem, ac06nome,
(select if(sum(an12saldo) > 0,1,(select if (sum(an10saldo)>0,1,0) from tb10prod_filial where ac10produto=ac10codigo))
from tb12prod_opcao where ac12produto=ac10codigo) sald,
0 vendido from tb10produto tb left join tb06marca on (an06codigo=an10marca)
where ac10sit <> "N" and an10preco > 0.00 and (an10preco * 1)>=1499.00 and (an10preco * 1))<=111111.11 order by ac10sit, sald desc, rand(1168021275) limit 24 , 24 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')<=111111.11 order by ac10sit, sald desc, rand(1168021275) limit 24 , 24' at line 6
