MSeqDR Mitochondrial Disease Portal
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;