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` = '184'
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
Foam Board Hanger-Sy Bunting King
Array
(
)

Foam Board Hanger


Suitable to use on paper foam board & compress foam board only

Quantity

Final Total (not including SST 10%)

RM Normal
RM Top Up Price



Collect Date (Please noted that collection time for Normal and Urgent Order is 6pm, Same Day order is 9pm and there are extra charges for urgent order.)

Remarks

Terms and Conditions Read the full terms and conditions here



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