Dreams:pattern: Difference between revisions
Jump to navigation
Jump to search
(→Pattern data: DISTINCT) |
No edit summary |
||
Line 18: | Line 18: | ||
UNION | UNION | ||
{ | { | ||
BIND( | BIND(1 AS ?order) | ||
BIND("Object ( | BIND("Subject (text)" AS ?description) | ||
?pattern dreamst:P47 ?value . | |||
} | |||
UNION | |||
{ | |||
BIND(4 AS ?order) | |||
BIND("Object (class)" AS ?description) | |||
?pattern dreamst:P34 ?value . | ?pattern dreamst:P34 ?value . | ||
BIND(CONCAT("#effect/", SUBSTR(STR(?value), 38)) AS ?valueUrl) | BIND(CONCAT("#effect/", SUBSTR(STR(?value), 38)) AS ?valueUrl) | ||
Line 25: | Line 31: | ||
UNION | UNION | ||
{ | { | ||
BIND( | BIND(5 AS ?order) | ||
BIND("Object (text)" AS ?description) | |||
?pattern dreamst:P49 ?value . | |||
} | |||
UNION | |||
{ | |||
BIND(10 AS ?order) | |||
BIND("Recipient" AS ?description) | BIND("Recipient" AS ?description) | ||
?pattern dreamst:P34 / dreamst:P9 ?value . | ?pattern dreamst:P34 / dreamst:P9 ?value . | ||
Line 33: | Line 45: | ||
UNION | UNION | ||
{ | { | ||
BIND( | BIND(15 AS ?order) | ||
BIND("Quote" AS ?description) | BIND("Quote" AS ?description) | ||
?pattern dreamst:P18 ?value . | ?pattern dreamst:P18 ?value . | ||
Line 39: | Line 51: | ||
UNION | UNION | ||
{ | { | ||
BIND( | BIND(20 AS ?order) | ||
BIND("Report" AS ?description) | BIND("Report" AS ?description) | ||
?pattern dreamst:P20 ?value . | ?pattern dreamst:P20 ?value . | ||
Line 46: | Line 58: | ||
UNION | UNION | ||
{ | { | ||
BIND( | BIND(25 AS ?order) | ||
BIND("Project type" AS ?description) | BIND("Project type" AS ?description) | ||
{ ?pattern dreamst:P16 ?value_from_pattern . } | { ?pattern dreamst:P16 ?value_from_pattern . } | ||
Line 56: | Line 68: | ||
UNION | UNION | ||
{ | { | ||
BIND( | BIND(26 AS ?order) | ||
BIND("Project phase" AS ?description) | |||
?pattern dreamst:P19 ?value . | |||
BIND(CONCAT("#projectphase/", SUBSTR(STR(?value), 38)) AS ?valueUrl) | |||
} | |||
UNION | |||
{ | |||
BIND(30 AS ?order) | |||
BIND("Miljøportal" AS ?description) | BIND("Miljøportal" AS ?description) | ||
?pattern dreamst:P20 / dreamst:P40 ?value_ . | ?pattern dreamst:P20 / dreamst:P40 ?value_ . |
Revision as of 16:13, 19 October 2022
Pattern data
PREFIX target: <https://dreams.wikibase.cloud/entity/Q260> PREFIX dreams: <https://dreams.wikibase.cloud/entity/> PREFIX dreamst: <https://dreams.wikibase.cloud/prop/direct/> SELECT DISTINCT ?description ?value ?valueLabel ?valueUrl WHERE { BIND(target: AS ?pattern) { BIND(1 AS ?order) BIND("Subject (effector)" AS ?description) ?pattern dreamst:P33 ?value . BIND(CONCAT("#effect/", SUBSTR(STR(?value), 38)) AS ?valueUrl) } UNION { BIND(1 AS ?order) BIND("Subject (text)" AS ?description) ?pattern dreamst:P47 ?value . } UNION { BIND(4 AS ?order) BIND("Object (class)" AS ?description) ?pattern dreamst:P34 ?value . BIND(CONCAT("#effect/", SUBSTR(STR(?value), 38)) AS ?valueUrl) } UNION { BIND(5 AS ?order) BIND("Object (text)" AS ?description) ?pattern dreamst:P49 ?value . } UNION { BIND(10 AS ?order) BIND("Recipient" AS ?description) ?pattern dreamst:P34 / dreamst:P9 ?value . ?value dreamst:P10+ dreams:Q50 . BIND(CONCAT("#effect/", SUBSTR(STR(?value), 38)) AS ?valueUrl) } UNION { BIND(15 AS ?order) BIND("Quote" AS ?description) ?pattern dreamst:P18 ?value . } UNION { BIND(20 AS ?order) BIND("Report" AS ?description) ?pattern dreamst:P20 ?value . BIND(CONCAT("#report/", SUBSTR(STR(?value), 38)) AS ?valueUrl) } UNION { BIND(25 AS ?order) BIND("Project type" AS ?description) { ?pattern dreamst:P16 ?value_from_pattern . } UNION { ?pattern dreamst:P20 / dreamst:P16 ?value_from_report . } BIND(COALESCE(?value_from_pattern, ?value_from_report) AS ?value) BIND(CONCAT("#projecttype/", SUBSTR(STR(?value), 38)) AS ?valueUrl) } UNION { BIND(26 AS ?order) BIND("Project phase" AS ?description) ?pattern dreamst:P19 ?value . BIND(CONCAT("#projectphase/", SUBSTR(STR(?value), 38)) AS ?valueUrl) } UNION { BIND(30 AS ?order) BIND("Miljøportal" AS ?description) ?pattern dreamst:P20 / dreamst:P40 ?value_ . OPTIONAL { ?pattern dreamst:P46 ?page } BIND(CONCAT(STR(?value_), IF(BOUND(?page), CONCAT(" (page ", ?page, ") ↗"), " ↗")) AS ?value) BIND(CONCAT("https://daieproddreamspdfsto.blob.core.windows.net/files/", STR(?value_), IF(BOUND(?page), CONCAT("#page=", ?page), "")) AS ?valueUrl) } SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en". } } ORDER BY ?order