Breadcrumb Creazioni Fantasia
Prodotti / Materiale per bigiotteria / Miyuki-Delica 10/0

0

Miyuki-Delica 10/0

Miyuki-Delica 10/0 - 30

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

30

30 - 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='DBM0173/10' 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