query-e9a984fa138f846975338612755630c0

rq turtle/ttl

Biographies for the Asian Month, which are biographies of people from any Asian country lacking an article in a given language in Wikipedia. Asian Month, "Women born in Suriname who are lacking an article in English Wikipedia", I was thinking about listing the biographies that would qualify for the 10 cool queries for Wikidata that will blow your mind. Number 7 will shock you.In a similar way to the 10th example listed in the article 06:05, 2 November 2016 (UTC)) talk (SabbutIn some cases, there is an additional country restriction. For instance, in the Spanish language Wikipedia, this would translate to "People born in Asia, excluding the Philippines, lacking an article in the Spanish language Wikipedia". Note that in the case of transcontinental countries only the Asian part counts, for example, the European part of Russia wouldn't qualify, but the Asian part would. 14:19, 2 November 2016 (UTC) Jura--- has a selection based on continent and nationality. Wikidata:Bistro/Archive/2016/01#Spqarql_et_WikiLovesWomen.3F Good to hear you liked my Welsh query ;) Reminds I should fix it.Thanks, Jura! By modifying a few things, I came up with this:

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX schema: <http://schema.org/>

SELECT DISTINCT ?count ?pers ?persLabel ?desc ?paysLabel WHERE {
  {
    SELECT ?pers ?pays (COUNT(DISTINCT ?art) AS ?count) WHERE {
      ?pers wdt:P31 wd:Q5.
      ?pers wdt:P27 ?pays.
      ?pers wdt:P106 wd:Q82955.
      ?pays wdt:P30 wd:Q48.
      OPTIONAL {
        ?persfrwart schema:about ?pers.
        ?persfrwart schema:inLanguage "es".
      }
      ?art schema:about ?pers.
      FILTER(NOT EXISTS {
        ?pays wdt:P30 ?continent.
        FILTER(?continent != wd:Q48)
      })
      FILTER(!BOUND(?persfrwart))
    }
    GROUP BY ?pers ?pays
  }
  OPTIONAL {
    ?pers schema:description ?desc.
    FILTER((LANG(?desc)) = "es")
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "es,en". }
}
ORDER BY DESC(?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v7("?art") v4("?continent") v8("?count"):::projected v2("?desc"):::projected v5("?pays") v6("?pers"):::projected v3("?persfrwart") c15(["es,en"]):::literal c8(["wd:Q82955"]):::iri c1(["es"]):::literal c2(["wd:Q48"]):::iri c13(["bd:serviceParam"]):::iri c5(["wd:Q5"]):::iri f0[["not bound(?persfrwart)"]] f0 --> v3 f1[["not "]] subgraph f1e0["Exists Clause"] e0f0[["?continent != 'wd:Q48'"]] e0f0 --> e0v1 e0v2 --"wdt:P30"--> e0v1 e0v1("?continent"):::projected e0v2("?pays"):::projected end f1--EXISTS--> f1e0 f1 --> v4 f1 --> v5 f1 --> c3 f2[["?continent != 'wd:Q48'"]] f2 --> v4 v5 --"wdt:P30"--> v4 v6 --"wdt:P31"--> c5 v6 --"wdt:P27"--> v5 v6 --"wdt:P106"--> c8 v5 --"wdt:P30"--> c2 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."schema:about".-> v6 v3 --"schema:inLanguage"--> c1 end v7 --"schema:about"--> v6 bind4[/"count(?art)"/] v7 --o bind4 bind4 --as--o v8 subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v6 -."schema:description".-> v2 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c13 --"wikibase:language"--> c15 end