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_category = 'Vehicles' AND t.m_make = 'Subaru' AND t.m_model = 'Crosstrek' ) 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_category = 'Vehicles' AND t.m_make = 'Subaru' AND t.m_model = 'Crosstrek' ) 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_category = 'Vehicles' AND t.m_make = 'Subaru' AND t.m_model = 'Crosstrek' ) 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_category = 'Vehicles' AND t.m_make = 'Subaru' AND t.m_model = 'Crosstrek' ) 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_category = 'Vehicles' AND t.m_make = 'Subaru' AND t.m_model = 'Crosstrek' ) 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_category = 'Vehicles' AND t.m_make = 'Subaru' AND t.m_model = 'Crosstrek' ) 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_category = 'Vehicles' AND t.m_make = 'Subaru' AND t.m_model = 'Crosstrek' ) 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_category = 'Vehicles' AND t.m_make = 'Subaru' AND t.m_model = 'Crosstrek' ) 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_category = 'Vehicles' AND t.m_make = 'Subaru' AND t.m_model = 'Crosstrek' ) 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_category = 'Vehicles' AND t.m_make = 'Subaru' AND t.m_model = 'Crosstrek' ) 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_category = 'Vehicles' AND t.m_make = 'Subaru' AND t.m_model = 'Crosstrek' ) 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_category = 'Vehicles' AND t.m_make = 'Subaru' AND t.m_model = 'Crosstrek' ) GROUP BY ft.m_id ORDER BY ft.m_order
