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