query-692b27a4a34c85b34906cc813d5660b1
help ]reply[17:44, 14 April 2022 (UTC)) talk (Prodrummer619Creating query for lebanese politicians who have missing articles in english. Im struggling to list out the images of them
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
SELECT ?item (COUNT(distinct ?sitelink) as ?count) WHERE { ?item wdt:P106 wd:Q82955 . ?item wdt:P27 wd:Q822 . ?sitelink schema:about ?item . FILTER NOT EXISTS { ?wen schema:about ?item . ?wen schema:inLanguage "en" } }GROUP BY ?item ORDER BY DESC(?count)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?count")
v3("?item"):::projected
v4("?sitelink"):::projected
v2("?wen")
c7(["wd:Q822"]):::iri
c3(["en"]):::literal
c5(["wd:Q82955"]):::iri
f0[["not "]]
subgraph f0e0["Exists Clause"]
e0v1 --"schema:about"--> e0v2
e0v1 --"schema:inLanguage"--> e0c3
e0v2("?item"):::projected
e0v1("?wen"):::projected
e0c3(["en"]):::literal
end
f0--EXISTS--> f0e0
f0 --> v2
f0 --> c1
f0 --> v3
f0 --> c2
f0 --> c3
v2 --"schema:about"--> v3
v2 --"schema:inLanguage"--> c3
v3 --"wdt:P106"--> c5
v3 --"wdt:P27"--> c7
v4 --"schema:about"--> v3
bind2[/"count(?sitelink)"/]
v4 --o bind2
bind2 --as--o v5