Dreams:taxon-index: Difference between revisions
Jump to navigation
Jump to search
(→Taxons: taxonUrl) |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== | == Taksoner == | ||
{{SPARQL | query= | {{SPARQL | query= | ||
PREFIX dreams: <https://dreams.wikibase.cloud/entity/> | PREFIX dreams: <https://dreams.wikibase.cloud/entity/> | ||
| Line 5: | Line 5: | ||
SELECT | SELECT | ||
? | ?mønstre | ||
? | ?rapporter | ||
(CONCAT("#taxon/", SUBSTR(STR(? | ?takson ?taksonLabel | ||
(CONCAT("#taxon/", SUBSTR(STR(?takson), 38)) AS ?taksonUrl) | |||
WITH { | WITH { | ||
SELECT | SELECT | ||
(COUNT(DISTINCT ? | (COUNT(DISTINCT ?mønster) AS ?mønstre) | ||
? | (COUNT(DISTINCT ?rapport) AS ?rapporter) | ||
?takson | |||
WHERE { | WHERE { | ||
? | ?takson dreamst:P2 dreams:Q215 . | ||
OPTIONAL { ?rapport dreamst:P28 ?takson . } | |||
OPTIONAL { ?mønster dreamst:P55 ?takson . } | |||
} | } | ||
GROUP BY ? | GROUP BY ?takson | ||
} AS %result | } AS %result | ||
WHERE { | WHERE { | ||
| Line 21: | Line 25: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en". } | ||
} | } | ||
ORDER BY DESC(? | ORDER BY DESC(?mønstre) DESC(?rapporter) | ||
}} | }} | ||
Latest revision as of 14:05, 15 March 2023
Taksoner
PREFIX dreams: <https://dreams.wikibase.cloud/entity/> PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/> SELECT ?mønstre ?rapporter ?takson ?taksonLabel (CONCAT("#taxon/", SUBSTR(STR(?takson), 38)) AS ?taksonUrl) WITH { SELECT (COUNT(DISTINCT ?mønster) AS ?mønstre) (COUNT(DISTINCT ?rapport) AS ?rapporter) ?takson WHERE { ?takson dreamst:P2 dreams:Q215 . OPTIONAL { ?rapport dreamst:P28 ?takson . } OPTIONAL { ?mønster dreamst:P55 ?takson . } } GROUP BY ?takson } AS %result WHERE { INCLUDE %result SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en". } } ORDER BY DESC(?mønstre) DESC(?rapporter)