query-25ca970851ad5bce75c7c090bbd55692
Coeditors
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/Q18618629>
SELECT
?works
?coeditor ?coeditorLabel
(CONCAT("#editor/", SUBSTR(STR(?coeditor), 32)) AS ?coeditorUrl)
?coeditorDescription
?example_work ?example_workLabel
WHERE {
{
SELECT
(COUNT(?work) AS ?works)
?coeditor
(SAMPLE(?work) AS ?example_work)
WHERE {
?work wdt:P98 target: , ?coeditor .
FILTER (target: != ?coeditor)
}
GROUP BY ?coeditor
} SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?works)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?coeditor"):::projected
v5("?coeditorUrl")
v4("?example_work"):::projected
v3("?work")
v4("?works"):::projected
c4(["bd:serviceParam"]):::iri
c1([http://www.wikidata.org/entity/Q18618629]):::iri
c6(["#91;AUTO_LANGUAGE#93;,en"]):::literal
f0[["http://www.wikidata.org/entity/Q18618629 != ?coeditor"]]
f0 --> v2
v3 --"wdt:P98"--> c1
v3 --"wdt:P98"--> v2
bind3[/"count(?work)"/]
v3 --o bind3
bind3 --as--o v4
bind4[/"sample(?work)"/]
v3 --o bind4
bind4 --as--o v4
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c4 --"wikibase:language"--> c6
end
bind5[/"concat('#editor/',substring(str(?coeditor),'32^^xsd:integer'))"/]
v2 --o bind5
bind5 --as--o v5