query-fd14f7af9f8bd645fa9dcae488db3181
...with additional info
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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?w ?wLabel (SAMPLE(?directorLabel) AS ?directorLabel) (SAMPLE(?website) AS ?website) (SAMPLE(?email) AS ?email) (SAMPLE(?foundingdate) AS ?founded) (SAMPLE(?ror) AS ?ror) (SAMPLE(?logo) AS ?logo) (SAMPLE(?zenodo) AS ?zenodo) (SAMPLE(?linkedin) AS ?linkedin) (SAMPLE(?twitter) AS ?twitter) (SAMPLE(?github) AS ?github) (SAMPLE(?gitlab) AS ?gitlab) (SAMPLE(?mastodon) AS ?mastodon) (SAMPLE(?youtube) AS ?youtube)
WHERE
{
?w wdt:P463 wd:Q105757481 .
OPTIONAL { ?w wdt:P6782 ?ror . }
OPTIONAL { ?w wdt:P968 ?email. }
OPTIONAL { ?w wdt:P856 ?website. }
OPTIONAL { ?w wdt:P9934 ?zenodo. }
OPTIONAL { ?w wdt:P4264 ?linkedin. }
OPTIONAL { ?w wdt:P2002 ?twitter. }
OPTIONAL { ?w wdt:P2037 ?github. }
OPTIONAL { ?w wdt:P8827 ?gitlab. }
OPTIONAL { ?w wdt:P4033 ?mastodon. }
OPTIONAL { ?w wdt:P2397 ?youtube. }
OPTIONAL { ?w wdt:P571 ?foundingdate. }
OPTIONAL { ?w wdt:P1647*/wdt:P1037 ?director . ?director rdfs:label ?directorLabel . }
OPTIONAL { ?w wdt:P154 ?logo . }
SERVICE wikibase:label { bd:serviceParam wikibase:language "de,en" . }
} GROUP BY ?w ?wLabel ORDER BY ASC(?wLabel)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v14("?director")
v17("?directorLabel"):::projected
v17("?email"):::projected
v17("?founded")
v13("?foundingdate"):::projected
v18("?github"):::projected
v18("?gitlab"):::projected
v18("?linkedin"):::projected
v18("?logo"):::projected
v18("?mastodon"):::projected
v18("?ror"):::projected
v18("?twitter"):::projected
v2("?w"):::projected
v1("?wLabel"):::projected
v17("?website"):::projected
v18("?youtube"):::projected
v18("?zenodo"):::projected
a1((" "))
c2(["wd:Q105757481"]):::iri
c19(["bd:serviceParam"]):::iri
c21(["de,en"]):::literal
v2 --"wdt:P463"--> c2
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P6782".-> v18
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P968".-> v17
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P856".-> v17
end
subgraph optional3["(optional)"]
style optional3 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P9934".-> v18
end
subgraph optional4["(optional)"]
style optional4 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P4264".-> v18
end
subgraph optional5["(optional)"]
style optional5 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P2002".-> v18
end
subgraph optional6["(optional)"]
style optional6 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P2037".-> v18
end
subgraph optional7["(optional)"]
style optional7 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P8827".-> v18
end
subgraph optional8["(optional)"]
style optional8 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P4033".-> v18
end
subgraph optional9["(optional)"]
style optional9 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P2397".-> v18
end
subgraph optional10["(optional)"]
style optional10 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P571".-> v13
end
subgraph optional11["(optional)"]
style optional11 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P1647".-> a1
a1 --"wdt:P1037"--> v14
v14 --"rdfs:label"--> v17
end
subgraph optional12["(optional)"]
style optional12 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wdt:P154".-> v18
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c19 --"wikibase:language"--> c21
end
bind13[/"sample(?directorLabel)"/]
v17 --o bind13
bind13 --as--o v17
bind14[/"sample(?website)"/]
v17 --o bind14
bind14 --as--o v17
bind15[/"sample(?email)"/]
v17 --o bind15
bind15 --as--o v17
bind16[/"sample(?foundingdate)"/]
v13 --o bind16
bind16 --as--o v17
bind17[/"sample(?ror)"/]
v18 --o bind17
bind17 --as--o v18
bind18[/"sample(?logo)"/]
v18 --o bind18
bind18 --as--o v18
bind19[/"sample(?zenodo)"/]
v18 --o bind19
bind19 --as--o v18
bind20[/"sample(?linkedin)"/]
v18 --o bind20
bind20 --as--o v18
bind21[/"sample(?twitter)"/]
v18 --o bind21
bind21 --as--o v18
bind22[/"sample(?github)"/]
v18 --o bind22
bind22 --as--o v18
bind23[/"sample(?gitlab)"/]
v18 --o bind23
bind23 --as--o v18
bind24[/"sample(?mastodon)"/]
v18 --o bind24
bind24 --as--o v18
bind25[/"sample(?youtube)"/]
v18 --o bind25
bind25 --as--o v18