select *
from (
    select 'CC23040108550343'  as cc_task_code  -- 数据作为已张表
) a
 where a.cc_task_code  not  in(select DISTINCT( `cc_task_code`)  from `t_consistency_cp` where `cc_task_code` is not null)