17,522
edits
Project:SPARQL/examples: Difference between revisions
Jump to navigation
Jump to search
no edit summary
No edit summary |
No edit summary |
||
| Line 90: | Line 90: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} | } | ||
</sparql> | |||
===Count references and qualifier statements for each interaction=== | |||
<sparql tryit="1"> | |||
PREFIX pps: <https://ppsdb.wikibase.cloud/prop/> | |||
PREFIX ppss: <https://ppsdb.wikibase.cloud/prop/statement/> | |||
PREFIX ppsq: <https://ppsdb.wikibase.cloud/prop/qualifier/> | |||
PREFIX ppsr: <https://ppsdb.wikibase.cloud/prop/reference/> | |||
PREFIX wikibase: <http://wikiba.se/ontology#> | |||
PREFIX prov: <http://www.w3.org/ns/prov#> | |||
PREFIX bd: <http://www.bigdata.com/rdf#> | |||
SELECT ?host ?hostLabel ?symbiont ?symbiontLabel (COUNT(DISTINCT ?refnode) AS ?refnodeCount) (COUNT(DISTINCT ?localization) AS ?localizationCount) (COUNT(DISTINCT ?type) AS ?typeCount) (COUNT(DISTINCT ?methobj) AS ?methobjCount) (COUNT(DISTINCT ?methsub) AS ?methsubCount) WHERE { | |||
?host pps:P19 ?interaction. | |||
?interaction ppss:P19 ?symbiont. | |||
OPTIONAL { ?interaction ppsq:P22 ?methobj. } | |||
OPTIONAL { ?interaction ppsq:P42 ?methsub. } | |||
OPTIONAL { ?interaction ppsq:P20 ?localization. } | |||
OPTIONAL { ?interaction ppsq:P26 ?type. } | |||
OPTIONAL { | |||
?interaction prov:wasDerivedFrom ?refnode. | |||
OPTIONAL { ?refnode ppsr:P27 ?doi. } | |||
OPTIONAL { ?refnode ppsr:P23 ?statedin. } | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | |||
} | |||
GROUP BY ?host ?hostLabel ?symbiont ?symbiontLabel | |||
</sparql> | </sparql> | ||