@Select("select count(DISTINCT(id)) from (\n" +
"SELECT\n" +
"\tv.id\n" +
"FROM\n" +
"\tplatform_data_annotation_verify v,\n" +
"\tplatform_data_annotation_assigner_info p \n" +
"WHERE\n" +
"\tp.task_id = #{task_id} and v.task_id = #{task_id}\n" +
"\tand (FIND_IN_SET(#{userId},v.commit_user) > 0 or FIND_IN_SET(#{userId},v.assigner) >0)\n" +
"\tAND v.site_id = p.site_id \n" +
"\tAND v.site_name_cn = p.site_name_cn \n" +
"\tAND ((v.site_name_en = p.site_name_en) or (v.site_name_en is null and p.site_name_en is null)) \n" +
"\tAND ((v.channel = p.channel) or (v.channel is null and p.channel is null)) \n" +
"\tAND ((v.country = p.country) or (v.country is null and p.country is null)) \n" +
"\tAND ((v.pingtai_type = p.pingtai_type) or (v.pingtai_type is null and p.pingtai_type is null)) \n" +
"\tAND ((v.yewu_biaoqian = p.yewu_biaoqian) or (v.yewu_biaoqian is null and p.yewu_biaoqian is null)) \n" +
"\tAND ((v.wangmin_guimo = p.wangmin_guimo) or (v.wangmin_guimo is null and p.wangmin_guimo is null)) \n" +
"\tAND ((v.monthly_active_users = p.monthly_active_users) or (v.monthly_active_users is null and p.monthly_active_users is null)) \n" +
"\tAND ((v.affiliated_company = p.affiliated_company) or (v.affiliated_company is null and p.affiliated_company is null)) \n" +
"\tAND ((v.launch_date = p.launch_date) or (v.launch_date is null and p.launch_date is null)) \n" +
"\tAND ((v.monthly_publication_volume = p.monthly_publication_volume) or (v.monthly_publication_volume is null and p.monthly_publication_volume))\n" +
"\t) t")
public long getConsistentCount(@Param("userId") Integer userId, @Param("task_id")Integer task_id);