475,243
edits
Project:SPARQL/examples: Difference between revisions
Jump to navigation
Jump to search
→Food Items with SMILING Cambodia Food Code and Reference: add DHA ranked list query
(→Federated Query WikiFCD PFaF with Optional Image: add smiling cambodia query) |
(→Food Items with SMILING Cambodia Food Code and Reference: add DHA ranked list query) |
||
| Line 149: | Line 149: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} | } | ||
</SPARQL> | |||
==Ranked List of Food Items Containing Most to Least DHA (Docosahexaenoic acid)== | |||
<SPARQL> | |||
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 psv: <https://wikifcd.wikibase.cloud/prop/statement/value/> | |||
SELECT ?itemLabel ?_DHA ?unitLabel WHERE { | |||
?item p:P135/psv:P135 ?DHA. | |||
?DHA wikibase:quantityAmount ?_DHA. | |||
?DHA wikibase:quantityUnit ?unit. | |||
{ SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"} }} | |||
ORDER BY DESC(?_DHA) | |||
</SPARQL> | </SPARQL> | ||