query-1af654f7649850976cba1f8ed8a22516

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel ?itemDescription  ?article WHERE 
{
  ?item wdt:P27 wd:Q298.
  ?item wdt:P31 wd:Q5.
  ?article schema:about ?item.
  ?article schema:isPartOf <https://en.wikipedia.org/>. # there is an en wiki article
  FILTER NOT EXISTS                            # exclude items if
  {
    ?article1 schema:about ?item.              # there may be another article
    ?article1 schema:inLanguage ?lang .        # in a language
    filter not exists {wd:Q328 wdt:P424 ?lang} # which language (long story short) is not "en"
    ?article1 schema:isPartOf ?thing.          # which article is part of something
    ?thing wikibase:wikiGroup "wikipedia" .    # and that thing is a language wiki
  }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "es,en". }
} limit 10

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?article"):::projected v2("?article1") v3("?item"):::projected v1("?lang") v4("?thing") c16(["es,en"]):::literal c12([https://en.wikipedia.org/]):::iri c14(["bd:serviceParam"]):::iri c1(["wd:Q328"]):::iri c11(["wd:Q5"]):::iri c7(["wikipedia"]):::literal c9(["wd:Q298"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0f0[["not "]] subgraph e0f0e0e0["Exists Clause"] e0e0c1 --"wdt:P424"--> e0e0v1 e0e0v1("?lang"):::projected e0e0c1(["wd:Q328"]):::iri end e0f0--EXISTS--> e0f0e0e0 e0f0 --> e0c1 e0f0 --> e0c2 e0f0 --> e0v1 e0c1 --"wdt:P424"--> e0v1 e0v2 --"schema:about"--> e0v3 e0v2 --"schema:inLanguage"--> e0v1 e0v2 --"schema:isPartOf"--> e0v4 e0v4 --"wikibase:wikiGroup"--> e0c7 e0v2("?article1"):::projected e0v3("?item"):::projected e0v1("?lang"):::projected e0v4("?thing"):::projected e0c1(["wd:Q328"]):::iri e0c7(["wikipedia"]):::literal end f0--EXISTS--> f0e0 f0 --> c1 f0 --> c2 f0 --> v1 f0 --> v2 f0 --> c3 f0 --> v3 f0 --> c4 f0 --> c5 f0 --> v4 f0 --> c6 f0 --> c7 f1[["not "]] subgraph f1e1["Exists Clause"] e1c1 --"wdt:P424"--> e1v1 e1v1("?lang"):::projected e1c1(["wd:Q328"]):::iri end f1--EXISTS--> f1e1 f1 --> c1 f1 --> c2 f1 --> v1 c1 --"wdt:P424"--> v1 v2 --"schema:about"--> v3 v2 --"schema:inLanguage"--> v1 v2 --"schema:isPartOf"--> v4 v4 --"wikibase:wikiGroup"--> c7 v3 --"wdt:P27"--> c9 v3 --"wdt:P31"--> c11 v5 --"schema:about"--> v3 v5 --"schema:isPartOf"--> c12 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c14 --"wikibase:language"--> c16 end