query-bc8d736bd71f7c08047da9dfdfc2bb7f
TODO
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
SELECT ?language ?Marie_Curie ?Judith_Leyster ?Sofonisba_Anguissola ?Gerda_Wegener ?Josefa_de_Obidos ?Maria_Wiik
WHERE {
#LANGUAGE VALUE STATEMENT
values (?language ?langcode) { ("French" "fr") ("German" "de") ("Italian" "it") ("Polish" "pl") ("Spanish" "es") ("Finnish" "fi") ("English" "en") ("Portuguese" "pt") ("Croatian" "hr") ("Dutch" "nl") ("Romanian" "ro") ("Bulgarian" "bg") ("Swedish" "sv") ("Danish" "da") ("Czech" "cs") ("Slovak" "sk") ("Slovene" "sl") ("Hungarian" "hu") ("Estonian" "et") ("Latvian" "lv") ("Lithuanian" "lt") ("Greek" "el") ("Irish" "ga") ("Maltese" "mt") } .
BIND(IRI(CONCAT("https://",str(?langcode),".wikipedia.org/"))AS ?wikilangs)
#PEOPLE VALUE STATEMENTS
values ?person1 {wd:Q7186} . #put the Qid of the first selected person here
values ?person2 {wd:Q232423} .
values ?person3 {wd:Q236038} .
values ?person4 {wd:Q266086} .
values ?person5 {wd:Q269338} .
values ?person6 {wd:Q4110933} . #put the Qid of the sixth selected person here
#OPTIONAL STATEMENTS
optional { ?wp1 schema:about ?person1 . ?wp1 schema:name ?article_p1 . ?wp1 schema:isPartOf ?wikilangs . optional {?wp1 wikibase:badge ?badge_p1 .} }
optional { ?wp2 schema:about ?person2 . ?wp2 schema:name ?article_p2 . ?wp2 schema:isPartOf ?wikilangs . optional {?wp2 wikibase:badge ?badge_p2 .} }
optional { ?wp3 schema:about ?person3 . ?wp3 schema:name ?article_p3 . ?wp3 schema:isPartOf ?wikilangs . optional {?wp3 wikibase:badge ?badge_p3 .} }
optional { ?wp4 schema:about ?person4 . ?wp4 schema:name ?article_p4 . ?wp4 schema:isPartOf ?wikilangs . optional {?wp4 wikibase:badge ?badge_p4 .} }
optional { ?wp5 schema:about ?person5 . ?wp5 schema:name ?article_p5 . ?wp5 schema:isPartOf ?wikilangs . optional {?wp5 wikibase:badge ?badge_p5 .} }
optional { ?wp6 schema:about ?person6 . ?wp6 schema:name ?article_p6 . ?wp6 schema:isPartOf ?wikilangs . optional {?wp6 wikibase:badge ?badge_p6 .} }
#BIND STATEMENTS
bind(if(bound(?article_p1),"Yes","") as ?ap1)
bind(if(bound(?badge_p1),if(?badge_p1=wd:Q17437798,"Good","Featured"),"") as ?bp1)
bind(if(?bp1!="",?bp1,?ap1) as ?Marie_Curie) #put the variable name for the first selected person here
bind(if(bound(?article_p2),"Yes","") as ?ap2)
bind(if(bound(?badge_p2),if(?badge_p2=wd:Q17437798,"Good","Featured"),"") as ?bp2)
bind(if(?bp2!="",?bp2,?ap2) as ?Judith_Leyster) #put the variable name for the second selected person here
bind(if(bound(?article_p3),"Yes","") as ?ap3)
bind(if(bound(?badge_p3),if(?badge_p3=wd:Q17437798,"Good","Featured"),"") as ?bp3)
bind(if(?bp3!="",?bp3,?ap3) as ?Sofonisba_Anguissola)
bind(if(bound(?article_p4),"Yes","") as ?ap4)
bind(if(bound(?badge_p4),if(?badge_p4=wd:Q17437798,"Good","Featured"),"") as ?bp4)
bind(if(?bp4!="",?bp4,?ap4) as ?Gerda_Wegener)
bind(if(bound(?article_p5),"Yes","") as ?ap5)
bind(if(bound(?badge_p5),if(?badge_p5=wd:Q17437798,"Good","Featured"),"") as ?bp5)
bind(if(?bp5!="",?bp5,?ap5) as ?Josefa_de_Obidos)
bind(if(bound(?article_p6),"Yes","") as ?ap6)
bind(if(bound(?badge_p6),if(?badge_p6=wd:Q17437798,"Good","Featured"),"") as ?bp6)
bind(if(?bp6!="",?bp6,?ap6) as ?Maria_Wiik)
} order by ?language
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v39("?Gerda_Wegener"):::projected
v42("?Josefa_de_Obidos"):::projected
v33("?Judith_Leyster"):::projected
v45("?Maria_Wiik"):::projected
v30("?Marie_Curie"):::projected
v36("?Sofonisba_Anguissola"):::projected
v28("?ap1")
v31("?ap2")
v34("?ap3")
v37("?ap4")
v40("?ap5")
v43("?ap6")
v11("?article_p1")
v14("?article_p2")
v17("?article_p3")
v20("?article_p4")
v23("?article_p5")
v26("?article_p6")
v12("?badge_p1")
v15("?badge_p2")
v18("?badge_p3")
v21("?badge_p4")
v24("?badge_p5")
v27("?badge_p6")
v29("?bp1")
v32("?bp2")
v35("?bp3")
v38("?bp4")
v41("?bp5")
v44("?bp6")
v2("?langcode")
v2("?language"):::projected
v4("?person1")
v5("?person2")
v6("?person3")
v7("?person4")
v8("?person5")
v9("?person6")
v3("?wikilangs")
v10("?wp1")
v13("?wp2")
v16("?wp3")
v19("?wp4")
v22("?wp5")
v25("?wp6")
bind0[/VALUES ?langcode ?language/]
bind0-->v2
bind0-->v2
bind00(["French"])
bind00 --> bind0
bind01(["fr"])
bind01 --> bind0
bind02(["German"])
bind02 --> bind0
bind03(["de"])
bind03 --> bind0
bind04(["Italian"])
bind04 --> bind0
bind05(["it"])
bind05 --> bind0
bind06(["Polish"])
bind06 --> bind0
bind07(["pl"])
bind07 --> bind0
bind08(["Spanish"])
bind08 --> bind0
bind09(["es"])
bind09 --> bind0
bind010(["Finnish"])
bind010 --> bind0
bind011(["fi"])
bind011 --> bind0
bind012(["English"])
bind012 --> bind0
bind013(["en"])
bind013 --> bind0
bind014(["Portuguese"])
bind014 --> bind0
bind015(["pt"])
bind015 --> bind0
bind016(["Croatian"])
bind016 --> bind0
bind017(["hr"])
bind017 --> bind0
bind018(["Dutch"])
bind018 --> bind0
bind019(["nl"])
bind019 --> bind0
bind020(["Romanian"])
bind020 --> bind0
bind021(["ro"])
bind021 --> bind0
bind022(["Bulgarian"])
bind022 --> bind0
bind023(["bg"])
bind023 --> bind0
bind024(["Swedish"])
bind024 --> bind0
bind025(["sv"])
bind025 --> bind0
bind026(["Danish"])
bind026 --> bind0
bind027(["da"])
bind027 --> bind0
bind028(["Czech"])
bind028 --> bind0
bind029(["cs"])
bind029 --> bind0
bind030(["Slovak"])
bind030 --> bind0
bind031(["sk"])
bind031 --> bind0
bind032(["Slovene"])
bind032 --> bind0
bind033(["sl"])
bind033 --> bind0
bind034(["Hungarian"])
bind034 --> bind0
bind035(["hu"])
bind035 --> bind0
bind036(["Estonian"])
bind036 --> bind0
bind037(["et"])
bind037 --> bind0
bind038(["Latvian"])
bind038 --> bind0
bind039(["lv"])
bind039 --> bind0
bind040(["Lithuanian"])
bind040 --> bind0
bind041(["lt"])
bind041 --> bind0
bind042(["Greek"])
bind042 --> bind0
bind043(["el"])
bind043 --> bind0
bind044(["Irish"])
bind044 --> bind0
bind045(["ga"])
bind045 --> bind0
bind046(["Maltese"])
bind046 --> bind0
bind047(["mt"])
bind047 --> bind0
bind1[/"concat('https://',str(?langcode),'.wikipedia.org/')"/]
v2 --o bind1
bind1 --as--o v3
bind2[/VALUES ?person1/]
bind2-->v4
bind20(["wd:Q7186"])
bind20 --> bind2
bind3[/VALUES ?person2/]
bind3-->v5
bind30(["wd:Q232423"])
bind30 --> bind3
bind4[/VALUES ?person3/]
bind4-->v6
bind40(["wd:Q236038"])
bind40 --> bind4
bind5[/VALUES ?person4/]
bind5-->v7
bind50(["wd:Q266086"])
bind50 --> bind5
bind6[/VALUES ?person5/]
bind6-->v8
bind60(["wd:Q269338"])
bind60 --> bind6
bind7[/VALUES ?person6/]
bind7-->v9
bind70(["wd:Q4110933"])
bind70 --> bind7
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v10 -."schema:about".-> v4
v10 --"schema:name"--> v11
v10 --"schema:isPartOf"--> v3
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v10 -."wikibase:badge".-> v12
end
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v13 -."schema:about".-> v5
v13 --"schema:name"--> v14
v13 --"schema:isPartOf"--> v3
subgraph optional3["(optional)"]
style optional3 fill:#bbf,stroke-dasharray: 5 5;
v13 -."wikibase:badge".-> v15
end
end
subgraph optional4["(optional)"]
style optional4 fill:#bbf,stroke-dasharray: 5 5;
v16 -."schema:about".-> v6
v16 --"schema:name"--> v17
v16 --"schema:isPartOf"--> v3
subgraph optional5["(optional)"]
style optional5 fill:#bbf,stroke-dasharray: 5 5;
v16 -."wikibase:badge".-> v18
end
end
subgraph optional6["(optional)"]
style optional6 fill:#bbf,stroke-dasharray: 5 5;
v19 -."schema:about".-> v7
v19 --"schema:name"--> v20
v19 --"schema:isPartOf"--> v3
subgraph optional7["(optional)"]
style optional7 fill:#bbf,stroke-dasharray: 5 5;
v19 -."wikibase:badge".-> v21
end
end
subgraph optional8["(optional)"]
style optional8 fill:#bbf,stroke-dasharray: 5 5;
v22 -."schema:about".-> v8
v22 --"schema:name"--> v23
v22 --"schema:isPartOf"--> v3
subgraph optional9["(optional)"]
style optional9 fill:#bbf,stroke-dasharray: 5 5;
v22 -."wikibase:badge".-> v24
end
end
subgraph optional10["(optional)"]
style optional10 fill:#bbf,stroke-dasharray: 5 5;
v25 -."schema:about".-> v9
v25 --"schema:name"--> v26
v25 --"schema:isPartOf"--> v3
subgraph optional11["(optional)"]
style optional11 fill:#bbf,stroke-dasharray: 5 5;
v25 -."wikibase:badge".-> v27
end
end
bind8[/"if(bound(?article_p1),'Yes','')"/]
v11 --o bind8
bind8 --as--o v28
bind9[/"if(bound(?badge_p1),if(?badge_p1 = 'wd:Q17437798','Good','Featured'),'')"/]
v12 --o bind9
bind9 --as--o v29
bind10[/"if(?bp1 != '',?bp1,?ap1)"/]
v29 --o bind10
v28 --o bind10
bind10 --as--o v30
bind11[/"if(bound(?article_p2),'Yes','')"/]
v14 --o bind11
bind11 --as--o v31
bind12[/"if(bound(?badge_p2),if(?badge_p2 = 'wd:Q17437798','Good','Featured'),'')"/]
v15 --o bind12
bind12 --as--o v32
bind13[/"if(?bp2 != '',?bp2,?ap2)"/]
v32 --o bind13
v31 --o bind13
bind13 --as--o v33
bind14[/"if(bound(?article_p3),'Yes','')"/]
v17 --o bind14
bind14 --as--o v34
bind15[/"if(bound(?badge_p3),if(?badge_p3 = 'wd:Q17437798','Good','Featured'),'')"/]
v18 --o bind15
bind15 --as--o v35
bind16[/"if(?bp3 != '',?bp3,?ap3)"/]
v35 --o bind16
v34 --o bind16
bind16 --as--o v36
bind17[/"if(bound(?article_p4),'Yes','')"/]
v20 --o bind17
bind17 --as--o v37
bind18[/"if(bound(?badge_p4),if(?badge_p4 = 'wd:Q17437798','Good','Featured'),'')"/]
v21 --o bind18
bind18 --as--o v38
bind19[/"if(?bp4 != '',?bp4,?ap4)"/]
v38 --o bind19
v37 --o bind19
bind19 --as--o v39
bind20[/"if(bound(?article_p5),'Yes','')"/]
v23 --o bind20
bind20 --as--o v40
bind21[/"if(bound(?badge_p5),if(?badge_p5 = 'wd:Q17437798','Good','Featured'),'')"/]
v24 --o bind21
bind21 --as--o v41
bind22[/"if(?bp5 != '',?bp5,?ap5)"/]
v41 --o bind22
v40 --o bind22
bind22 --as--o v42
bind23[/"if(bound(?article_p6),'Yes','')"/]
v26 --o bind23
bind23 --as--o v43
bind24[/"if(bound(?badge_p6),if(?badge_p6 = 'wd:Q17437798','Good','Featured'),'')"/]
v27 --o bind24
bind24 --as--o v44
bind25[/"if(?bp6 != '',?bp6,?ap6)"/]
v44 --o bind25
v43 --o bind25
bind25 --as--o v45