CREATE TEMPORARY TABLE _product_filters_products_1 (PRIMARY KEY product_id (product_id)) ENGINE = MEMORY IGNORE SELECT products.product_id FROM tmall_products AS products  LEFT JOIN tmall_companies AS companies ON companies.company_id = products.company_id  INNER JOIN tmall_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN tmall_categories ON tmall_categories.category_id = products_categories.category_id  AND (tmall_categories.usergroup_ids = '' OR FIND_IN_SET(0, tmall_categories.usergroup_ids) OR FIND_IN_SET(1, tmall_categories.usergroup_ids)) AND tmall_categories.status IN ('A', 'H') AND tmall_categories.storefront_id IN (0, 1)  LEFT JOIN tmall_master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1  WHERE 1=1  AND tmall_categories.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') OR products.company_id = 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.master_product_status IN ('A', 'H') AND products.master_product_id = 0 AND (products.company_id > 0 OR (master_products_storefront_offers_count.count > 0 )) ORDER BY NULL