query-e85767d941c81ea4162dcae986a7c405
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/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?person ?personLabel ?English ?French ?Italian ?German
WHERE {
values ?person {wd:Q7186 wd:Q232423 wd:Q236038 wd:Q266086 wd:Q269338 wd:Q4110933}.
optional { ?wen schema:about ?person . ?wen schema:name ?article_en . ?wen schema:isPartOf <https://en.wikipedia.org/> . optional {?wen wikibase:badge ?badge_en .} }
optional { ?wfr schema:about ?person . ?wfr schema:name ?article_fr . ?wfr schema:isPartOf <https://fr.wikipedia.org/> . optional {?wfr wikibase:badge ?badge_fr .} }
optional { ?wit schema:about ?person . ?wit schema:name ?article_it . ?wit schema:isPartOf <https://it.wikipedia.org/> . optional {?wit wikibase:badge ?badge_it .} }
optional { ?wde schema:about ?person . ?wde schema:name ?article_de . ?wde schema:isPartOf <https://de.wikipedia.org/> . optional {?wde wikibase:badge ?badge_de .} }
bind(if(bound(?article_en),"Yes","") as ?En)
bind(if(bound(?badge_en),if(?badge_en=wd:Q17437798,"Good","Featured"),"") as ?EnQual)
bind(if(?EnQual!="",?EnQual,?En) as ?English)
bind(if(bound(?article_fr),"Yes","") as ?Fr)
bind(if(bound(?badge_fr),if(?badge_fr=wd:Q17437798,"Good","Featured"),"") as ?FrQual)
bind(if(?FrQual!="",?FrQual,?Fr) as ?French)
bind(if(bound(?article_it),"Yes","") as ?It)
bind(if(bound(?badge_it),if(?badge_it=wd:Q17437798,"Good","Featured"),"") as ?ItQual)
bind(if(?ItQual!="",?ItQual,?It) as ?Italian)
bind(if(bound(?article_de),"Yes","") as ?De)
bind(if(bound(?badge_de),if(?badge_de=wd:Q17437798,"Good","Featured"),"") as ?DeQual)
bind(if(?DeQual!="",?DeQual,?De) as ?German)
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v23("?De")
v24("?DeQual")
v14("?En")
v15("?EnQual")
v16("?English"):::projected
v17("?Fr")
v18("?FrQual")
v19("?French"):::projected
v25("?German"):::projected
v20("?It")
v21("?ItQual")
v22("?Italian"):::projected
v12("?article_de")
v3("?article_en")
v6("?article_fr")
v9("?article_it")
v13("?badge_de")
v4("?badge_en")
v7("?badge_fr")
v10("?badge_it")
v1("?person"):::projected
v11("?wde")
v2("?wen")
v5("?wfr")
v8("?wit")
c8([https://de.wikipedia.org/]):::iri
c4([https://en.wikipedia.org/]):::iri
c10(["bd:serviceParam"]):::iri
c6([https://fr.wikipedia.org/]):::iri
c12(["en"]):::literal
c7([https://it.wikipedia.org/]):::iri
bind0[/VALUES ?person/]
bind0-->v1
bind00(["wd:Q7186"])
bind00 --> bind0
bind01(["wd:Q232423"])
bind01 --> bind0
bind02(["wd:Q236038"])
bind02 --> bind0
bind03(["wd:Q266086"])
bind03 --> bind0
bind04(["wd:Q269338"])
bind04 --> bind0
bind05(["wd:Q4110933"])
bind05 --> bind0
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v2 -."schema:about".-> v1
v2 --"schema:name"--> v3
v2 --"schema:isPartOf"--> c4
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v2 -."wikibase:badge".-> v4
end
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v5 -."schema:about".-> v1
v5 --"schema:name"--> v6
v5 --"schema:isPartOf"--> c6
subgraph optional3["(optional)"]
style optional3 fill:#bbf,stroke-dasharray: 5 5;
v5 -."wikibase:badge".-> v7
end
end
subgraph optional4["(optional)"]
style optional4 fill:#bbf,stroke-dasharray: 5 5;
v8 -."schema:about".-> v1
v8 --"schema:name"--> v9
v8 --"schema:isPartOf"--> c7
subgraph optional5["(optional)"]
style optional5 fill:#bbf,stroke-dasharray: 5 5;
v8 -."wikibase:badge".-> v10
end
end
subgraph optional6["(optional)"]
style optional6 fill:#bbf,stroke-dasharray: 5 5;
v11 -."schema:about".-> v1
v11 --"schema:name"--> v12
v11 --"schema:isPartOf"--> c8
subgraph optional7["(optional)"]
style optional7 fill:#bbf,stroke-dasharray: 5 5;
v11 -."wikibase:badge".-> v13
end
end
bind1[/"if(bound(?article_en),'Yes','')"/]
v3 --o bind1
bind1 --as--o v14
bind2[/"if(bound(?badge_en),if(?badge_en = 'wd:Q17437798','Good','Featured'),'')"/]
v4 --o bind2
bind2 --as--o v15
bind3[/"if(?EnQual != '',?EnQual,?En)"/]
v15 --o bind3
v14 --o bind3
bind3 --as--o v16
bind4[/"if(bound(?article_fr),'Yes','')"/]
v6 --o bind4
bind4 --as--o v17
bind5[/"if(bound(?badge_fr),if(?badge_fr = 'wd:Q17437798','Good','Featured'),'')"/]
v7 --o bind5
bind5 --as--o v18
bind6[/"if(?FrQual != '',?FrQual,?Fr)"/]
v18 --o bind6
v17 --o bind6
bind6 --as--o v19
bind7[/"if(bound(?article_it),'Yes','')"/]
v9 --o bind7
bind7 --as--o v20
bind8[/"if(bound(?badge_it),if(?badge_it = 'wd:Q17437798','Good','Featured'),'')"/]
v10 --o bind8
bind8 --as--o v21
bind9[/"if(?ItQual != '',?ItQual,?It)"/]
v21 --o bind9
v20 --o bind9
bind9 --as--o v22
bind10[/"if(bound(?article_de),'Yes','')"/]
v12 --o bind10
bind10 --as--o v23
bind11[/"if(bound(?badge_de),if(?badge_de = 'wd:Q17437798','Good','Featured'),'')"/]
v13 --o bind11
bind11 --as--o v24
bind12[/"if(?DeQual != '',?DeQual,?De)"/]
v24 --o bind12
v23 --o bind12
bind12 --as--o v25
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c10 --"wikibase:language"--> c12
end