User:Jsamwrites/SPARQL
Example SPARQL Queries edit
Heritage sites edit
SELECT ?id ?geo{
?id wdt:P31 wd:Q358;
wdt:P625 ?coord.
}
LIMIT 1000
Queries edit
Malayalam edit
PREFIX ഡിസി: <http://purl.org/dc/terms/>
PREFIX വിക്കിഡാറ്റ: <http://www.wikidata.org/entity/>
SELECT ?ലെക്സീമുകൾ {
?ലെക്സീമുകൾ ഡിസി:language വിക്കിഡാറ്റ:Q36236
}
Properties edit
Instances edit
SELECT ?item ?itemLabel
WHERE
{
?item wdt:P31 wd:Q5.
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 100
Properties, their labels and description in different languages edit
SELECT ?property ?propertyLabel ?propertyDescription (lang(?propertyLabel) as ?lang)
WHERE
{
?property a wikibase:Property
; rdfs:label ?propertyLabel
; schema:description ?propertyDescription.
filter(lang(?propertyLabel) = lang(?propertyDescription)).
}
LIMIT 100
Finding Lists and their Wikipedia Links edit
SELECT DISTINCT ?item ?itemLabel ?sitelink
WHERE
{
?item rdfs:label ?label; wdt:P31 wd:Q13406463.
?sitelink schema:about ?item; schema:inLanguage "en"; schema:isPartOf <https://en.wikipedia.org/>
FILTER CONTAINS(?label,"programming") .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 100
Programming languages with missing English Labels edit
SELECT ?item ?label
WHERE {?item wdt:P31 wd:Q9143.
FILTER NOT EXISTS{
?item rdfs:label ?label.
FILTER (lang(?label)='en').
}
}