query-4bc0628f7c6baa42723d45097b1bce8b

rq turtle/ttl

Synia: Organization - organization

Use at

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

SELECT 
  ?description 
  ?value ?valueLabel ?valueUrl

  ?wikidata ?wikidataUrl

  ?scholia ?scholiaUrl
WHERE {
  {
    BIND(1 AS ?order)
    BIND("First organization" AS ?description)
    BIND(target1: AS ?value)
    BIND(CONCAT("#organization/", SUBSTR(STR(target1:), 32)) AS ?valueUrl)
    BIND("Wikidata&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/organization/", SUBSTR(STR(?value), 32)) AS ?scholiaUrl)
  }
  UNION
  {
    BIND(2 AS ?order)
    BIND("Second organization" AS ?description)
    BIND(target2: AS ?value)
    BIND(CONCAT("#organization/", SUBSTR(STR(target2:), 32)) AS ?valueUrl)
    BIND("Wikidata&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/organization/", SUBSTR(STR(?value), 32)) AS ?scholiaUrl)
  }
  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; v9("?description"):::projected v9("?order") v9("?scholia"):::projected v9("?scholiaUrl"):::projected v9("?value"):::projected v9("?valueUrl"):::projected v9("?wikidata"):::projected v9("?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 v9 bind1[/"'Second organization'"/] bind1 --as--o v9 bind2[/"http://www.wikidata.org/entity/Q193196"/] bind2 --as--o v9 bind3[/"concat('#organization/',substring(str(http://www.wikidata.org/entity/Q193196),'32^^xsd:integer'))"/] bind3 --as--o v9 bind4[/"'Wikidata&nbsp;↗'"/] bind4 --as--o v9 bind5[/"concat('https://www.wikidata.org/wiki/',substring(str(?value),'32^^xsd:integer'))"/] v9 --o bind5 bind5 --as--o v9 bind6[/"'Scholia&nbsp;↗'"/] bind6 --as--o v9 bind7[/"concat('https://scholia.toolforge.org/organization/',substring(str(?value),'32^^xsd:integer'))"/] v9 --o bind7 bind7 --as--o v9 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; bind8[/"'1^^xsd:integer'"/] bind8 --as--o v9 bind9[/"'First organization'"/] bind9 --as--o v9 bind10[/"http://www.wikidata.org/entity/Q1269766"/] bind10 --as--o v9 bind11[/"concat('#organization/',substring(str(http://www.wikidata.org/entity/Q1269766),'32^^xsd:integer'))"/] bind11 --as--o v9 bind12[/"'Wikidata&nbsp;↗'"/] bind12 --as--o v9 bind13[/"concat('https://www.wikidata.org/wiki/',substring(str(?value),'32^^xsd:integer'))"/] v9 --o bind13 bind13 --as--o v9 bind14[/"'Scholia&nbsp;↗'"/] bind14 --as--o v9 bind15[/"concat('https://scholia.toolforge.org/organization/',substring(str(?value),'32^^xsd:integer'))"/] v9 --o bind15 bind15 --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