query-23a4673359c5ffbf9d3723365d1088df
Femmes scientifiques canadiennes et françaises sans article en français
Use at
- https://query.wikidata.org/sparql
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