query-b9937bb038a022c89434293be9aff230

rq turtle/ttl

OpenMLOL author merges SELECT ?item (GROUP_CONCAT(DISTINCT CONCAT("https://openmlol.it/autore/",?op); separator=", ") AS ?openmlol) (count(?op) AS ?num) (GROUP_CONCAT(DISTINCT CONCAT("https://viaf.org/viaf/",?v); separator=", ") AS ?viaf) (count(?v) AS ?num2) WHERE { ?item wdt:P3762 ?op . OPTIONAL { ?item wdt:P214 ?v . } #?article schema:about ?item . #?article schema:isPartOf https://it.wikipedia.org/ . #SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],it,en". } } GROUP BY ?item HAVING(?num > 3) ORDER BY DESC(?num2)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#OpenMLOL author merges
SELECT ?item (GROUP_CONCAT(DISTINCT CONCAT("https://openmlol.it/autore/",?op); separator=", ") AS ?openmlol) (count(?op) AS ?num)
       (GROUP_CONCAT(DISTINCT CONCAT("https://viaf.org/viaf/",?v); separator=", ") AS ?viaf) (count(?v) AS ?num2)
WHERE {
  ?item wdt:P3762 ?op . 
  OPTIONAL { ?item wdt:P214 ?v . }
  #?article schema:about ?item .
  #?article schema:isPartOf <https://it.wikipedia.org/> .
  #SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],it,en". }
  } 
GROUP BY ?item
HAVING(?num > 3)
ORDER BY DESC(?num2)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?item"):::projected v7("?num") v8("?num2") v4("?op"):::projected v6("?openmlol") v5("?v"):::projected v7("?viaf") f0[["?num > '3^^xsd:integer'"]] f0 --> v7 v3 --"wdt:P3762"--> v4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P214".-> v5 end bind5[/"concat('https://openmlol.it/autore/',?op)"/] v4 --o bind5 bind5 --as--o v6 bind6[/"count(?op)"/] v4 --o bind6 bind6 --as--o v7 bind7[/"concat('https://viaf.org/viaf/',?v)"/] v5 --o bind7 bind7 --as--o v7 bind8[/"count(?v)"/] v5 --o bind8 bind8 --as--o v8