SPARQL Examples: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 3: | Line 3: | ||
All records associated with our various projects on Wikibase | All records associated with our various projects on Wikibase | ||
{{SPARQL|query=# All records associated with our various projects on Wikibase | {{SPARQL|query=<nowiki># All records associated with our various projects on Wikibase | ||
SELECT DISTINCT ?item ?itemLabel ?type ?typeLabel ?project ?projectLabel WHERE | SELECT DISTINCT ?item ?itemLabel ?type ?typeLabel ?project ?projectLabel WHERE { | ||
?item wdt:P1 ?type. | ?item wdt:P1 ?type. | ||
?item wdt:P11 ?project. | ?item wdt:P11 ?project. | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} | |||
ORDER BY ?projectLabel | ORDER BY ?projectLabel</nowiki> | ||
}} | }} | ||
| Line 17: | Line 17: | ||
{{SPARQL|query=#All person records associated with our projects on Wikibase | {{SPARQL|query=<nowiki>#All person records associated with our projects on Wikibase | ||
SELECT ?person ?personLabel ?project ?projectLabel | SELECT ?person ?personLabel ?project ?projectLabel | ||
| Line 27: | Line 27: | ||
} | } | ||
ORDER BY ?projectLabel | ORDER BY ?projectLabel</nowiki> | ||
}} | }} | ||
| Line 33: | Line 33: | ||
{{SPARQL|query=#All city records associated with our projects on Wikibase | {{SPARQL|query=<nowiki>#All city records associated with our projects on Wikibase | ||
SELECT ?city ?cityLabel WHERE { | SELECT ?city ?cityLabel WHERE { | ||
?city wdt:P1 wd:Q19058. | ?city wdt:P1 wd:Q19058. | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} | }</nowiki> | ||
}} | }} | ||
Latest revision as of 14:32, 8 March 2024
All records
All records associated with our various projects on Wikibase
# All records associated with our various projects on Wikibase
SELECT DISTINCT ?item ?itemLabel ?type ?typeLabel ?project ?projectLabel WHERE {
?item wdt:P1 ?type.
?item wdt:P11 ?project.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?projectLabel
All person records
#All person records associated with our projects on Wikibase
SELECT ?person ?personLabel ?project ?projectLabel
WHERE
{
?person wdt:P1 wd:Q1.
?person wdt:P11 ?project.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?projectLabel
All city records
#All city records associated with our projects on Wikibase
SELECT ?city ?cityLabel WHERE {
?city wdt:P1 wd:Q19058.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}