Citation 1947

                  PREFIX n: <https://nap.nprod.net/>
SELECT ?organism ?pharmacy ?genus ?species ?family ?number ?pharmacology ?pharmacology_name ?worktype ?qualitativeResult ?compound ?compound_name
WHERE {
    ?organism a n:organism ;
              n:participatesIn <https://nap.nprod.net/citation/1947>.
    ?pharmacy n:has_organism ?organism ;
              n:number ?number .
    OPTIONAL { ?pharmacy n:has_pharmacology ?pharmacology .
               ?pharmacology n:name ?pharmacology_name . }
    OPTIONAL { ?pharmacy n:has_worktype ?worktype . }
    OPTIONAL { ?pharmacy n:has_qualitativeresult ?qualitativeResult . }
    OPTIONAL { ?organism n:genusname ?genus . }
    OPTIONAL { ?organism n:speciesname ?species . }
    OPTIONAL { ?organism n:familyname ?family . }
    OPTIONAL { ?pharmacy n:has_participant ?compound .
               ?compound a n:compound ;
                         n:name ?compound_name . }
}
ORDER BY ?organism ?number