Aceh: Perbedaan revisi
| Baris 2: | Baris 2: | ||
code, | code, | ||
case when level < 5 then | case when level < 5 then | ||
| − | format ('%s%s%s', | + | format ('<h%s>%s</h%s>', |
| − | + | level, | |
| − | |||
name, | name, | ||
| − | + | level) | |
else | else | ||
name end | 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.15
| 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 |