query-d3811470b5b6f86b4328ce39b7b09e04

rq turtle/ttl

Synia: Scientific event series - organizational role

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX target1: <http://www.wikidata.org/entity/Q6053150>
PREFIX target2: <http://www.wikidata.org/entity/Q125207931>

SELECT 
  ?description ?descriptionLabel ?descriptionUrl

  ?value ?valueLabel ?valueUrl

  ?wikidata ?wikidataUrl

  ?scholia ?scholiaUrl

WHERE {
  {
    BIND(1 AS ?order)
    BIND(wd:Q125391566 AS ?description)
    BIND("#scientificeventseries/" AS ?descriptionUrl)

    BIND(target1: AS ?value)
    BIND(CONCAT("#scientificeventseries/", SUBSTR(STR(?value), 32)) AS ?valueUrl)

    BIND(CONCAT(SUBSTR(STR(?value), 32), "&nbsp;↗") AS ?wikidata)
    BIND(CONCAT("https://www.wikidata.org/wiki/", SUBSTR(STR(?value), 32)) AS ?wikidataUrl)

    BIND("Scholia&nbsp;↗" AS ?scholia)
    BIND(CONCAT("https://scholia.toolforge.org/event-series/", SUBSTR(STR(?value), 32)) AS ?scholiaUrl)
  }
  UNION
  {
    BIND(2 AS ?order)
    BIND("organization role" AS ?description) 
    BIND(target2: AS ?value)
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?order

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v10("?description"):::projected v3("?descriptionUrl"):::projected v10("?order") v8("?scholia"):::projected v9("?scholiaUrl"):::projected v10("?value"):::projected v5("?valueUrl"):::projected v6("?wikidata"):::projected v7("?wikidataUrl"):::projected c2(["bd:serviceParam"]):::iri c4(["#91;AUTO_LANGUAGE#93;,en"]):::literal subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; bind0[/"'2^^xsd:integer'"/] bind0 --as--o v10 bind1[/"'organization role'"/] bind1 --as--o v10 bind2[/"'wd:Q125207931'"/] bind2 --as--o v10 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; bind3[/"'1^^xsd:integer'"/] bind3 --as--o v10 bind4[/"'wd:Q125391566'"/] bind4 --as--o v10 bind5[/"'#scientificeventseries/'"/] bind5 --as--o v3 bind6[/"'wd:Q6053150'"/] bind6 --as--o v10 bind7[/"concat('#scientificeventseries/',substring(str(?value),'32^^xsd:integer'))"/] v10 --o bind7 bind7 --as--o v5 bind8[/"concat(substring(str(?value),'32^^xsd:integer'),'&nbsp;↗')"/] v10 --o bind8 bind8 --as--o v6 bind9[/"concat('https://www.wikidata.org/wiki/',substring(str(?value),'32^^xsd:integer'))"/] v10 --o bind9 bind9 --as--o v7 bind10[/"'Scholia&nbsp;↗'"/] bind10 --as--o v8 bind11[/"concat('https://scholia.toolforge.org/event-series/',substring(str(?value),'32^^xsd:integer'))"/] v10 --o bind11 bind11 --as--o v9 end union0r <== or ==> union0l end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c2 --"wikibase:language"--> c4 end