PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX sio: <http://semanticscience.org/resource/>
PREFIX ncit: <http://ncicb.nci.nih.gov/xml/owl/EVS/Thesaurus.owl#>

SELECT DISTINCT
    STR(?umlsID) AS ?umlsID
    STR(?diseasename) AS ?diseasename
    STR(?meshID) AS ?meshID
    STR(?omimID) AS ?omimID
    STR(?nciID) AS ?nciID
    STR(?orphanetID) AS ?orphanetID
    STR(?icd_9_cmID) AS ?icd_9_cmID

        WHERE {
            ?disease a ncit:C7057, sio:SIO_010299;
                      sio:SIO_000008 <http://purl.bioontology.org/ontology/STY/T047>;
                      dcterms:identifier ?umlsID;
                      dcterms:title ?diseasename
            OPTIONAL {?disease skos:exactMatch ?mesh.
                      FILTER REGEX (?mesh,"identifiers.org/mesh/").
                      ?mesh dcterms:identifier ?meshID}
            OPTIONAL {?disease skos:exactMatch ?omim.
                      FILTER REGEX (?omim, "identifiers.org/omim/").
                      ?omim dcterms:identifier ?omimID}
            OPTIONAL {?disease skos:exactMatch ?ncit
                      FILTER REGEX (?ncit,"identifiers.org/ncit/").
                      ?ncit dcterms:identifier ?nciID}
            OPTIONAL {?disease skos:exactMatch ?orpha
                      FILTER REGEX (?orpha,"identifiers.org/orphanet/").
                      ?orpha dcterms:identifier ?orphanetID}
            OPTIONAL {?disease skos:exactMatch ?icd
                      FILTER REGEX (?icd,"ontology/ICD9CM/").
                      ?icd dcterms:identifier ?icd_9_cmID}

        }
        ORDER BY (?umlsID)