query-618c3fcf9688781532651784ed08a44a
title:Number of incoming links for authors of articles published in Bibliothecae.it SELECT ?linkingitems (COUNT(?linkingitems) AS ?numberofitems) WHERE { { SELECT ?author (COUNT(DISTINCT ?x) AS ?linkingitems) WHERE { ?x ?st ?author . ?p wikibase:directClaim ?st . ?article wdt:P50 ?author ; wdt:P1433 wd:Q50811189 . } GROUP BY ?author } } GROUP BY ?linkingitems ORDER BY DESC(?linkingitems)
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/>
#title:Number of incoming links for authors of articles published in Bibliothecae.it
SELECT ?linkingitems (COUNT(?linkingitems) AS ?numberofitems)
WHERE {
{ SELECT ?author (COUNT(DISTINCT ?x) AS ?linkingitems)
WHERE { ?x ?st ?author . ?p wikibase:directClaim ?st . ?article wdt:P50 ?author ; wdt:P1433 wd:Q50811189 . }
GROUP BY ?author }
}
GROUP BY ?linkingitems
ORDER BY DESC(?linkingitems)
Query found at
- https://www.wikidata.org/wiki/User:Ep%C3%ACdosis/Queries
- https://www.wikidata.org/wiki/User:Ep%C3%ACdosis/sandbox
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v6("?article")
v4("?author")
v7("?linkingitems"):::projected
v7("?numberofitems")
v5("?p")
v3("?st")
v2("?x")
c4(["wd:Q50811189"]):::iri
v2 -->v3--> v4
v5 --"wikibase:directClaim"--> v3
v6 --"wdt:P50"--> v4
v6 --"wdt:P1433"--> c4
bind1[/"count(?x)"/]
v2 --o bind1
bind1 --as--o v7
bind3[/"count(?linkingitems)"/]
v7 --o bind3
bind3 --as--o v7