CREATE TEMPORARY TABLE _product_filters_products_1 (PRIMARY KEY product_id (product_id)) ENGINE = MEMORY IGNORE SELECT products.product_id FROM cscart_multi_decproducts AS products  LEFT JOIN cscart_multi_deccompanies AS companies ON companies.company_id = products.company_id  INNER JOIN cscart_multi_decproducts_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_multi_deccategories ON cscart_multi_deccategories.category_id = products_categories.category_id  AND (cscart_multi_deccategories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_multi_deccategories.usergroup_ids) OR FIND_IN_SET(1, cscart_multi_deccategories.usergroup_ids)) AND cscart_multi_deccategories.status IN ('A', 'H') AND cscart_multi_deccategories.storefront_id IN (0, 1)  WHERE 1=1  AND cscart_multi_deccategories.category_id IN (166, 174, 175, 176, 177, 178, 179, 180, 181, 182, 199, 185, 186, 187, 188, 189, 190, 191, 194, 193, 195, 196, 197, 198, 200, 202, 234, 235, 236, 237, 238, 240, 254, 255, 263) AND companies.status IN ('A') AND products.company_id = 1  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.company_id = 1  AND products.product_type != 'D' ORDER BY NULL