SELECT `mv`.`material_id`, `mv`.`machine_id`, `mv`.`price` as `price`, `mv`.`desc_price` as `desc_price`, `m`.`thickness`, `m`.`material_name`, `m`.`thickness`, `m`.`material_image`
FROM `sy_material_variables_new` AS `mv`
LEFT JOIN `sy_materials` AS `m` ON `mv`.`material_id` = `m`.`material_id`
JOIN `sy_material_variables` AS `o` ON `mv`.`material_id` = `o`.`material_id`
WHERE `mv`.`machine_id` = '2'
AND `mv`.`set_id` = 1
AND `o`.`product_id` = '6'
AND `mv`.`location_id` = 1
AND `mv`.`material_id` NOT IN(22, 23)
AND `m`.`material_image` != ""
GROUP BY `mv`.`material_id`
ORDER BY `m`.`sort` ASC
Poster-Sy Bunting King

Poster

All of the finished goods may not be 100% in actual size some of it will be differences in 0.5 inches - 2 inches due to the different types of finishing and size of the material. Please make sure that all text size no smaller than 8pt, we will resize your artwork into the selected size without prior notice.

Type of Machine


Lamination

size


×

Size Converter

Χ

Finishing : Cut to size

Remarks

Quantity

Final Total (not including SST 10%)

RM

Upload Your Artwork




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.)

Terms and Conditions Read the full terms and conditions here


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