CREATE TEMPORARY TABLE _product_filters_products_1 (PRIMARY KEY product_id (product_id)) ENGINE = MEMORY IGNORE SELECT products.product_id FROM ushop_products AS products  LEFT JOIN ushop_companies AS companies ON companies.company_id = products.company_id  INNER JOIN ushop_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ushop_categories ON ushop_categories.category_id = products_categories.category_id  AND (ushop_categories.usergroup_ids = '' OR FIND_IN_SET(0, ushop_categories.usergroup_ids) OR FIND_IN_SET(1, ushop_categories.usergroup_ids)) AND ushop_categories.status IN ('A', 'H') AND ushop_categories.storefront_id IN (0, 1)  LEFT JOIN ushop_cp_auctions as auctions ON products.product_id = auctions.product_id LEFT JOIN ushop_users ON products.company_id = ushop_users.company_id 
            AND ushop_users.user_type = 'V' AND ushop_users.user_id = 0 LEFT JOIN ushop_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1=1  AND ushop_categories.category_id IN (316, 349, 353, 359, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521) 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 (CASE 
                WHEN (products.cp_active_auction_id > 0) 
                    THEN ((auctions.users = '' OR FIND_IN_SET(0, auctions.users)) AND auctions.show_on_category = 'Y') 
                ELSE 
                    1 
                END OR ushop_users.company_id = products.company_id) AND products.product_type <> 'W' AND products.product_type != 'D' ORDER BY NULL