query-23a4673359c5ffbf9d3723365d1088df

rq turtle/ttl

Femmes scientifiques canadiennes et françaises sans article en français

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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel (GROUP_CONCAT(DISTINCT ?occupationLabel; SEPARATOR=", ") AS ?occupations) (GROUP_CONCAT(DISTINCT ?countryLabel; SEPARATOR=", ") AS ?countries) {
  VALUES ?target_country { wd:Q16 wd:Q142 } . #countries: Canada, France. Remove this line to get worldwide.
  VALUES ?occupation { wd:Q3621491 wd:Q11063 wd:Q37547 wd:Q4773904 wd:Q3378595 wd:Q15634281 wd:Q350979 wd:Q2306091 
                       wd:Q2310145 wd:Q19350898 wd:Q3644587 wd:Q82594 wd:Q4459623 wd:Q864503 wd:Q169470 wd:Q81096 
                       wd:Q170790 wd:Q170790 wd:Q3621491 wd:Q593644 wd:Q2374149 wd:Q520549 wd:Q1662561 wd:Q2732142 
                       wd:Q212980 wd:Q205375 wd:Q3055126 wd:Q2487799 wd:Q39631 } . #occupation: archéologue, astronome, astrophysique, anthopologue, biologiste, mathématicien, etc.
  VALUES ?gender { wd:Q6581072 } . 
   ?item wdt:P31 wd:Q5;
               wdt:P21 ?gender;
               wdt:P27 ?country;
               wdt:P27 ?target_country;
               wdt:P106 ?occupation .
    FILTER NOT EXISTS {
    ?article schema:about ?item .
    ?article schema:isPartOf <https://fr.wikipedia.org/> .
  }
   SERVICE wikibase:label {
       bd:serviceParam wikibase:language "fr,en" .
       ?item rdfs:label ?itemLabel .
       ?occupation rdfs:label ?occupationLabel .
       ?country rdfs:label ?countryLabel .
   } .
} GROUP BY ?item ?itemLabel ORDER BY ?countries

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?article") v12("?countries") v7("?country") v10("?countryLabel"):::projected v6("?gender") v3("?item"):::projected v8("?itemLabel"):::projected v5("?occupation") v9("?occupationLabel"):::projected v11("?occupations") v4("?target_country") c3([https://fr.wikipedia.org/]):::iri c10(["bd:serviceParam"]):::iri c5(["wd:Q5"]):::iri c12(["fr,en"]):::literal f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 --"schema:about"--> e0v2 e0v1 --"schema:isPartOf"--> e0c3 e0v1("?article"):::projected e0v2("?item"):::projected e0c3([https://fr.wikipedia.org/]):::iri end f0--EXISTS--> f0e0 f0 --> v2 f0 --> c1 f0 --> v3 f0 --> c2 f0 --> c3 v2 --"schema:about"--> v3 v2 --"schema:isPartOf"--> c3 bind1[/VALUES ?target_country/] bind1-->v4 bind10(["wd:Q16"]) bind10 --> bind1 bind11(["wd:Q142"]) bind11 --> bind1 bind2[/VALUES ?occupation/] bind2-->v5 bind20(["wd:Q3621491"]) bind20 --> bind2 bind21(["wd:Q11063"]) bind21 --> bind2 bind22(["wd:Q37547"]) bind22 --> bind2 bind23(["wd:Q4773904"]) bind23 --> bind2 bind24(["wd:Q3378595"]) bind24 --> bind2 bind25(["wd:Q15634281"]) bind25 --> bind2 bind26(["wd:Q350979"]) bind26 --> bind2 bind27(["wd:Q2306091"]) bind27 --> bind2 bind28(["wd:Q2310145"]) bind28 --> bind2 bind29(["wd:Q19350898"]) bind29 --> bind2 bind210(["wd:Q3644587"]) bind210 --> bind2 bind211(["wd:Q82594"]) bind211 --> bind2 bind212(["wd:Q4459623"]) bind212 --> bind2 bind213(["wd:Q864503"]) bind213 --> bind2 bind214(["wd:Q169470"]) bind214 --> bind2 bind215(["wd:Q81096"]) bind215 --> bind2 bind216(["wd:Q170790"]) bind216 --> bind2 bind217(["wd:Q170790"]) bind217 --> bind2 bind218(["wd:Q3621491"]) bind218 --> bind2 bind219(["wd:Q593644"]) bind219 --> bind2 bind220(["wd:Q2374149"]) bind220 --> bind2 bind221(["wd:Q520549"]) bind221 --> bind2 bind222(["wd:Q1662561"]) bind222 --> bind2 bind223(["wd:Q2732142"]) bind223 --> bind2 bind224(["wd:Q212980"]) bind224 --> bind2 bind225(["wd:Q205375"]) bind225 --> bind2 bind226(["wd:Q3055126"]) bind226 --> bind2 bind227(["wd:Q2487799"]) bind227 --> bind2 bind228(["wd:Q39631"]) bind228 --> bind2 bind3[/VALUES ?gender/] bind3-->v6 bind30(["wd:Q6581072"]) bind30 --> bind3 v3 --"wdt:P31"--> c5 v3 --"wdt:P21"--> v6 v3 --"wdt:P27"--> v7 v3 --"wdt:P27"--> v4 v3 --"wdt:P106"--> v5 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c10 --"wikibase:language"--> c12 v3 --"rdfs:label"--> v8 v5 --"rdfs:label"--> v9 v7 --"rdfs:label"--> v10 end bind6[/"?occupationLabel"/] v9 --o bind6 bind6 --as--o v11 bind7[/"?countryLabel"/] v10 --o bind7 bind7 --as--o v12