CREATE TEMPORARY TABLE _product_filters_products_1 (PRIMARY KEY product_id (product_id)) ENGINE = MEMORY IGNORE SELECT products.product_id FROM cscart_products AS products  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_product_prices as prices_2 ON prices.product_id = prices_2.product_id AND prices_2.lower_limit = 1 AND prices_2.price < prices.price  AND prices_2.usergroup_id IN (0, 0, 1) LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id  LEFT JOIN cscart_products_tag_categories as products_tag_categories ON products_tag_categories.product_id = products.product_id LEFT JOIN cscart_categories ON cscart_categories.category_id = products_tag_categories.category_id LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1=1  AND cscart_categories.category_id IN (508) AND companies.status IN ('A') AND prices.price >= 200000.00 AND prices.price <= 500000.00 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') AND prices.usergroup_id IN (0, 0, 1) AND prices_2.price IS NULL ORDER BY NULL