select count(*) from (select cl1.* from credential_list cl1 left join credential_list cl2
    on (cl1.doc_type = cl2.doc_type and cl1.id = cl2.id and cl1.updated_date < cl2.updated_date)
where cl2.updated_date is null) as cl_filtered_latest_udpated_date_per_id_doc_type
where doc_type = 'PHA' and validity_date > CURDATE() and validity_date <= DATE_ADD(CURDATE(), INTERVAL 1 MONTH);