SPARQL examples: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary Tag: Reverted |
||
| Line 15: | Line 15: | ||
[https://{{SERVERNAME}}/wdqs/#SELECT%20%3Fitem%20%3FitemLabel%20%0AWHERE%20%0A%7B%0A%20%20%3Fitem%20wdt%3AP31%20wd%3AQ146.%20%23%20Must%20be%20of%20a%20cat%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%20%23%20Helps%20get%20the%20label%20in%20your%20language%2C%20if%20not%2C%20then%20en%20language%0A%7D Try it!] | [https://{{SERVERNAME}}/wdqs/#SELECT%20%3Fitem%20%3FitemLabel%20%0AWHERE%20%0A%7B%0A%20%20%3Fitem%20wdt%3AP31%20wd%3AQ146.%20%23%20Must%20be%20of%20a%20cat%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%20%23%20Helps%20get%20the%20label%20in%20your%20language%2C%20if%20not%2C%20then%20en%20language%0A%7D Try it!] | ||
=== <!--T:2--> | === <!--T:2--> All humans=== | ||
<syntaxhighlight lang="SPARQL" class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"> | <syntaxhighlight lang="SPARQL" class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"> | ||
Revision as of 11:16, 12 May 2022
This page is parsed by the web interface of the query service to fill the query example dialog.
Institutions
SELECT ?institution ?institutionLabel
WHERE
{
?institution wdt:P47 wd:Q467. # instance of Institution
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
All humans
#Lists all humans with values of selected fields
SELECT ?human ?humanLabel ?fatherLabel ?motherLabel ?date_of_birth WHERE {
?human wdt:P47 wd:Q32.
OPTIONAL { ?human wdt:P66 ?father. }
OPTIONAL { ?human wdt:P68 ?mother. }
OPTIONAL { ?human wdt:P7 ?date_of_birth. }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Humans without parents
#Lists all humans without parents
SELECT ?human ?humanLabel WHERE {
?human wdt:P47 wd:Q32. #find humans
MINUS {
?human wdt:P68 [] . # without father
?human wdt:P66 [] . # without mother
?human wdt:P65 [] . # without any unspecified parent
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}