Could not execute query 3
SELECT DISTINCT disease_id, t7.name as Disease , t7.id as LSDB_ID, count( distinct t.id) as HPO_Manifestations, count( distinct t6.Manifestation) as NAMDC_Manifestations , ( t2.disease_id IN ('157640', '161700', '201450', '201460', '201470', '201475', '202140', '203700', '212138', '212140', '212160', '220110', '220111', '231680', '238800', '245348', '251880', '251900', '251950', '252010', '252011', '255120', '255125', '256000', '266150', '300352', '302060', '308930', '312170', '516020', '516060', '530000', '535000', '540000', '545000', '551500', '557000', '600650', '601609', '603041', '607426', '607459', '608782', '609016', '611105', '612016', '612718', '612736', '613561', '614111', '614462', '614650', '614651', '614652', '614654', '615650', '607459') ) AS UMDF_Disease FROM hpo201904.external_object_disease AS t2, gb_mito.mito5_diseases as t7, hpo201904.annotation AS t5 LEFT JOIN hpo201904.term AS t ON t.id = t5.term_id LEFT JOIN hpo201904.term_synonym AS t3 ON t3.term_id = t5.term_id LEFT JOIN hpo201904.namdc_clinical_manifestations_of_mitochondrial_disease_20140125 AS t6 ON t6.HPO_ID LIKE CONCAT('HP:%00', t5.term_id ) WHERE disease_id = t7.id_omim AND db_name='OMIM' AND t5.external_object_disease_id = t2.external_object_id GROUP BY disease_id ORDER BY UMDF_Disease DESC, t7.name;