Dreams:taxon-index: Difference between revisions
Jump to navigation
Jump to search
(Created page with "== Taxons == {{SPARQL | query= PREFIX dreams: <https://dreams.wikibase.cloud/entity/> PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/> SELECT ?reports ?taxon WITH { SELECT (COUNT(DISTINCT ?report) AS ?reports) ?taxon WHERE { ?report dreamst:P28 ?taxon . } GROUP BY ?taxon } AS %result WHERE { INCLUDE %result SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en". } } ORDER BY DESC(?reports) }}") |
|||
| (4 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 | ||
?taxon | ?rapporter | ||
?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 20: | 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)