| query | "#defaultView:Map
SELECT ?id ?idLabel ?head
(SAMPLE(?pop) AS ?populasi)
(SAMPLE(?ison) AS ?iso)
(SAMPLE(?glotton) AS ?glotto)
(SAMPLE(?img) AS ?img_)
(SAMPLE(?gmbr) AS ?gmbr_)
(MIN(?partyId) AS ?geo)
(CONCAT('[[:id:', SUBSTR(STR(?link2), 31), '{{!}}', ?idLabel, ']]') AS ?title)
(IF (BOUND(?populasi),
IF (BOUND(?glotto),
IF (BOUND(?iso),
IF (BOUND(?gmbr_),
CONCAT('[[:id:', SUBSTR(STR(?link), 31), '{{!}}', ?headLabel, ']]',
'[[File:', SUBSTR(STR(?gmbr_), 52, 400), '{{!}}200px]]',
'<small><hr>Populasi:',?populasi, '<hr>Informasi kode bahasa:<br>[[ISO639-3:', ?iso, '{{!}}', ?iso, ']] {{*}} ',
'[https://glottolog.org/resource/languoid/id/', ?glotto, ' ', ?glotto, ']</small>'),
IF (BOUND(?img_),
CONCAT('[[:id:', SUBSTR(STR(?link), 31), '{{!}}', ?headLabel, ']]',
'[[File:', SUBSTR(STR(?img_), 52, 400), '{{!}}200px]]',
'<small><hr>Populasi:',?populasi, '<hr>Informasi kode bahasa:<br>[[ISO639-3:', ?iso, '{{!}}', ?iso, ']] {{*}} ',
'[https://glottolog.org/resource/languoid/id/', ?glotto, ' ', ?glotto, ']</small>'),
CONCAT('[[:id:', SUBSTR(STR(?link), 31), '{{!}}', ?headLabel, ']]',
'<small><hr>Populasi:',?populasi, '<hr>Informasi kode bahasa:<br>[[ISO639-3:', ?iso, '{{!}}', ?iso, ']] {{*}} ',
'[https://glottolog.org/resource/languoid/id/', ?glotto, ' ', ?glotto, ']</small>')
)),
IF (BOUND(?gmbr_),
CONCAT('[[:id:', SUBSTR(STR(?link), 31), '{{!}}', ?headLabel, ']]',
'[[File:', SUBSTR(STR(?gmbr_), 52, 400), '{{!}}200px]]',
'<small><hr>Populasi:',?populasi, '<hr>Informasi kode bahasa:<br>[[ISO639-3:xx{{!}}Belum tersedia]] {{*}} ',
'[https://glottolog.org/resource/languoid/id/', ?glotto, ' ', ?glotto, ']</small>'),
IF (BOUND(?img_),
CONCAT('[[:id:', SUBSTR(STR(?link), 31), '{{!}}', ?headLabel, ']]',
'[[File:', SUBSTR(STR(?img_), 52, 400), '{{!}}200px]]',
'<small><hr>Populasi:',?populasi, '<hr>Informasi kode bahasa:<br>[[ISO639-3:xx{{!}}Belum tersedia]] {{*}} ',
'[https://glottolog.org/resource/languoid/id/', ?glotto, ' ', ?glotto, ']</small>'),
CONCAT('[[:id:', SUBSTR(STR(?link), 31), '{{!}}', ?headLabel, ']]',
'<small><hr>Populasi:',?populasi, '<hr>Informasi kode bahasa:<br>[[ISO639-3:xx{{!}}Belum tersedia]] {{*}} ',
'[https://glottolog.org/resource/languoid/id/', ?glotto, ' ', ?glotto, ']</small>')
))),
IF (BOUND(?gmbr_),
CONCAT('[[:id:', SUBSTR(STR(?link), 31), '{{!}}', ?headLabel, ']]',
'[[File:', SUBSTR(STR(?gmbr_), 52, 400), '{{!}}200px]]',
'<small><hr>Populasi:',?populasi, '<hr>Informasi kode bahasa:<br><i>Tidak tersedia</i></small>'),
IF (BOUND(?img_),
CONCAT('[[:id:', SUBSTR(STR(?link), 31), '{{!}}', ?headLabel, ']]',
'[[File:', SUBSTR(STR(?img_), 52, 400), '{{!}}200px]]',
'<small><hr>Populasi:',?populasi, '<hr>Informasi kode bahasa:<br><i>Tidak tersedia</i></small>'),
CONCAT('[[:id:', SUBSTR(STR(?link), 31), '{{!}}', ?headLabel, ']]',
'<small><hr>Populasi:',?populasi, '<hr>Informasi kode bahasa:<br><i>Tidak tersedia</i></small>')
)
)
),
IF (BOUND(?glotto),
IF (BOUND(?iso),
IF (BOUND(?gmbr_),
CONCAT('[[:id:', SUBSTR(STR(?link), 31), '{{!}}', ?headLabel, ']]',
'[[File:', SUBSTR(STR(?gmbr_), 52, 400), '{{!}}200px]]',
'<small><hr>Informasi kode bahasa:<br>[[ISO639-3:', ?iso, '{{!}}', ?iso, ']] {{*}} ',
'[https://glottolog.org/resource/languoid/id/', ?glotto, ' ', ?glotto, ']</small>'),
IF (BOUND(?img_),
CONCAT('[[:id:', SUBSTR(STR(?link), 31), '{{!}}', ?headLabel, ']]',
'[[File:', SUBSTR(STR(?img_), 52, 400), '{{!}}200px]]',
'<small><hr>Informasi kode bahasa:<br>[[ISO639-3:', ?iso, '{{!}}', ?iso, ']] {{*}} ',
'[https://glottolog.org/resource/languoid/id/', ?glotto, ' ', ?glotto, ']</small>'),
CONCAT('[[:id:', SUBSTR(STR(?link), 31), '{{!}}', ?headLabel, ']]',
'<small><hr>Informasi kode bahasa:<br>[[ISO639-3:', ?iso, '{{!}}', ?iso, ']] {{*}} ',
'[https://glottolog.org/resource/languoid/id/', ?glotto, ' ', ?glotto, ']</small>')
)),
IF (BOUND(?gmbr_),
CONCAT('[[:id:', SUBSTR(STR(?link), 31), '{{!}}', ?headLabel, ']]',
'[[File:', SUBSTR(STR(?gmbr_), 52, 400), '{{!}}200px]]',
'<small><hr>Informasi kode bahasa:<br>[[ISO639-3:xx{{!}}Belum tersedia]] {{*}} ',
'[https://glottolog.org/resource/languoid/id/', ?glotto, ' ', ?glotto, ']</small>'),
IF (BOUND(?img_),
CONCAT('[[:id:', SUBSTR(STR(?link), 31), '{{!}}', ?headLabel, ']]',
'[[File:', SUBSTR(STR(?img_), 52, 400), '{{!}}200px]]',
'<small><hr>Informasi kode bahasa:<br>[[ISO639-3:xx{{!}}Belum tersedia]] {{*}} ',
'[https://glottolog.org/resource/languoid/id/', ?glotto, ' ', ?glotto, ']</small>'),
CONCAT('[[:id:', SUBSTR(STR(?link), 31), '{{!}}', ?headLabel, ']]',
'<small><hr>Informasi kode bahasa:<br>[[ISO639-3:xx{{!}}Belum tersedia]] {{*}} ',
'[https://glottolog.org/resource/languoid/id/', ?glotto, ' ', ?glotto, ']</small>')
))),
IF (BOUND(?gmbr_),
CONCAT('[[:id:', SUBSTR(STR(?link), 31), '{{!}}', ?headLabel, ']]',
'[[File:', SUBSTR(STR(?gmbr_), 52, 400), '{{!}}200px]]',
'<small><hr>Informasi kode bahasa:<br><i>Tidak tersedia</i></small>'),
IF (BOUND(?img_),
CONCAT('[[:id:', SUBSTR(STR(?link), 31), '{{!}}', ?headLabel, ']]',
'[[File:', SUBSTR(STR(?img_), 52, 400), '{{!}}200px]]',
'<small><hr>Informasi kode bahasa:<br><i>Tidak tersedia</i></small>'),
CONCAT('[[:id:', SUBSTR(STR(?link), 31), '{{!}}', ?headLabel, ']]',
'<small><hr>Informasi kode bahasa:<br><i>Tidak tersedia</i></small>')
)
)
)) AS ?description)
WHERE {
?id wdt:P31 wd:Q34770 .
?id wdt:P279 ?head .
?id wdt:P625 ?geo .
SERVICE wikibase:label {
bd:serviceParam wikibase:language 'id' .
?head rdfs:label ?headLabel .
?id rdfs:label ?idLabel .
}
OPTIONAL { ?id wdt:P220 ?ison . }
OPTIONAL { ?id wdt:P1394 ?glotton . }
OPTIONAL { ?id wdt:P18 ?img . }
OPTIONAL { ?id wdt:P1098 ?pop . }
OPTIONAL { ?id wdt:P1846 ?gmbr . }
?link schema:about ?head .
?link schema:isPartOf <https://wiki-indonesia.club/> .
?link2 schema:about ?id .
?link2 schema:isPartOf <https://wiki-indonesia.club/> .
}
GROUP BY ?id ?idLabel ?head ?headLabel ?link2 ?link ?geo
" |
|---|
