链接：https://adminlte.io/

select
case when count(*)>0 then 1 else 0 end as gjj_company_is_black –用户的公积金单位名称是否命中公积金黑名单库
from raw.noe_black_single
where source=’GJJ’ and reason=’gjj_suspecious_company’ and uid=${uid}

select * from raw.noe_black_single a
where pk like ‘${mob}#mob#%’
and source in(‘project-d’,’puhui’,’post_loan_performance’,’TD’,’ZM’)
and black_type=’mob’ and is_valid=1

select max(case when b.content is not null then 1 else 0 end) as dpn_user_profile_mob_blacklist
from ods_noe_haixin_black_single_mob b where uid = ${uid}