string(309) "SELECT *
FROM `msproductsubcategory` `psc`
JOIN `trproductsubcategorybind` `pscb` ON `pscb`.`ProductSubCategoryID` = `psc`.`ProductSubCategoryID`
JOIN `msproduct` `p` ON `p`.`kd_brg` = `pscb`.`kd_brg`
WHERE `ProductCategoryID` = 'PC17020302'
AND `ProductSubCategoryShow` = 1
GROUP BY `pscb`.`kd_brg`
 LIMIT 20"
Jual Koleksi Frame Kacamata Optical dan Sunglasses Pria Di Optik Tunggal

Optical Frames

Sunglasses
AGNES B ; AB10001 ; C01 (MATT BLK) - 57
AGNES B ; AB20008 ; C01 (BLK) - 50
SPORT B ; ABS01003 ; C03 (RED) - 59
SPORT B ; ABS05001 ; C03 (GUN) - 50
SPORT B ; ABS05004 ; C01 (BLK) - 51
SPORT B ; ABS05004 ; C04 (BLK) - 51
SPORT B ; ABS05005 ; C04 (BLUE) - 52
SPORT B ; ABS05005 ; C02 (BUR) - 52
SPORT B ; ABS05007 ; C01 (BLK) - 49
SPORT B ; ABS05007 ; C02 (SIL) - 49
SPORT B ; ABS05007 ; C04 (BRONZE) - 49
SPORT B ; ABS05008 ; C01 (BLK) - 51
SPORT B ; ABS05008 ; C04 (RED) - 51
SPORT B ; ABS05009 ; C01 (BLK) - 50
SPORT B ; ABS05009 ; C02 (BUR) - 50
SPORT B ; ABS06002 ; C03 (GREY) - 51
SPORT B ; ABS06003 ; C03 (BLUE) - 51
BATHING APE ; BA 13009 ; BC (BLK) - 51
BATHING APE ; BA 13009 ; NB (BLK/GRY) - 51
BATHING APE ; BA 13010 ; CM (GRN) - 50