SELECT product_id, 
stock_status, 
currency, 
brand_name, 
brand_company_id, 
product_name, 
product_image, 
style_number, 
price_min AS price, 
company_participates, 
MIN(price_min) AS min_price, 
MAX(price_max) AS max_price, 
MAX(has_ptp) AS max_has_ptp, 
MIN(is_dropship) AS is_dropshippable, 
INTERVAL(price,0,25,50,75,100,150,200,300,500,750,1000) AS price_range, 
ANY(x.id = 1161 FOR x IN categories) AS has_category 
            FROM locally:product_stores_2  
            WHERE channel_id = 1 AND suppress_in_native_domain = false AND has_ptp = 1 AND has_category = 1 
            GROUP BY product_id, currency 
            ORDER BY stock_status desc, popularity_rank desc 
            LIMIT 30 OFFSET 0  
            OPTION threads=16, max_query_time=1