select 			
				cc.NAME AS 客户名称,
                ( SELECT NAME FROM c_custom_level WHERE c_custom_level_id = cc.c_custom_level_id limit 1) AS 客户等级,
                ( SELECT descp FROM c_custom_type WHERE c_custom_type_id = cc.c_custom_type_id limit 1) AS 客户类别,
                ( SELECT NAME FROM c_custom_group WHERE c_custom_group_id = cc.c_custom_group_id limit 1) AS 客户分组,
                ( SELECT descp FROM b_custom_scale WHERE b_custom_scale_id = cc.b_custom_scale_id  limit 1) as 客户规模,
                cc.website as 客户网址,
                cc.addr as 客户地址,
                ( SELECT name_en FROM b_country WHERE b_country_id = cc.b_country_id limit 1) AS 客户国家,
                ( SELECT name_zh FROM b_country WHERE b_country_id = cc.b_country_id limit 1) AS 客户国家,
                ( SELECT name FROM c_custom_from WHERE c_custom_from_id = cc.c_custom_from_id limit 1) AS 客户来源,               
				( SELECT case when count( co.c_order_id ) = 0 then '无' else '有' end  FROM c_order co WHERE co.c_custom_id = cc.c_custom_id AND co.is_delete = 0 limit 1) AS 有无订单,			
                ( SELECT name FROM c_contact WHERE c_custom_id = cc.c_custom_id limit 1)  as 联系人,
                ( SELECT nick_name FROM c_contact WHERE c_custom_id = cc.c_custom_id limit 1)  as 客户昵称,
                 ( SELECT zz.descp FROM c_contact qq join b_job zz on zz.b_job_id = qq.b_job_id WHERE  qq.c_custom_id  = cc.c_custom_id limit 1)  as 客户职位,
                ( SELECT case when sex = '1' then '男' when sex = '2' then '女' else '未知' end FROM c_contact WHERE c_custom_id = cc.c_custom_id limit 1)  as 客户性别,
		( SELECT bb.name_zh FROM c_custom_prodt aa left join p_prodt bb on bb.p_prodt_id = aa.p_prodt_id
                 WHERE aa.c_custom_id = cc.c_custom_id limit 1) AS 关注产品,
                hh.name AS 关注产品分类,
                ( SELECT bb.t_phone_code FROM c_contact aa left join c_contact_phone bb on bb.c_contact_id = aa.c_contact_id
                 WHERE aa.c_custom_id = cc.c_custom_id limit 1) AS 客户电话国家号,
				( SELECT bb.t_area_code FROM c_contact aa left join c_contact_phone bb on bb.c_contact_id = aa.c_contact_id
                 WHERE aa.c_custom_id = cc.c_custom_id  limit 1) AS 客户电话区号,
                 ( SELECT bb.t_number FROM c_contact aa left join c_contact_phone bb on bb.c_contact_id = aa.c_contact_id
                 WHERE aa.c_custom_id = cc.c_custom_id limit 1) AS 客户电话号,
                ( SELECT bb.email FROM c_contact aa left join c_contact_email bb on bb.c_contact_id = aa.c_contact_id
                 WHERE aa.c_custom_id = cc.c_custom_id limit 1) AS 客户邮箱,
                ( SELECT gg.name FROM c_contact aa left join c_contact_sns bb on bb.c_contact_id = aa.c_contact_id
                  left join b_sns gg on gg.b_sns_id = bb.b_sns_id WHERE aa.c_custom_id = cc.c_custom_id limit 1) AS 社交人平台,
                (SELECT nick_name FROM c_belg_hist cbh1 WHERE cbh1.op_mem_id = mm.m_mem_id limit 1)	 AS 归属人,
		   		cc.belg_tm as 归属时间,
           		cc.rgst_tm as 添加时间,
             	( SELECT rmk FROM c_contact WHERE c_custom_id = cc.c_custom_id limit 1) as 备注	
			FROM	
				crm.c_custom cc
			LEFT JOIN m_mem mm 
            	ON mm.m_mem_id = cc.m_mem_id   
            left join(
                 SELECT aa.c_custom_id,
                		bb.name 
                	FROM c_custom_prodt_kind aa 
                	left join p_prodt_kind bb
                	on bb.p_prodt_kind_id = aa.p_prodt_kind_id
            )hh on hh.c_custom_id = cc.c_custom_id 
			WHERE cc.m_account_id = 1000000167
				AND cc.belg_type = 2
				and not EXISTS (
				select c_custom_id 
				  from c_mem_black cmb 
					where cmb.m_mem_id=1000000403 
						and cmb.c_custom_id = cc.c_custom_id
				)
			order by cc.belg_tm	desc