query-87e183a755db86ffa82b8af888b2ac64
Organizations
Use at
- https://query.wikidata.org/sparql
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