1
2
3
4
5
6
7
8
select element_info,GROUP_CONCAT(`user_id`) as user_list,bg,user_source,user_count,type_id,date8,model_id,freezed_status,add_time,admin_name,update_time From (  select bg.element_info,bd.user_id,bd.bg,bd.user_source,bd.add_time, bg.user_count,bg.type_id,bg.date8,bg.model_id,bg.freezed_status,bg.admin_name,bg.update_time from badgang_detail as bd left join badgang as bg on   bd.count_id = bg.id ) as a group by element_info limit 10 ;




select element_info,GROUP_CONCAT(`user_id`) as user_list,bg,user_source,user_count,type_id,date8,model_id,freezed_status,add_time,admin_name,update_time From (  select bg.element_info,bd.user_id,bd.bg,bd.user_source,bd.add_time, bg.user_count,bg.type_id,bg.date8,bg.model_id,bg.freezed_status,bg.admin_name,bg.update_time from badgang_detail as bd left join badgang as bg on   bd.count_id = bg.id ) as a group by element_info


1310754318@qq.com