SELECT `fi`.`finishing_id`, `fv`.`product_id`, `fi`.`finishing_material`, `fii`.`finishing`, `fii`.`product_id`, `fii`.`size_value`, `fv`.`price`, `fi`.`finishing_image`, `fi`.`finishing_desc_image`
FROM `sy_finishing_variables` AS `fv`
JOIN `sy_finishing` AS `fi` ON `fv`.`finishing_id` = `fi`.`finishing_id`
JOIN `sy_mounting_products` AS `fii` ON `fi`.`finishing_material` = `fii`.`finishing`
WHERE `fv`.`product_id` = '112'
AND `fii`.`size_value` IN('Mounting Only- Die Cut', 'Mounting Only- Cut to Size')
GROUP BY `fii`.`finishing`
ORDER BY `fv`.`finishing_order_number` ASC
Spot Light-Sy Bunting King

Spot Light



Remarks

Quantity

Final Total (not including SST 10%)

RM 0.0 Normal Price
RM 0Classic Price
RM 0Gold Price
RM 0Premium Price
You may top up to get lower price. click here


Terms and Conditions Read the full terms and conditions here

©2023 SY Bunting King. All rights reserved. Term & Condition