CREATE TEMPORARY TABLE _product_filters_products_1 (PRIMARY KEY product_id (product_id)) ENGINE = MEMORY IGNORE SELECT products.product_id FROM cscart_june_setupproducts AS products  LEFT JOIN cscart_june_setupcompanies AS companies ON companies.company_id = products.company_id  INNER JOIN cscart_june_setupproducts_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_june_setupcategories ON cscart_june_setupcategories.category_id = products_categories.category_id  AND (cscart_june_setupcategories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_june_setupcategories.usergroup_ids) OR FIND_IN_SET(1, cscart_june_setupcategories.usergroup_ids)) AND cscart_june_setupcategories.status IN ('A', 'H') AND cscart_june_setupcategories.storefront_id IN (0, 1)  WHERE 1=1  AND cscart_june_setupcategories.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.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.product_type != 'D' ORDER BY NULL