CREATE TEMPORARY TABLE _product_filters_products_1 (PRIMARY KEY product_id (product_id)) ENGINE = MEMORY IGNORE SELECT products.product_id FROM products AS products  LEFT JOIN companies AS companies ON companies.company_id = products.company_id  INNER JOIN products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN categories ON categories.category_id = products_categories.category_id  AND (categories.usergroup_ids = '' OR FIND_IN_SET(0, categories.usergroup_ids) OR FIND_IN_SET(1, categories.usergroup_ids)) AND categories.status IN ('A', 'H') AND categories.storefront_id IN (0, 1)  LEFT JOIN product_options_inventory as inventory ON inventory.product_id = products.product_id  LEFT JOIN product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1=1  AND categories.category_id IN (12, 319, 128, 22814, 320, 22815, 22816, 22817, 22818, 22819, 22820, 321, 322, 323, 324, 53, 22787, 22788, 280, 281, 282, 283, 284, 285, 54, 295, 296, 297, 298, 299, 300, 55, 301, 22793, 22794, 22795, 22796, 22797, 302, 22798, 22799, 22800, 22801, 303, 22809, 22810, 22811, 22812, 22813, 304, 22802, 22803, 22804, 22805, 22806, 22807, 22808, 305, 22789, 22790, 22791, 22792, 306, 56, 307, 308, 309, 310, 57, 286, 287, 288, 289, 290, 58, 22821, 291, 292, 293, 294, 325, 59, 311, 312, 313, 314, 315, 316, 317, 318, 77) AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') 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