SPARQL Examples: Difference between revisions

From Semantic Lab
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". }
}