CREATE TEMPORARY TABLE _product_filters_products_2 (PRIMARY KEY product_id (product_id)) ENGINE = MEMORY IGNORE SELECT products.product_id FROM cscart_products AS products  LEFT JOIN cscart_product_features_values as var_val_2 ON var_val_2.product_id = products.product_id AND var_val_2.lang_code = 'en' AND var_val_2.feature_id = 2 LEFT JOIN cscart_mb_vehicle_listing_index AS mb_vehicle_listing_index ON mb_vehicle_listing_index.product_id = products.product_id  LEFT JOIN cscart_mb_salvage_cases AS mb_recaon_visibility_case ON mb_recaon_visibility_case.case_id = mb_vehicle_listing_index.case_id  LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id  INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN (SELECT parent_product_id
                                             FROM cscart_products
                                            WHERE parent_product_id != 0 AND amount > 0 AND product_type = 'V'
                                         GROUP BY parent_product_id) AS mccd__variation_stocks ON mccd__variation_stocks.parent_product_id = products.parent_product_id LEFT JOIN cscart_csc_product_currency_items as csc_product_currency_items ON csc_product_currency_items.product_id=products.product_id AND csc_product_currency_items.company_id=0 WHERE 1=1  AND (var_val_2.variant_id IN (12)) AND (mb_recaon_visibility_case.case_id IS NULL OR mb_recaon_visibility_case.import_source NOT LIKE 'recaon_%' OR mb_vehicle_listing_index.storefront_id = 1)  AND (mb_recaon_visibility_case.case_id IS NULL OR mb_recaon_visibility_case.selected_flow != 'direct_sale' OR mb_recaon_visibility_case.sale_listing_status != 'hold')  AND cscart_categories.category_id IN (499, 528, 503, 530, 533, 546, 548, 515, 514, 525, 537, 524, 534, 550, 516, 527, 545, 551, 517, 523, 538, 544, 553, 539, 547, 554, 540, 518, 531, 541, 519, 526, 542, 552, 562, 543, 549, 521, 535, 522, 532, 536, 529, 558, 559, 560, 561, 572, 573, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592, 593, 594, 595, 596, 597, 598, 599, 600, 601, 602, 603, 604, 606, 607, 630, 631, 632, 633, 634, 635, 637) AND companies.status IN ('A', 'S') AND products.company_id IN (1, 3, 5, 6, 7, 8, 10, 11, 12, 13, 15, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND products.is_invoice = 'N' AND products.product_type != 'D' ORDER BY NULL