Hearing Loss Disease Portal
Could not execute query 2
SELECT DISTINCT t7.ConceptID, t7.DiseaseMIM as id_omim, t7.DiseaseName as Disease , t7.DiseaseMIM as LSDB_ID , count( distinct t2.HPO_ID) as HPO_Manifestations
, ( t7.DiseaseMIM IN (select DiseaseMIM from gb_exome.clinvar_disease_name_latest_hl2 where length(DiseaseMIM)> 3)) AS HL_Disease
, OMIM_name
FROM gb_exome.clinvar_disease_name_latest_hl2 as t7
LEFT JOIN gb_exome.clinvar_medgen_omim_hpo_mapping_latest AS t2 ON ( t2.MIM_number = t7.DiseaseMIM )
WHERE length(t7.ConceptID)>3 OR length(t7.DiseaseMIM)> 3
GROUP BY t7.ConceptID, t7.DiseaseMIM
ORDER BY t7.DiseaseName, HL_Disease DESC LIMIT 50000;