Breadcrumb Creazioni Fantasia
Prodotti / Ricamo Luneville / Tessuti

0

Tessuti

Tessuti - 1

per_page: 1 - maxpage: 1 - page_ri: 1 - page_rf: 51

1

1 - perpage: 1

select (prod.giacenza-items.qty) as 'pezzi rimanenti' from umbTAB3_Product prod left outer join(select prodcode, sum(qty) as qty from pwrcart_orderitems WHERE prodcode='TES001' and idcart in (select id from pwrcart_order where status != 99 and status > 9) group by prodcode) items on prod.codice = items.prodcode where items.qty is not null and prod.name not like'Costo %'

dt.Rows= 1

disponibile =True