query-6a6a76b6f049b4fbcce42e5fd3246e7d
PropertiesWikimedia database name (P1800)
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 bd: <http://www.bigdata.com/rdf#>
SELECT ?Template ?TemplateURL ?TemplateTitle ?LanguageCode ?Wikigroup ?WikiLabel
WHERE {
VALUES ?Template {
wd:Q83761248 wd:Q5637226 wd:Q5312535 wd:Q5625141
}
?TemplateURL schema:about ?Template;
schema:inLanguage ?LanguageCode ;
schema:isPartOf [ wikibase:wikiGroup ?Wikigroup ] ;
schema:name ?TemplateTitle.
BIND(IF(?Wikigroup in ("wikipedia","commons","species","wikidata","meta","incubator"),CONCAT(?LanguageCode,"wiki"),CONCAT(?LanguageCode,?Wikigroup)) as ?wikilang)
?Wiki wdt:P1800 ?wikilang.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?LanguageCode"):::projected
v1("?Template"):::projected
v5("?TemplateTitle"):::projected
v2("?TemplateURL"):::projected
v7("?Wiki")
v4("?Wikigroup"):::projected
v6("?wikilang")
a1((" "))
c8(["bd:serviceParam"]):::iri
c10(["#91;AUTO_LANGUAGE#93;,en"]):::literal
bind0[/VALUES ?Template/]
bind0-->v1
bind00(["wd:Q83761248"])
bind00 --> bind0
bind01(["wd:Q5637226"])
bind01 --> bind0
bind02(["wd:Q5312535"])
bind02 --> bind0
bind03(["wd:Q5625141"])
bind03 --> bind0
v2 --"schema:about"--> v1
v2 --"schema:inLanguage"--> v3
a1 --"wikibase:wikiGroup"--> v4
v2 --"schema:isPartOf"--> a1
v2 --"schema:name"--> v5
list0c6(["incubator"]):::literal
list0c3(["species"]):::literal
list0c5(["meta"]):::literal
list0c1(["wikipedia"]):::literal
list0c4(["wikidata"]):::literal
list0c2(["commons"]):::literal
list0c1 --o bind1
list0c2 --o bind1
list0c3 --o bind1
list0c4 --o bind1
list0c5 --o bind1
list0c6 --o bind1
bind1[/"if( in ,concat(?LanguageCode,'wiki'),concat(?LanguageCode,?Wikigroup))"/]
v4 --o bind1
v3 --o bind1
bind1 --as--o v6
v7 --"wdt:P1800"--> v6
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c8 --"wikibase:language"--> c10
end