query-87e183a755db86ffa82b8af888b2ac64

rq turtle/ttl

Organizations

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX target: <http://www.wikidata.org/entity/Q17012957>

SELECT
  ?persons
  (CONCAT("scientificeventseries/", SUBSTR(STR(target:), 32), "/organization/", SUBSTR(STR(?organization), 32)) AS ?personsUrl)

  ?organization ?organizationLabel ?organizationDescription
  (CONCAT("#organization/", SUBSTR(STR(?organization), 32)) AS ?organizationUrl)

  ?example_person ?example_personLabel
  (CONCAT("#author/", SUBSTR(STR(?example_person), 32)) AS ?example_personUrl)
WHERE {
       {
  SELECT
    (COUNT(DISTINCT ?person) AS ?persons)
    ?organization
    (SAMPLE(?person) AS ?example_person)
  WHERE {
    {
      # speaker
      target: ^wdt:P179 / wdt:P823 ?person .

    }
    UNION
    {
      # organizer
      target: ^wdt:P179 / wdt:P664 ?person .

    }
    UNION
    {
      # participant
      ?person (wdt:P1344| ^wdt:P710) / wdt:P179 target: .

    }
    UNION
    {
      # editor
      ?person (^wdt:P98 / wdt:P4745) / wdt:P179 target: .

    }
    UNION
    {
      # author
      ?person (^wdt:P50 / wdt:P1433 / wdt:P4745) / wdt:P179 target: .

    }
    UNION
    {
      # program committee member
      target: ^wdt:P179 / wdt:P5804 ?person .
    }

    ?person wdt:P1416 | wdt:P108 ?organization .
  }

  GROUP BY ?organization
}.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,da,de,es,fr,jp,no,ru,sv,zh". }
}
ORDER BY DESC(?persons)
LIMIT 500

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?example_person"):::projected v7("?example_personUrl") v3("?organization"):::projected v6("?organizationUrl") v2("?person") v4("?persons"):::projected v5("?personsUrl") a1((" ")) a2((" ")) a3((" ")) a5((" ")) a4((" ")) a8((" ")) a6((" ")) a7((" ")) a9((" ")) c17(["#91;AUTO_LANGUAGE#93;,en,da,de,es,fr,jp,no,ru,sv,zh"]):::literal c15(["bd:serviceParam"]):::iri c2([http://www.wikidata.org/entity/Q17012957]):::iri subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; subgraph union1[" Union "] subgraph union1l[" "] style union1l fill:#abf,stroke-dasharray: 3 3; subgraph union2[" Union "] subgraph union2l[" "] style union2l fill:#abf,stroke-dasharray: 3 3; subgraph union3[" Union "] subgraph union3l[" "] style union3l fill:#abf,stroke-dasharray: 3 3; subgraph union4[" Union "] subgraph union4l[" "] style union4l fill:#abf,stroke-dasharray: 3 3; a9 --"wdt:P179"--> c2 a9 --"wdt:P5804"--> v2 end subgraph union4r[" "] style union4r fill:#abf,stroke-dasharray: 3 3; a6 --"wdt:P50"--> v2 a6 --"wdt:P1433"--> a7 a7 --"wdt:P4745"--> a8 a8 --"wdt:P179"--> c2 end union4r <== or ==> union4l end end subgraph union3r[" "] style union3r fill:#abf,stroke-dasharray: 3 3; a4 --"wdt:P98"--> v2 a4 --"wdt:P4745"--> a5 a5 --"wdt:P179"--> c2 end union3r <== or ==> union3l end end subgraph union2r[" "] style union2r fill:#abf,stroke-dasharray: 3 3; subgraph union5[" Union "] subgraph union5l[" "] style union5l fill:#abf,stroke-dasharray: 3 3; a3 --"wdt:P710"--> v2 end subgraph union5r[" "] style union5r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P1344"--> a3 end union5r <== or ==> union5l end a3 --"wdt:P179"--> c2 end union2r <== or ==> union2l end end subgraph union1r[" "] style union1r fill:#abf,stroke-dasharray: 3 3; a2 --"wdt:P179"--> c2 a2 --"wdt:P664"--> v2 end union1r <== or ==> union1l end end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; a1 --"wdt:P179"--> c2 a1 --"wdt:P823"--> v2 end union0r <== or ==> union0l end subgraph union6[" Union "] subgraph union6l[" "] style union6l fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P108"--> v3 end subgraph union6r[" "] style union6r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P1416"--> v3 end union6r <== or ==> union6l end bind2[/"count(?person)"/] v2 --o bind2 bind2 --as--o v4 bind3[/"sample(?person)"/] v2 --o bind3 bind3 --as--o v4 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c15 --"wikibase:language"--> c17 end bind4[/"concat('scientificeventseries/',substring(str(http://www.wikidata.org/entity/Q17012957),'32^^xsd:integer'),'/organization/',substring(str(?organization),'32^^xsd:integer'))"/] v3 --o bind4 bind4 --as--o v5 bind5[/"concat('#organization/',substring(str(?organization),'32^^xsd:integer'))"/] v3 --o bind5 bind5 --as--o v6 bind6[/"concat('#author/',substring(str(?example_person),'32^^xsd:integer'))"/] v4 --o bind6 bind6 --as--o v7