Wikipedia:ProyekWiki Bahasa/pemeliharaan/peta/WD: Perbedaan antara revisi

{

"type": "ExternalData",

"query": "SELECT ?id ?idLabel ?head ?iso ?glotto (SAMPLE(?img) as ?img_) (SAMPLE(?gmbr) as ?gmbr_) (min(?partyId) as ?geo) \n(concat('[[:id:', substr(str(?link2),31), '{{!}}', ?idLabel, ']]') as ?title) \n(if (BOUND(?glotto), \n 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, ']]&nbsp;{{*}}&nbsp;[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, ']]&nbsp;{{*}}&nbsp;[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, ']]&nbsp;{{*}}&nbsp;[https://glottolog.org/resource/languoid/id/', ?glotto, ' ' , ?glotto, ']</small>'))),\n 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]]&nbsp;{{*}}&nbsp;[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]]&nbsp;{{*}}&nbsp;[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]]&nbsp;{{*}}&nbsp;[https://glottolog.org/resource/languoid/id/', ?glotto, ' ' , ?glotto, ']</small>'))))\n, if (BOUND(?iso), \n if(BOUND(?glotto), 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, ']]&nbsp;{{*}}&nbsp;[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, ']]&nbsp;{{*}}&nbsp;[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, ']]&nbsp;{{*}}&nbsp;[https://glottolog.org/resource/languoid/id/', ?glotto, ' ' , ?glotto, ']</small>'))),\n 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, ']]&nbsp;{{*}}&nbsp;[https://glottolog.org/resource/languoid/id/ Belum tersedia]</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, ']]&nbsp;{{*}}&nbsp;[https://glottolog.org/resource/languoid/id/ Belum tersedia]</small>'), concat('[[:id:', substr(str(?link),31), '{{!}}', ?headLabel, ']]', '<small><hr>Informasi kode bahasa:<br>[[ISO639-3:', ?iso, '{{!}}', ?iso, ']]&nbsp;{{*}}&nbsp;[https://glottolog.org/resource/languoid/id/ Belum tersedia]</small>'))))\n, 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 ada</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 ada</i></small>'), concat('[[:id:', substr(str(?link),31), '{{!}}', ?headLabel, ']]', '<small><hr>Informasi kode bahasa:<br><i>Tidak ada</i></small>')))\n )) as ?description)\nWHERE { \n ?id wdt:P31 wd:Q34770 .\n ?id wdt:P279 ?head. \n ?id wdt:P625 ?geo. \nSERVICE wikibase:label {\n bd:serviceParam wikibase:language 'id' .\n ?head rdfs:label ?headLabel.\n ?id rdfs:label ?idLabel. \n }\nOPTIONAL {?id wdt:P220 ?iso. }\nOPTIONAL {?id wdt:P1394 ?glotto. }\nOPTIONAL {?id wdt:P18 ?img. }\nOPTIONAL {?id wdt:P1846 ?gmbr.}\n \n?link schema:about ?head. \n?link schema:isPartOf <https://wiki-indonesia.club/>.\n \n?link2 schema:about ?id. \n?link2 schema:isPartOf <https://wiki-indonesia.club/>.\n} \n\n\nGROUP BY ?id ?idLabel ?head ?headLabel ?link2 ?link ?iso ?glotto ?geo"

}