Clearance

Clear Filters SELECT ft.m_id, ft.m_display_name FROM s_filter_tags ft JOIN s_filter_producttags fpt ON ft.m_id = fpt.filtertag_id WHERE ft.m_active = 'Y' AND ft.m_filter_set = '9' AND EXISTS (SELECT t.m_broditid FROM s_products t WHERE fpt.product_id = t.m_broditid AND t.m_active = 'Y' AND t.m_status = '30' AND t.m_special <> 'N' ) GROUP BY ft.m_id ORDER BY ft.m_order
SELECT ft.m_id, ft.m_display_name FROM s_filter_tags ft JOIN s_filter_producttags fpt ON ft.m_id = fpt.filtertag_id WHERE ft.m_active = 'Y' AND ft.m_filter_set = '10' AND EXISTS (SELECT t.m_broditid FROM s_products t WHERE fpt.product_id = t.m_broditid AND t.m_active = 'Y' AND t.m_status = '30' AND t.m_special <> 'N' ) GROUP BY ft.m_id ORDER BY ft.m_order
SELECT ft.m_id, ft.m_display_name FROM s_filter_tags ft JOIN s_filter_producttags fpt ON ft.m_id = fpt.filtertag_id WHERE ft.m_active = 'Y' AND ft.m_filter_set = '11' AND EXISTS (SELECT t.m_broditid FROM s_products t WHERE fpt.product_id = t.m_broditid AND t.m_active = 'Y' AND t.m_status = '30' AND t.m_special <> 'N' ) GROUP BY ft.m_id ORDER BY ft.m_order
SELECT ft.m_id, ft.m_display_name FROM s_filter_tags ft JOIN s_filter_producttags fpt ON ft.m_id = fpt.filtertag_id WHERE ft.m_active = 'Y' AND ft.m_filter_set = '12' AND EXISTS (SELECT t.m_broditid FROM s_products t WHERE fpt.product_id = t.m_broditid AND t.m_active = 'Y' AND t.m_status = '30' AND t.m_special <> 'N' ) GROUP BY ft.m_id ORDER BY ft.m_order
SELECT ft.m_id, ft.m_display_name FROM s_filter_tags ft JOIN s_filter_producttags fpt ON ft.m_id = fpt.filtertag_id WHERE ft.m_active = 'Y' AND ft.m_filter_set = '13' AND EXISTS (SELECT t.m_broditid FROM s_products t WHERE fpt.product_id = t.m_broditid AND t.m_active = 'Y' AND t.m_status = '30' AND t.m_special <> 'N' ) GROUP BY ft.m_id ORDER BY ft.m_order
SELECT ft.m_id, ft.m_display_name FROM s_filter_tags ft JOIN s_filter_producttags fpt ON ft.m_id = fpt.filtertag_id WHERE ft.m_active = 'Y' AND ft.m_filter_set = '1' AND EXISTS (SELECT t.m_broditid FROM s_products t WHERE fpt.product_id = t.m_broditid AND t.m_active = 'Y' AND t.m_status = '30' AND t.m_special <> 'N' ) GROUP BY ft.m_id ORDER BY ft.m_order
SELECT ft.m_id, ft.m_display_name FROM s_filter_tags ft JOIN s_filter_producttags fpt ON ft.m_id = fpt.filtertag_id WHERE ft.m_active = 'Y' AND ft.m_filter_set = '6' AND EXISTS (SELECT t.m_broditid FROM s_products t WHERE fpt.product_id = t.m_broditid AND t.m_active = 'Y' AND t.m_status = '30' AND t.m_special <> 'N' ) GROUP BY ft.m_id ORDER BY ft.m_order
SELECT ft.m_id, ft.m_display_name FROM s_filter_tags ft JOIN s_filter_producttags fpt ON ft.m_id = fpt.filtertag_id WHERE ft.m_active = 'Y' AND ft.m_filter_set = '7' AND EXISTS (SELECT t.m_broditid FROM s_products t WHERE fpt.product_id = t.m_broditid AND t.m_active = 'Y' AND t.m_status = '30' AND t.m_special <> 'N' ) GROUP BY ft.m_id ORDER BY ft.m_order
SELECT ft.m_id, ft.m_display_name FROM s_filter_tags ft JOIN s_filter_producttags fpt ON ft.m_id = fpt.filtertag_id WHERE ft.m_active = 'Y' AND ft.m_filter_set = '5' AND EXISTS (SELECT t.m_broditid FROM s_products t WHERE fpt.product_id = t.m_broditid AND t.m_active = 'Y' AND t.m_status = '30' AND t.m_special <> 'N' ) GROUP BY ft.m_id ORDER BY ft.m_order
SELECT ft.m_id, ft.m_display_name FROM s_filter_tags ft JOIN s_filter_producttags fpt ON ft.m_id = fpt.filtertag_id WHERE ft.m_active = 'Y' AND ft.m_filter_set = '2' AND EXISTS (SELECT t.m_broditid FROM s_products t WHERE fpt.product_id = t.m_broditid AND t.m_active = 'Y' AND t.m_status = '30' AND t.m_special <> 'N' ) GROUP BY ft.m_id ORDER BY ft.m_order
SELECT ft.m_id, ft.m_display_name FROM s_filter_tags ft JOIN s_filter_producttags fpt ON ft.m_id = fpt.filtertag_id WHERE ft.m_active = 'Y' AND ft.m_filter_set = '3' AND EXISTS (SELECT t.m_broditid FROM s_products t WHERE fpt.product_id = t.m_broditid AND t.m_active = 'Y' AND t.m_status = '30' AND t.m_special <> 'N' ) GROUP BY ft.m_id ORDER BY ft.m_order
SELECT ft.m_id, ft.m_display_name FROM s_filter_tags ft JOIN s_filter_producttags fpt ON ft.m_id = fpt.filtertag_id WHERE ft.m_active = 'Y' AND ft.m_filter_set = '4' AND EXISTS (SELECT t.m_broditid FROM s_products t WHERE fpt.product_id = t.m_broditid AND t.m_active = 'Y' AND t.m_status = '30' AND t.m_special <> 'N' ) GROUP BY ft.m_id ORDER BY ft.m_order