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