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 (5) ) 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 = '347' 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 = '347' 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 = '335' 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 = '336' 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 = '300' 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 = '348' 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 = '315' 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 = '301' 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 = '304' 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 = '306' 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 = '302' 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 = '303' 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 = '312' 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 = '311' 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 = '328' 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 = '295' 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 = '296' 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 = '329' 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 = '349' 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 = '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 = '285' 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 = '210' 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 = '203' 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 = '107' 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 = '99' 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 = '48' 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 = '156' 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 = '174' 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 = '31' 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 = '30' 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 = '37' 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 = '155' 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 = '173' 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 = '209' 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 = '42' 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 = '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 = '90' 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 = '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 = '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 = '91' 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 = '89' 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 = '207' 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 = '184' 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 = '150' 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 = '183' 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 = '153' 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 = '172' 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 = '151' 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 = '187' 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 = '152' 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 = '116' 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 = '74' 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 = '208' 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 = '121' 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 = '126' 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 = '25' 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 = '38' 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 = '88' 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 = '39' 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 = '47' 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 = '70' 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 = '71' 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 = '136' 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 = '142' 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 = '171' 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 = '127' 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 = '41' 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 = '50' 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 = '214' 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 = '166' 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 = '188' 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 = '58' 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 = '105' 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 = '122' 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 = '190' 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 = '215' 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 = '165' 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 = '104' 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 = '29' 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 = '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 = '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;
