query-6a6a76b6f049b4fbcce42e5fd3246e7d

rq turtle/ttl

PropertiesWikimedia database name (P1800)

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 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