16,603
edits
Dreams:location: Difference between revisions
Jump to navigation
Jump to search
→Co-mentioned locations
| Line 54: | Line 54: | ||
}} | }} | ||
== | == Samnævnte steder == | ||
{{SPARQL | query= | {{SPARQL | query= | ||
PREFIX target: <https://dreams.wikibase.cloud/entity/Q306> | PREFIX target: <https://dreams.wikibase.cloud/entity/Q306> | ||
| Line 61: | Line 61: | ||
SELECT | SELECT | ||
(COUNT(? | (COUNT(?rapport) AS ?count) | ||
? | ?sted ?stedLabel | ||
(CONCAT("#location/", SUBSTR(STR(? | (CONCAT("#location/", SUBSTR(STR(?sted), 38)) AS ?stedUrl) | ||
WHERE { | WHERE { | ||
? | ?rapport dreamst:P12 target: , ?sted . | ||
FILTER (target: != ? | FILTER (target: != ?sted) | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en". } | ||
} | } | ||
GROUP BY ? | GROUP BY ?sted ?stedLabel ?stedUrl | ||
}} | }} | ||