query-9cb3cac4e3abbfbbaa546f76f8740766

rq turtle/ttl

Cis and trans women and non binary people who are artists born in Latin America and the Caribbean and have no article in Spanish Wikipedia. By User:Pablísima SELECT ?item ?itemLabel ?genderLabel ?countryLabel ?occupationLabel WITH { SELECT ?country WHERE { wd:Q72829598 wdt:P527+ ?country . } } AS %get_countries WITH { SELECT DISTINCT ?item ?gender ?country ?occupation WHERE { ?item wdt:P31 wd:Q5 . VALUES ?gender { wd:Q6581072 wd:Q1052281 wd:Q48270 } ?item wdt:P21 ?gender . INCLUDE %get_countries ?item wdt:P27 ?country . ?item wdt:P106 ?occupation . { ?occupation wdt:P279* wd:Q3391743 . hint:Prior hint:gearing "forward" . } FILTER NOT EXISTS { [] schema:about ?item ; schema:isPartOf https://es.wikipedia.org/ . } } } AS %main WHERE { INCLUDE %main SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],es,pt,fr,en" . } } ORDER BY ?countryLabel ?occupationLabel

Use at

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#>
# Cis and trans women and non binary people who are artists born in Latin America and the Caribbean and have no article in Spanish Wikipedia. By User:Pablísima
SELECT ?item ?itemLabel ?genderLabel ?countryLabel ?occupationLabel
WHERE
{

{
  SELECT DISTINCT ?item ?gender ?country ?occupation
  WHERE
  {
    ?item wdt:P31 wd:Q5 .
    VALUES ?gender { wd:Q6581072 wd:Q1052281 wd:Q48270 }
    ?item wdt:P21 ?gender .
     { SELECT ?country WHERE { wd:Q72829598 wdt:P527+ ?country . } }    ?item wdt:P27 ?country .
    ?item wdt:P106 ?occupation .
    {
      ?occupation wdt:P279* wd:Q3391743 .

    }
    FILTER NOT EXISTS
    {
      [] schema:about ?item ; schema:isPartOf <https://es.wikipedia.org/> .
    }
  }
}  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],es,pt,fr,en" . }
}
ORDER BY ?countryLabel ?occupationLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?country") v1("?countryLabel"):::projected v4("?gender") v3("?item"):::projected v6("?occupation") v2("?occupationLabel"):::projected a1((" ")) c16(["#91;AUTO_LANGUAGE#93;,es,pt,fr,en"]):::literal c12(["wd:Q3391743"]):::iri c14(["bd:serviceParam"]):::iri c3([https://es.wikipedia.org/]):::iri c5(["wd:Q5"]):::iri c7(["wd:Q72829598"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0a1 --"schema:about"--> e0v1 e0a1 --"schema:isPartOf"--> e0c3 e0v1("?item"):::projected e0a1((" ")):::projected e0c3([https://es.wikipedia.org/]):::iri end f0--EXISTS--> f0e0 f0 --> a1 f0 --> c1 f0 --> v3 f0 --> c2 f0 --> c3 a1 --"schema:about"--> v3 a1 --"schema:isPartOf"--> c3 v3 --"wdt:P31"--> c5 bind1[/VALUES ?gender/] bind1-->v4 bind10(["wd:Q6581072"]) bind10 --> bind1 bind11(["wd:Q1052281"]) bind11 --> bind1 bind12(["wd:Q48270"]) bind12 --> bind1 v3 --"wdt:P21"--> v4 c7 --"wdt:P527"--> v5 v3 --"wdt:P27"--> v5 v3 --"wdt:P106"--> v6 v6 --"wdt:P279"--> c12 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c14 --"wikibase:language"--> c16 end