query-8fb6dcf3d306828dd977565163a27e84
Consortia
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?w ?wLabel ?wAltLabel ?wDescription ?speakerLabel ?applicantLabel (SAMPLE(?website) AS ?website) ?email ?phone (SAMPLE(?twitter) AS ?twitter) (SAMPLE(?facebook) AS ?facebook) ?zenodoid (SAMPLE(?inception) AS ?inception)
WHERE
{
?w wdt:P31 wd:Q98270496 .
OPTIONAL {
?w p:P1416 ?statement .
?statement ps:P1416 ?applicant .
?statement pq:P3831 wd:Q54875338 .
}
OPTIONAL {?w wdt:P10301 ?lobbyregister }
OPTIONAL {?w wdt:P856 ?website .}
OPTIONAL {?w wdt:P2002 ?twitter .}
OPTIONAL {?w wdt:P2769 ?budget .}
OPTIONAL {?w wdt:P6782 ?rorid .}
OPTIONAL {?w wdt:P9934 ?zenodoid }
OPTIONAL {?w wdt:P2013 ?facebook }
OPTIONAL {?w wdt:P1329 ?phone }
OPTIONAL {?w wdt:P968 ?email}
OPTIONAL {?w wdt:P571 ?inception }
OPTIONAL {?w wdt:P1128 ?beschaeftigte }
OPTIONAL {?w wdt:P488 ?speaker }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de" . }
} GROUP BY ?w ?wLabel ?wAltLabel ?wDescription ?phone ?zenodoid ?email ?speakerLabel ?applicantLabel
ORDER BY ASC(?wLabel)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?applicant")
v15("?beschaeftigte")
v8("?budget")
v13("?email"):::projected
v17("?facebook"):::projected
v17("?inception"):::projected
v5("?lobbyregister")
v12("?phone"):::projected
v9("?rorid")
v16("?speaker")
v3("?statement")
v17("?twitter"):::projected
v2("?w"):::projected
v1("?wLabel"):::projected
v17("?website"):::projected
v10("?zenodoid"):::projected
c6(["wd:Q54875338"]):::iri
c20(["bd:serviceParam"]):::iri
c22(["#91;AUTO_LANGUAGE#93;,en,de"]):::literal
c2(["wd:Q98270496"]):::iri
v2 --"p:direct/P31"--> c2
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:P1416".-> v3
v3 --"p:statement/P1416"--> v4
v3 --"p:qualifier/P3831"--> c6
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:direct/P10301".-> v5
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:direct/P856".-> v17
end
subgraph optional3["(optional)"]
style optional3 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:direct/P2002".-> v17
end
subgraph optional4["(optional)"]
style optional4 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:direct/P2769".-> v8
end
subgraph optional5["(optional)"]
style optional5 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:direct/P6782".-> v9
end
subgraph optional6["(optional)"]
style optional6 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:direct/P9934".-> v10
end
subgraph optional7["(optional)"]
style optional7 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:direct/P2013".-> v17
end
subgraph optional8["(optional)"]
style optional8 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:direct/P1329".-> v12
end
subgraph optional9["(optional)"]
style optional9 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:direct/P968".-> v13
end
subgraph optional10["(optional)"]
style optional10 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:direct/P571".-> v17
end
subgraph optional11["(optional)"]
style optional11 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:direct/P1128".-> v15
end
subgraph optional12["(optional)"]
style optional12 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:direct/P488".-> v16
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c20 --"wikibase:language"--> c22
end
bind4[/"sample(?website)"/]
v17 --o bind4
bind4 --as--o v17
bind5[/"sample(?twitter)"/]
v17 --o bind5
bind5 --as--o v17
bind6[/"sample(?facebook)"/]
v17 --o bind6
bind6 --as--o v17
bind7[/"sample(?inception)"/]
v17 --o bind7
bind7 --as--o v17