Dreams:pattern-index: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 24: | Line 24: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". } | ||
} | } | ||
}} | |||
== Reports == | |||
{{SPARQL | query= | |||
PREFIX dreams: <https://dreams.wikibase.cloud/entity/> | |||
PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/> | |||
PREFIX dreamsp: <https://dreams.wikibase.cloud/prop/> | |||
PREFIX dreamspsv: <https://dreams.wikibase.cloud/prop/statement/value/> | |||
SELECT | |||
?number_of_patterns | |||
?report | |||
?reportLabel | |||
(CONCAT("#report/", SUBSTR(STR(?report), 38)) AS ?reportUrl) | |||
WITH { | |||
SELECT | |||
(COUNT(?pattern) AS ?number_of_patterns) | |||
?report | |||
WHERE { | |||
?pattern dreamst:P2 dreams:Q263 ; | |||
dreamst:P20 ?report . | |||
} | |||
GROUP BY ?report | |||
} AS %result | |||
WHERE { | |||
INCLUDE %result | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". } | |||
} | |||
ORDER BY DESC(?number_of_patterns) | |||
}} | }} | ||
Revision as of 13:03, 11 August 2022
Patterns
PREFIX dreams: <https://dreams.wikibase.cloud/entity/> PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/> PREFIX dreamsp: <https://dreams.wikibase.cloud/prop/> PREFIX dreamspsv: <https://dreams.wikibase.cloud/prop/statement/value/> SELECT ?effect ?effectLabel ?subject ?subjectLabel ?object ?objectLabel ?quote ?project_phase ?project_phaseLabel ?project_type ?project_typeLabel ?report ?reportLabel WHERE { ?effect dreamst:P2 dreams:Q263 ; dreamst:P33 ?subject ; dreamst:P34 ?object ; dreamst:P18 ?quote ; dreamst:P20 ?report . OPTIONAL { ?effect dreamst:P19 ?project_phase . } OPTIONAL { ?effect dreamst:P16 ?project_type . } SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". } }
Reports
PREFIX dreams: <https://dreams.wikibase.cloud/entity/> PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/> PREFIX dreamsp: <https://dreams.wikibase.cloud/prop/> PREFIX dreamspsv: <https://dreams.wikibase.cloud/prop/statement/value/> SELECT ?number_of_patterns ?report ?reportLabel (CONCAT("#report/", SUBSTR(STR(?report), 38)) AS ?reportUrl) WITH { SELECT (COUNT(?pattern) AS ?number_of_patterns) ?report WHERE { ?pattern dreamst:P2 dreams:Q263 ; dreamst:P20 ?report . } GROUP BY ?report } AS %result WHERE { INCLUDE %result SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". } } ORDER BY DESC(?number_of_patterns)