query-3bda713646c1324bd6a6fbb46ffe8dc7
count of haitian articles with no interwiki links and with no statements SELECT DISTINCT (COUNT(?item) AS ?count) WHERE { ?item wikibase:statements ?statement_count . ?item wikibase:sitelinks ?sitelink_count . ?sitelink schema:about ?item ; schema:inLanguage "ht" . FILTER (?sitelink_count = 1) FILTER (?statement_count = 0) }
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX schema: <http://schema.org/>
# count of haitian articles with no interwiki links and with no statements
SELECT DISTINCT (COUNT(?item) AS ?count) WHERE {
?item wikibase:statements ?statement_count .
?item wikibase:sitelinks ?sitelink_count .
?sitelink schema:about ?item ;
schema:inLanguage "ht" .
FILTER (?sitelink_count = 1)
FILTER (?statement_count = 0)
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?count")
v3("?item"):::projected
v4("?sitelink")
v2("?sitelink_count")
v1("?statement_count")
c7(["ht"]):::literal
f0[["?statement_count = '0^^xsd:integer'"]]
f0 --> v1
f1[["?sitelink_count = '1^^xsd:integer'"]]
f1 --> v2
v3 --"wikibase:statements"--> v1
v3 --"wikibase:sitelinks"--> v2
v4 --"schema:about"--> v3
v4 --"schema:inLanguage"--> c7
bind3[/"count(?item)"/]
v3 --o bind3
bind3 --as--o v5