with t as (select * from order_info
where date>'2025-10-15' and status='completed' and product_name in('Python','Java','C++'))
select t1.id,is_group_buy,client.name client_name
from (select * from t where user_id in (select user_id from t group by user_id having count(*)>1)) t1
left join client
on t1.client_id=client.id
order by t1.id;