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` = '101'
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
Straight Backdrop-Sy Bunting King

        
        
        
        
        
    

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