Kategori


Dompet SALE SAP 395

Dompet SALE SAP 395

Rp 53.563 Rp 153.038 65%

Dompet SALE SAP 430

Dompet SALE SAP 430

Rp 54.429 Rp 155.513 65%

Tas Jinjing SALE LMI 795

Tas Jinjing SALE LMI 795

Rp 55.633 Rp 158.950 65%

Tas Jinjing SALE LNS 024

Tas Jinjing SALE LNS 024

Rp 61.263 Rp 175.038 65%

Tas Jinjing SALE LAP 749

Tas Jinjing SALE LAP 749

Rp 80.754 Rp 230.725 65%

Tas Punggung SALE LRB 429

Tas Punggung SALE LRB 429

Rp 54.044 Rp 154.413 65%

Menampikan produk 829-834 dari total 834 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 (11) order by b.updated desc limit 828 , 18