query-40d159f933366d7eb626724d1c47cdda
Researchers on Mastodon SELECT ?item ?itemLabel (GROUP_CONCAT(?fieldLabel; SEPARATOR = "; ") AS ?fields) ?orcid ?twitter ?mastodon WHERE { SELECT ?item ?itemLabel ?fieldLabel ?orcid ?twitter ?mastodon WHERE { ?item wdt:P496 ?orcid. OPTIONAL { ?item wdt:P2002 ?twitter.} OPTIONAL { ?item wdt:P106 ?field .} ?item wdt:P4033 ?mastodon . SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } LIMIT 20000 } GROUP BY ?item ?itemLabel ?orcid ?twitter ?mastodon
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#>
# Researchers on Mastodon
SELECT ?item ?itemLabel (GROUP_CONCAT(?fieldLabel; SEPARATOR = "; ") AS ?fields) ?orcid ?twitter ?mastodon WHERE {
SELECT ?item ?itemLabel ?fieldLabel ?orcid ?twitter ?mastodon
WHERE
{
?item wdt:P496 ?orcid.
OPTIONAL { ?item wdt:P2002 ?twitter.}
OPTIONAL { ?item wdt:P106 ?field .}
?item wdt:P4033 ?mastodon .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
LIMIT 20000
}
GROUP BY ?item ?itemLabel ?orcid ?twitter ?mastodon
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?field")
v6("?fieldLabel"):::projected
v7("?fields")
v1("?item"):::projected
v5("?mastodon"):::projected
v2("?orcid"):::projected
v3("?twitter"):::projected
c6(["bd:serviceParam"]):::iri
c8(["en"]):::literal
v1 --"wdt:P496"--> v2
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P2002".-> v3
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v1 -."wdt:P106".-> v4
end
v1 --"wdt:P4033"--> v5
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c6 --"wikibase:language"--> c8
end
bind1[/"?fieldLabel"/]
v6 --o bind1
bind1 --as--o v7