SELECT p.m_id, p.m_ref, p.m_shortdescription, p.m_finish, p.m_new, p.m_specialorder, i.m_image, s.m_name, s.m_id as s_id, (SELECT i2.m_image FROM s_products p2 INNER JOIN product_images i2 ON i2.m_productid = p2.m_id WHERE p2.m_ref = i2.m_ref ORDER BY CASE p2.m_primary WHEN 'Y' THEN '1' ELSE '999' END asc LIMIT 1) as productimage FROM s_products p INNER JOIN s_subcategories s ON s.m_id = p.m_subcategory INNER JOIN product_images i ON i.m_productid = p.m_id WHERE p.m_active = 'Y' AND p.m_specification = '' AND EXISTS ( SELECT 1 FROM s_filter_producttags WHERE product_id = p.m_id AND filtertag_id IN (4) ) AND p.m_primary = 'Y' ORDER BY s.m_order ASC, p.m_order ASC, s.m_name ASC; SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '334' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '320' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '337' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '337' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '337' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '338' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '339' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '340' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '345' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '342' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '343' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '344' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '330' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '331' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '321' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '322' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '332' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '305' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '293' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '314' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '346' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '287' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '298' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '313' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '323' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '324' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '288' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '325' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '291' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '289' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '297' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '290' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '309' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '310' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '316' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '316' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '317' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '318' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '253' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '255' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '286' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '235' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '251' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '21' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '13' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '228' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '79' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '101' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '125' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '54' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '175' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '93' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '98' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '225' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '178' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '250' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '77' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '80' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '249' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '221' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '87' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '110' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '76' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '234' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '157' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '160' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '161' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '78' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '81' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '223' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '224' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '222' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '158' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '159' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '182' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '180' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '195' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '69' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '227' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '67' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '67' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '114' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '167' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '205' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '143' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '23' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '24' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '144' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '18' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '32' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '22' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '94' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '119' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '45' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '96' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '68' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '51' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '168' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '120' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '64' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '206' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '46' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '95' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '63' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '52' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '53' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '213' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '194' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '218' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '43' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '100' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '135' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '128' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '131' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '133' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '134' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '129' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '132' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '130' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '19' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '169' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '170' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;
