select `company_certification`.`US-FDA` as `usfda`, count("company_certification.US-FDA") as "total_usfda" from `suppliers` innerjoin `company_certification` on `suppliers`.`comp_id` = `company_certification`.`comp_id` where `company_certification`.`US-FDA` !='--'
select `company_certification`.`EDQM/EMA/EU-GMP` as `edqm`, count("company_certification.EDQM/EMA/EU-GMP") as "total_edqm" from `suppliers` innerjoin `company_certification` on `suppliers`.`comp_id` = `company_certification`.`comp_id` where `company_certification`.`EDQM/EMA/EU-GMP` !='--'
select `company_certification`.`PMDA_Japan` as `pmda`, count("company_certification.PMDA_Japan") as "total_pmda" from `suppliers` innerjoin `company_certification` on `suppliers`.`comp_id` = `company_certification`.`comp_id` where `company_certification`.`PMDA_Japan` !='--'
select `company_certification`.`TGA_Australia` as `tga`, count("company_certification.TGA_Australia") as "total_tga" from `suppliers` innerjoin `company_certification` on `suppliers`.`comp_id` = `company_certification`.`comp_id` where `company_certification`.`TGA_Australia` !='--'
select `company_certification`.`KFDA` as `kfda`, count("company_certification.KFDA") as "total_kfda" from `suppliers` innerjoin `company_certification` on `suppliers`.`comp_id` = `company_certification`.`comp_id` where `company_certification`.`KFDA` !='--'
select `company_certification`.`GMP/cGMP` as `gmp`, count("company_certification.GMP/cGMP") as "total_gmp" from `suppliers` innerjoin `company_certification` on `suppliers`.`comp_id` = `company_certification`.`comp_id` where `company_certification`.`GMP/cGMP` !='--'
select `company_certification`.`WHO-GMP/WHO-CGMP`, count("company_certification.WHO-GMP/WHO-CGMP") as "total_who" from `suppliers` innerjoin `company_certification` on `suppliers`.`comp_id` = `company_certification`.`comp_id` where `company_certification`.`WHO-GMP/WHO-CGMP` !='--'
select `company_certification`.`PICS`, count("company_certification.PICS") as "total_pics" from `suppliers` innerjoin `company_certification` on `suppliers`.`comp_id` = `company_certification`.`comp_id` where `company_certification`.`PICS` !='--'
select `company_certification`.`HEALTH_CANADA`, count("company_certification.HEALTH_CANADA") as "total_health" from `suppliers` innerjoin `company_certification` on `suppliers`.`comp_id` = `company_certification`.`comp_id` where `company_certification`.`HEALTH_CANADA` !='--'
select `company_certification`.`MHRA_UK`, count("company_certification.MHRA_UK") as "total_mhra" from `suppliers` innerjoin `company_certification` on `suppliers`.`comp_id` = `company_certification`.`comp_id` where `company_certification`.`MHRA_UK` !='--'
select `company_certification`.`US-DMF`, count("company_certification.US-DMF") as "total_usdmf" from `suppliers` innerjoin `company_certification` on `suppliers`.`comp_id` = `company_certification`.`comp_id` where `company_certification`.`US-DMF` !='--'
select `company_certification`.`JDMF_Japan`, count("company_certification.JDMF_Japan") as "total_jdmf" from `suppliers` innerjoin `company_certification` on `suppliers`.`comp_id` = `company_certification`.`comp_id` where `company_certification`.`JDMF_Japan` !='--'
select `company_certification`.`KDMF_Korea`, count("company_certification.KDMF_Korea") as "total_kdmf" from `suppliers` innerjoin `company_certification` on `suppliers`.`comp_id` = `company_certification`.`comp_id` where `company_certification`.`KDMF_Korea` !='--'
select `company_certification`.`CEP/COS_EU` as `cep`, count("company_certification.CEP/COS_EU") as "total_cep" from `suppliers` innerjoin `company_certification` on `suppliers`.`comp_id` = `company_certification`.`comp_id` where `company_certification`.`CEP/COS_EU` !='--'
select `company_certification`.`SFDA` as `sfda`, count("company_certification.SFDA") as "total_sfda" from `suppliers` innerjoin `company_certification` on `suppliers`.`comp_id` = `company_certification`.`comp_id` where `company_certification`.`SFDA` !='--'
select `company_certification`.`CFDA` as `cfda`, count("company_certification.CFDA") as "total_cfda" from `suppliers` innerjoin `company_certification` on `suppliers`.`comp_id` = `company_certification`.`comp_id` where `company_certification`.`CFDA` !='--'
select `company_certification`.`JFDA` as `jfda`, count("company_certification.JFDA") as "total_jfda" from `suppliers` innerjoin `company_certification` on `suppliers`.`comp_id` = `company_certification`.`comp_id` where `company_certification`.`JFDA` !='--'
select `company_certification`.`TFDA` as `jfda`, count("company_certification.TFDA") as "total_tfda" from `suppliers` innerjoin `company_certification` on `suppliers`.`comp_id` = `company_certification`.`comp_id` where `company_certification`.`TFDA` !='--'
select `company_certification`.`REACH/ECHA_EU` as `reach`, count("company_certification.REACH/ECHA_EU") as "total_reach" from `suppliers` innerjoin `company_certification` on `suppliers`.`comp_id` = `company_certification`.`comp_id` where `company_certification`.`REACH/ECHA_EU` !='--'
select `company_certification`.`Written_Confirm_EU` as `wc`, count("company_certification.Written_Confirm_EU") as "total_wc" from `suppliers` innerjoin `company_certification` on `suppliers`.`comp_id` = `company_certification`.`comp_id` where `company_certification`.`Written_Confirm_EU` !='--'
select `company_certification`.`FSSAI` as `fssai`, count("company_certification.FSSAI") as "total_fssai" from `suppliers` innerjoin `company_certification` on `suppliers`.`comp_id` = `company_certification`.`comp_id` where `company_certification`.`FSSAI` !='--'
select `company_certification`.`Other_Certifications` as `other`, count("company_certification.Other_Certifications") as "total_other" from `suppliers` innerjoin `company_certification` on `suppliers`.`comp_id` = `company_certification`.`comp_id` where `company_certification`.`Other_Certifications` !='--'