query-b8b6fd120a08b0d765eb06086655443b
most common domains for “full work available at” URLs SELECT ?domain (COUNT(?work) AS ?count) WHERE { ?work wdt:P953 ?url. BIND(REPLACE(STR(?url), "^.?://([^/]).*", "$1") AS ?domain) } GROUP BY ?domain ORDER BY DESC(?count)
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
# most common domains for “full work available at” URLs
SELECT ?domain (COUNT(?work) AS ?count) WHERE {
?work wdt:P953 ?url.
BIND(REPLACE(STR(?url), "^.*?://([^/]*).*", "$1") AS ?domain)
}
GROUP BY ?domain
ORDER BY DESC(?count)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?count")
v4("?domain"):::projected
v3("?url")
v2("?work"):::projected
v2 --"wdt:P953"--> v3
bind0[/"replace(str(?url),'^.*?://(#91;^/#93;*).*','$1')"/]
v3 --o bind0
bind0 --as--o v4
bind2[/"count(?work)"/]
v2 --o bind2
bind2 --as--o v5