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;