SELECT o.id,is_group_buy,name AS 'client_name'
FROM order_info o LEFT JOIN client c ON o.client_id=c.id 
WHERE user_id IN

(SELECT user_id FROM order_info 
WHERE status='completed' 
AND date>'2025-10-15' 
AND product_name IN ('C++','Java','Python') 
GROUP BY user_id HAVING COUNT(*)>=2) 

AND status='completed' 
AND date>'2025-10-15' 
AND product_name IN ('C++','Java','Python') 
ORDER BY o.id ASC