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` = 'PC20052001'
AND `ProductSubCategoryShow` = 1
GROUP BY `pscb`.`kd_brg`
 LIMIT 20"
Jual Koleksi Frame Kacamata Optical dan Sunglasses kids Di Optik Tunggal

Boys

Girls
BULGET KID ; BGK6007 ; A01 (BLK) - 50
BULGET KID ; BGK9000U ; T01 (GRN) - 49
BULGET KID ; BGK9001 ; T02 (GRN) - 50
BULGET KID ; BGK9001 ; A02 (BLK) PZ - 50
BULGET KID ; BGK9002U ; D01 (CLEAR) - 49
BULGET KID ; BGK9002U ; A01 (BLK) - 49
BULGET KID ; BGK9003U ; A01 (BLK-BLULENS) PZ - 49
BULGET KID ; BGK9004 ; T01 (PUR) - 50
BULGET KID ; BGK9005 ; A01 (BLK-BLULENS) PZ - 48
EDGY ; K119 ; C2 (GREY/RED) - 44
EDGY ; K119 ; C3 (MATT BLK) - 44
EDGY ; K119 ; C4 (SHINY BLK/BLUE) - 44
EDGY ; K119 ; C1 (BLUE) - 44
EDGY ; K121 ; C4 (GREY) - 46
EDGY ; K121 ; C1 (BLK) - 46
EDGY ; K121 ; C2 (BLK/DARK BLUE) - 46
EDGY ; K121 ; C3 (BLK/GRN) - 46
LEVIS KID ; LS 60230ZA ; C02(BLK-G) - 49
MINI BOXX; MB-10-119; C1 (BLK) – 46
MINI BOXX; MB-12-137; C5 (BLK) – 46