Project:SPARQL/examples: Difference between revisions

Jump to navigation Jump to search
Line 90: Line 90:


SELECT DISTINCT ?host ?hostLabel ?pic ?linkto ?linktoLabel ?edgeLabel WHERE {
SELECT DISTINCT ?host ?hostLabel ?pic ?linkto ?linktoLabel ?edgeLabel WHERE {
   ?host pps:P19 ?statement.
   ?host pps:P19 ?s.
   ?statement ppss:P19/ppt:P29* pp:Q141 # include items with parent taxon Q141
   ?s ppss:P19/ppt:P29* pp:Q141 # include items with parent taxon Q141
   OPTIONAL { ?statement ppsq:P20 ?edge }
   OPTIONAL {
   OPTIONAL { ?host ppt:P19 ?linkto }
    ?host pps:P19 ?statement.
    ?statement ppss:P19 ?linkto.
    OPTIONAL { ?statement ppsq:P20 ?edge }
   }
   OPTIONAL { ?host ppt:P33 ?pic }
   OPTIONAL { ?host ppt:P33 ?pic }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

Navigation menu