string(289) "SELECT * FROM msproductsubcategory psc INNER JOIN trproductsubcategorybind pscb ON pscb.ProductSubCategoryID = psc.ProductSubCategoryID INNER JOIN msproduct p ON p.kd_brg = pscb.kd_brg WHERE ProductCategoryID = 'PC17020301' AND ProductSubCategoryShow = 1  GROUP BY pscb.kd_brg LIMIT 40, 20"
Jual Koleksi Frame Kacamata Optical dan Sunglasses Wanita Di Optik Tunggal

Optical Frames

Sunglasses
AGNES B ; AB 40016 ; C05 (BLK) - 48
AGNES B ; AB 40017 ; C01 (BLK) - 50
AGNES B ; AB 40017 ; C05 (BLK) - 50
AGNES B ; AB 40017 ; C02 (DEMI) - 50
AGNES B ; AB40027 ; C01 (BLK) - 49
AGNES B ; AB40027 ; C03 (DEMI) - 49
AGNES B ; AB40027 ; C04 (DEMI) - 49
AGNES B ; AB40028 ; C01 (BLK) - 51
AGNES B ; AB40028 ; C04 (DEMI) - 51
AGNES B ; AB40029 ; C03 (PUR) - 49
AGNES B ; AB40029 ; C02 (DEMI) - 49
AGNES B ; AB40029 ; C01 (DEMI) - 49
AGNES B ; AB40030 ; C04 (GREY) - 49
AGNES B ; AB40030 ; C01 (BLK) - 49
AGNES B ; AB40030 ; C02 (DEMI) - 49
AGNES B ; AB47001 ; C02 (DEMI) - 48
AGNES B ; AB47003 ; C02 (GREY) - 47
AGNES B ; AB47003 ; C04 (BRN) - 47
AGNES B ; AB47003 ; C01 (PUR) - 47
AGNES B ; AB47003 ; C03 (PINK) - 47