CREATE TEMPORARY TABLE _product_filters_products_1 (PRIMARY KEY product_id (product_id)) ENGINE = MEMORY IGNORE SELECT products.product_id FROM vi_products AS products  LEFT JOIN vi_companies AS companies ON companies.company_id = products.company_id  INNER JOIN vi_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN vi_categories ON vi_categories.category_id = products_categories.category_id  AND (vi_categories.usergroup_ids = '' OR FIND_IN_SET(0, vi_categories.usergroup_ids) OR FIND_IN_SET(1, vi_categories.usergroup_ids)) AND vi_categories.status IN ('A', 'H') AND vi_categories.storefront_id IN (0, 1)  WHERE 1=1  AND vi_categories.category_id IN (166, 165, 167, 168, 169, 170, 171, 172, 174, 175, 176, 177, 178, 179, 180, 181, 182, 199, 185, 186, 187, 188, 189, 190, 191, 194, 193, 195, 196, 197, 198, 200, 201, 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') ORDER BY NULL