Project:SPARQL/examples: Difference between revisions
Jump to navigation
Jump to search
(→Food Composition Tables in WikiFCD: add query for food items with FoodOn id and NALT id) |
|||
Line 12: | Line 12: | ||
} | } | ||
</SPARQL> | </SPARQL> | ||
== | ==WikiFCD federated query for food items with foodOn id and NALT id== | ||
<SPARQL> | <SPARQL> | ||
PREFIX wd: <http://www.wikidata.org/entity/> | PREFIX wd: <http://www.wikidata.org/entity/> | ||
Line 19: | Line 19: | ||
PREFIX p: <https://wikifcd.wikibase.cloud/prop/> | PREFIX p: <https://wikifcd.wikibase.cloud/prop/> | ||
PREFIX pr: <https://wikifcd.wikibase.cloud/prop/reference/> | PREFIX pr: <https://wikifcd.wikibase.cloud/prop/reference/> | ||
PREFIX dct: <http://purl.org/dc/terms/> | |||
SELECT DISTINCT ?item ?itemLabel ?foodon ?nalt WHERE { | SELECT DISTINCT ?item ?itemLabel ?foodon ?nalt WHERE { | ||
Line 28: | Line 28: | ||
?item rdfs:label ?itemLabel | ?item rdfs:label ?itemLabel | ||
SERVICE <https://query.wikidata.org/sparql> { | SERVICE <https://query.wikidata.org/sparql> { | ||
?wikidata wdt:P2004 ?nalt | ?wikidata wdt:P2004 ?nalt | ||
}} | }} | ||
</SPARQL> | </SPARQL> |
Revision as of 21:05, 14 August 2022
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
}}