SELECT `main_table`.*, `pts`.`ptype_id`, `pt`.`title`, `pt`.`description`, `pt`.`icon`, `pt`.`sort_order`, `pt`.`pa_standard_header`, `pt`.`pa_footer_message`, `pt`.`pa_factory_header`, `pt`.`important_note`, GROUP_CONCAT(DISTINCT `main_table`.finish ORDER BY cast( finish as DECIMAL) ASC SEPARATOR ",") AS `grouped_finish` FROM `wilsonart_product_patterns` AS `main_table`
INNER JOIN `wilsonart_product_types` AS `pts` ON pts.name = main_table.product_types
INNER JOIN `wilsonart_product_type` AS `pt` ON pt.ptype_id = pts.ptype_id AND FIND_IN_SET('1',pt.store_id) WHERE (`pattern_number` = '8229') AND (`product_types` != 'NULL') AND (`main_table`.`website_id` = '1') AND (`main_table`.`store_group_id` = '1') AND (`pt`.`status` = 1) GROUP BY `pt`.`ptype_id`vvv
