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 hpo.external_object_disease AS t2, gb_exome.mito5_diseases as t7, hpo.annotation AS t5 LEFT JOIN hpo.term AS t ON t.id = t5.term_id LEFT JOIN hpo.term_synonym AS t3 ON t3.term_id = t5.term_id LEFT JOIN hpo.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;