Erro manipulação executar! select count(*) tot from tb10produto where ac10sit <> "N" and an10preco > 0.00 and (an10preco * 1)>=2499.00 and (an10preco * 1))<=111111.11 and if (ad10prom_ini <= current_date and ad10prom_fim >= current_date, an10prom ,an10preco) * 1 >600.00
and if (ad10prom_ini <= current_date and ad10prom_fim >= current_date, an10prom ,an10preco) * 1 <=999.99 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 and if (ad10prom_ini <= current_date and ad10prom_fim >= current...' 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)>=2499.00 and (an10preco * 1))<=111111.11 and if (ad10prom_ini <= current_date and ad10prom_fim >= current_date, an10prom ,an10preco) * 1 >600.00
and if (ad10prom_ini <= current_date and ad10prom_fim >= current_date, an10prom ,an10preco) * 1 <=999.99 order by ac10sit, sald desc, rand(231474025) 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 and if (ad10prom_ini <= current_date and ad10prom_fim >= current...' at line 6