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"

Optical Frames

Sunglasses

AGNES B ; AB20008 ; C01 (BLK) - 50

SPORT B ; ABS01003 ; C03 (RED) - 59

SPORT B ; ABS05004 ; C01 (BLK) - 51

SPORT B ; ABS05005 ; C04 (BLUE) - 52

SPORT B ; ABS05005 ; C02 (BUR) - 52

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 13010 ; CM (GRN) - 50

BATHING APE ; BA 13010 ; BC (BLK/GRN) - 50

BATHING APE ; BA 13010 ; NB (BLK/GRY) - 50

BATHING APE ; BA 13016 ; BC (BLK/GRN) - 51

BATHING APE ; BA 13016 ; NB (BLK/GRY) - 51

BATHING APE ; BA 13065 ; BC (BLK/GLD) - 50

• 1
• 2
• 3