Querying: Difference between revisions

From ottgaz.org
Jump to navigation Jump to search
Line 23: Line 23:
       filter langMatches(lang(?vilayetLabel), "en")
       filter langMatches(lang(?vilayetLabel), "en")
     }
     }
}
or better still:
SELECT ?vilayet ?vilayetLabel
WHERE
{
  ?vilayet wdt:P6 wd:Q5 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
  }
  }

Revision as of 02:07, 1 October 2022

Run SPARQL queries via the Ottgaz Query Service.

Remember: SPARQL is currently case sensitive, as elastic search is disabled in wikibase.cloud.

Namespace

Declare these namespaces at the start of every query:

PREFIX wd: <https://ottgaz.org/entity/>
PREFIX wdt: <https://ottgaz.org/prop/direct/>

Sample queries

Label

All items that are vilayets, as well as their English language label. run

SELECT ?vilayet ?vilayetLabel
WHERE 
{
  ?vilayet wdt:P6 wd:Q5 . 
  optional { 
     ?vilayet rdfs:label ?vilayetLabel
     filter langMatches(lang(?vilayetLabel), "en")
   }
}

or better still:

SELECT ?vilayet ?vilayetLabel
WHERE 
{
  ?vilayet wdt:P6 wd:Q5 . 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}