Breadcrumb Creazioni Fantasia
Prodotti / Materiale per bigiotteria / Filigrane in legno

0

Filigrane in legno

Filigrane in legno - 65

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

65

65 - perpage: 1

Pagine:

1 2

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='AFLEG010' 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

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='FLEG043' 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

Pagine:

1 2