query-9789ef7b2781d3c0ceebad354334c1ee

rq turtle/ttl

Open Library author merges SELECT ?item (URI(CONCAT("https://openlibrary.org/authors/merge?key=",GROUP_CONCAT(DISTINCT ?op; separator="&key="))) AS ?opurl) (count(?op) AS ?num) WHERE { ?item wdt:P648 ?op . ?item wdt:P31 wd:Q5 . ?article schema:about ?item . ?article schema:isPartOf https://it.wikipedia.org/ . } GROUP BY ?item HAVING(?num > 1) ORDER BY DESC(?opurl)

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
#Open Library author merges
SELECT ?item (URI(CONCAT("https://openlibrary.org/authors/merge?key=",GROUP_CONCAT(DISTINCT ?op; separator="&key="))) AS ?opurl) (count(?op) AS ?num)
WHERE {
  ?item wdt:P648 ?op . 
  ?item wdt:P31 wd:Q5 . 
  ?article schema:about ?item .
  ?article schema:isPartOf <https://it.wikipedia.org/> .
  } 
GROUP BY ?item
HAVING(?num > 1)
ORDER BY DESC(?opurl)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?article") v3("?item"):::projected v6("?num") v4("?op"):::projected v6("?opurl") c4(["wd:Q5"]):::iri c7([https://it.wikipedia.org/]):::iri f0[["?num > '1^^xsd:integer'"]] f0 --> v6 v3 --"wdt:P648"--> v4 v3 --"wdt:P31"--> c4 v5 --"schema:about"--> v3 v5 --"schema:isPartOf"--> c7 bind3[/"concat('https://openlibrary.org/authors/merge?key=',)"/] null --o bind3 bind3 --as--o v6 bind4[/"count(?op)"/] v4 --o bind4 bind4 --as--o v6