Jdouglas has uploaded a new change for review. https://gerrit.wikimedia.org/r/205984
Change subject: Document various interesting SPARQL query examples ...................................................................... Document various interesting SPARQL query examples Fixes #T96925 Change-Id: Ibe55d07da58cda357cc2fde3a8e14280b5999db9 --- A docs/sparql-query-examples.md 1 file changed, 94 insertions(+), 0 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/wikidata/query/rdf refs/changes/84/205984/1 diff --git a/docs/sparql-query-examples.md b/docs/sparql-query-examples.md new file mode 100644 index 0000000..5f20d4e --- /dev/null +++ b/docs/sparql-query-examples.md @@ -0,0 +1,94 @@ +# SPARQL query examples + +## Who were Feynman's employers? + +* Feynman: [Q39246](https://www.wikidata.org/wiki/Q39246) +* employer: [P108](https://www.wikidata.org/wiki/Property:P108) +* Commons category (a.k.a. label): [P373](https://www.wikidata.org/wiki/Property:P373) + +```sparql +prefix wd: <http://www.wikidata.org/entity/> +select ?name where { + wd:Q39246 wd:P108s/wd:P108v ?employer . + ?employer wd:P373s/wd:P373v ?name . +} +``` + +## Who are Feynman's colleagues? + +```sparql +prefix wd: <http://www.wikidata.org/entity/> +select ?employerName ?colleagueName where { + wd:Q39246 wd:P108s/wd:P108v ?employer . + ?colleague wd:P108s/wd:P108v ?employer . + ?employer wd:P373s/wd:P373v ?employerName . + ?colleague wd:P373s/wd:P373v ?colleagueName . +} +``` + +## What are the fields of Feynman's colleagues? + +* field of work: [P101](https://www.wikidata.org/wiki/Property:P101) + +```sparql +prefix wd: <http://www.wikidata.org/entity/> +select ?colleagueName ?fieldName where { + wd:Q39246 wd:P108s/wd:P108v ?employer . + ?colleague wd:P108s/wd:P108v ?employer . + ?colleague wd:P373s/wd:P373v ?colleagueName . + ?colleague wd:P101s/wd:P101v ?field . + ?field wd:P373s/wd:P373v ?fieldName . +} +``` + +## What are the fields of Feynman's colleagues who are physicists? + +* occupation: [P106](https://www.wikidata.org/wiki/Property:P106) +* physicist: [Q169470](https://www.wikidata.org/wiki/Q169470) + +```sparql +prefix wd: <http://www.wikidata.org/entity/> +select ?colleagueName ?fieldName ?employerName where { + wd:Q39246 wd:P108s/wd:P108v ?employer . + ?colleague wd:P108s/wd:P108v ?employer . + ?colleague wd:P106s/wd:P106v wd:Q169470 . + ?employer wd:P373s/wd:P373v ?employerName . + ?colleague wd:P373s/wd:P373v ?colleagueName . + ?colleague wd:P101s/wd:P101v ?field . + ?field wd:P373s/wd:P373v ?fieldName . +} +``` + +## Whose birthday is it? + +```sparql +prefix wd: <http://www.wikidata.org/entity/> +prefix wdo: <http://www.wikidata.org/ontology#> +prefix xsd: <http://www.w3.org/2001/XMLSchema#> +select ?entityLabel ?date where { + ?entity wd:P569s/wd:P569v ?dateV . + ?dateV wdo:preferredCalendar wd:Q1985727 . + ?dateV wdo:time ?date . + ?entity wd:P373s/wd:P373v ?entityLabel . + filter ( regex(str(?date), "\\d{4}-\\d{2}-\\d{2}") ) + filter ( xsd:integer(substr(str(?date), 6, 2)) = month(now()) ) + filter ( xsd:integer(substr(str(?date), 9, 2)) = day(now()) ) +} limit 20 +``` + +## What happened on this day in history? + +```sparql +prefix wd: <http://www.wikidata.org/entity/> +prefix wdo: <http://www.wikidata.org/ontology#> +prefix xsd: <http://www.w3.org/2001/XMLSchema#> +select ?entityLabel ?date where { + ?entity wd:P569s/wd:P569v ?dateV . + ?dateV wdo:preferredCalendar wd:Q1985727 . + ?dateV wdo:time ?date . + ?entity wd:P373s/wd:P373v ?entityLabel . + filter ( regex(str(?date), "\\d{4}-\\d{2}-\\d{2}") ) + filter ( xsd:integer(substr(str(?date), 6, 2)) = month(now()) ) + filter ( xsd:integer(substr(str(?date), 9, 2)) = day(now()) ) +} limit 20 +``` -- To view, visit https://gerrit.wikimedia.org/r/205984 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ibe55d07da58cda357cc2fde3a8e14280b5999db9 Gerrit-PatchSet: 1 Gerrit-Project: wikidata/query/rdf Gerrit-Branch: master Gerrit-Owner: Jdouglas <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
