Project:SPARQL/examples: Difference between revisions

Jump to navigation Jump to search
add pfaf query
(→‎Food Composition Tables in WikiFCD: add timeline fct with pub date query)
(add pfaf query)
Line 112: Line 112:
}}
}}
Limit 100
Limit 100
</SPARQL>
==Federated Query WikiFCD PFaF with Optional Image==
<SPARQL>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wbt: <https://wikifcd.wikibase.cloud/prop/direct/>
PREFIX wb: <https://wikifcd.wikibase.cloud/entity/>
SELECT DISTINCT ?food ?foodLabel ?taxon ?value ?image
WHERE {
?food wbt:P73 ?taxon.
?taxon wbt:P61 ?wikidata.
  ?food rdfs:label ?foodLabel .
 
SERVICE <https://query.wikidata.org/sparql> {
?wikidata wdt:P4301 ?value.
  OPTIONAL {?wikidata wdt:P18 ?image.}
}}
</SPARQL>
</SPARQL>

Navigation menu