Dreams:location: Difference between revisions
Jump to navigation
Jump to search
(Created page with "== Reports == {{SPARQL | query= PREFIX target: <https://dreams.wikibase.cloud/entity/Q306> PREFIX dreams: <https://dreams.wikibase.cloud/entity/> PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/> SELECT ?report ?reportLabel (CONCAT("#report/", SUBSTR(STR(?report), 38)) AS ?reportUrl) WHERE { ?report dreamst:P12 target: . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en". } } }}") |
(Co-mentioned locations) |
||
| Line 12: | Line 12: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en". } | ||
} | } | ||
}} | |||
== Co-mentioned locations == | |||
{{SPARQL | query= | |||
PREFIX target: <https://dreams.wikibase.cloud/entity/Q306> | |||
PREFIX dreams: <https://dreams.wikibase.cloud/entity/> | |||
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/> | |||
SELECT | |||
(COUNT(?report) AS ?count) | |||
?location ?locationLabel | |||
(CONCAT("#location/", SUBSTR(STR(?location), 38)) AS ?locationUrl) | |||
WHERE { | |||
?report dreamst:P12 target: , ?location . | |||
FILTER (target: != ?location) | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en". } | |||
} | |||
GROUP BY ?location ?locationLabel ?locationUrl | |||
}} | }} | ||
Revision as of 15:02, 24 August 2022
Reports
PREFIX target: <https://dreams.wikibase.cloud/entity/Q306> PREFIX dreams: <https://dreams.wikibase.cloud/entity/> PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/> SELECT ?report ?reportLabel (CONCAT("#report/", SUBSTR(STR(?report), 38)) AS ?reportUrl) WHERE { ?report dreamst:P12 target: . SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en". } }
Co-mentioned locations
PREFIX target: <https://dreams.wikibase.cloud/entity/Q306> PREFIX dreams: <https://dreams.wikibase.cloud/entity/> PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/> SELECT (COUNT(?report) AS ?count) ?location ?locationLabel (CONCAT("#location/", SUBSTR(STR(?location), 38)) AS ?locationUrl) WHERE { ?report dreamst:P12 target: , ?location . FILTER (target: != ?location) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],da,en". } } GROUP BY ?location ?locationLabel ?locationUrl