Kategori


Pakaian Wanita Garsel Fashion GTT 1256
Pakaian Pria Garsel Fashion GTT 1764
Pakaian Wanita Garsel Fashion FIZ 1270
Pakaian Pria Garsel Fashion FIZ 1781
Pakaian Wanita Garsel Fashion RDW 2264
Pakaian Pria Garsel Fashion RDW 2765
Pakaian Wanita Garsel Fashion FKR 1002
Pakaian Pria Garsel Fashion FKR 1505
Busana Wanita Garsel Fashion FRH 0266
Busana Wanita Garsel Fashion FKS 0693
Busana Pria Garsel Fashion FKS 0853
Busana Pria Garsel Fashion FRH 0848
Busana Wanita Garsel Fashion FII 0011
Busana Pria Garsel Fashion FII 0856
Busana Wanita Garsel Fashion FDM 0115
Busana Pria Garsel Fashion FDM 0751
Pakaian Pria Azzurra 1514-04
Pakaian Wanita Azzurra 1514-05
Menampikan produk 1-18 dari total 204 produk
select a.product_id, b.merk, b.name, b.name_c, b.code, b.size, b.short_desc, b.long_desc, b.image_1, b.cart_active_flag, b.store_id, b.price, b.discount, b.discount_extra, b.price-(b.price*b.discount/100)-(b.price*b.discount_extra/100) as price_nett from s_prod_cat a USE INDEX(s_prod_c_7) inner join s_prod b force index (primary) on b.id = a.product_id where a.status = 1 and a.category_id in (17) order by b.updated desc limit 0 , 18