Project:SPARQL/examples

From wikifcd
Revision as of 21:04, 14 August 2022 by Kat (talk | contribs) (→‎Food Composition Tables in WikiFCD: add query for food items with FoodOn id and NALT id)
Jump to navigation Jump to search

Food Composition Tables in WikiFCD

PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wbt: <https://wikifcd.wikibase.cloud/prop/direct/>
PREFIX wb: <https://wikifcd.wikibase.cloud/entity/>
PREFIX p: <https://wikifcd.wikibase.cloud/prop/>
PREFIX prov: <http://www.w3.org/ns/prov#>

SELECT ?item ?itemLabel WHERE {
  ?item wbt:P1 wb:Q12. 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }

wikiFCD federated query for food items with foodOn id and NALT id

PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wbt: <https://wikifcd.wikibase.cloud/prop/direct/>
PREFIX wb: <https://wikifcd.wikibase.cloud/entity/>
PREFIX p: <https://wikifcd.wikibase.cloud/prop/>
PREFIX pr: <https://wikifcd.wikibase.cloud/prop/reference/>
 PREFIX dct: <http://purl.org/dc/terms/>

SELECT DISTINCT ?item ?itemLabel ?foodon ?nalt  WHERE {
?food wbt:P73 ?item.
?item wbt:P1 wb:Q20.
?food wbt:P309 ?foodon.
?item wbt:P61 ?wikidata.
?item rdfs:label ?itemLabel 
  SERVICE <https://query.wikidata.org/sparql> {
     ?wikidata wdt:P2004 ?nalt
 
   
  }}