Aceh: Perbedaan revisi
Baris 2: | Baris 2: | ||
code, | code, | ||
case when level < 5 then | case when level < 5 then | ||
− | + | format ('<h%s>%s</h%s>', | |
level, | level, | ||
name, | name, | ||
level) | level) | ||
else | else | ||
− | name end | + | format (' %s', |
+ | name) | ||
+ | end | ||
from locations where left(code,2) = '12' and not del order by code limit 10|Code, location}} | from locations where left(code,2) = '12' and not del order by code limit 10|Code, location}} |
Revisi per 28 Agustus 2014 18.19
Code | location |
---|---|
12 | Sumatera Utara |
1201 | Nias |
120101 | Idano Gawo |
12010101 | Tete Goenaai |
12010102 | Laowo Hilimbaruzo |
12010103 | Hililawae |
12010104 | Tuhewaebu |
12010105 | Sisobahili Iraonohura |
12010106 | Hilimoasio |
12010107 | Oladano |