: Erro manipula��o executar! select ac10codigo, ac10nome, ac10ref, an10preco, an10prom, ad10prom_fim, ad10prom_ini, ac10prom, ac10estoque, ac10sit, ac10opcao, ac10orcamento, (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 ac10codigo in (select ac02produto from tb02prod_grupo where an02nivel=3 and an02grupo= "" ) order by ac10sit, sald desc, ad10cadastro desc limit 0 , 24
:
- « anterior
- próxima »