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 (13,12) ) 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 = '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 = '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 = '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 = '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 = '292' 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 = '299' 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 = '113' 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 = '12' 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 = '20' 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 = '145' 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 = '148' 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 = '75' 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 = '5' 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 = '3' 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 = '40' 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 = '106' 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 = '189' 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 = '192' 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 = '216' 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 = '2' 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 = '4' 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;
SELECT m_id, m_finish FROM s_products WHERE m_subcategory = '124' 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 = '115' 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 = '66' 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 = '282' ORDER BY CASE m_primary WHEN 'Y' THEN '1' ELSE '999' END asc, m_order ASC, m_name ASC;