Infrastructure codes: Perbedaan revisi
(Created page with "==Infrastructure codes==") |
|||
| Baris 1: | Baris 1: | ||
| − | ==Infrastructure codes== | + | <!-- ==Infrastructure codes== |
| + | |||
| + | ==Bahasa Indonesia== | ||
| + | {{#apGetSQL:select code, name[1] | ||
| + | from infrastructure | ||
| + | order by Name[1]|Kode, Infrastruktura}} | ||
| + | |||
| + | ==English== | ||
| + | {{#apGetSQL:select code, name[2] | ||
| + | from infrastructure | ||
| + | order by Name[2]|Code, Infrastructure}}--> | ||
| + | |||
| + | |||
| + | select hiercode, code, hierindent(name[1],hiercode, false) | ||
| + | from infrastructure_types | ||
| + | where not del | ||
| + | order by hiersort(hiercode) | ||
| + | |||
| + | |||
| + | Semen Collection Centres | ||
| + | |||
| + | Abattoirs | ||
| + | |||
| + | Veterinary Service Offices | ||
| + | |||
| + | Laboratories | ||
| + | |||
| + | Check points | ||
| + | |||
| + | Market PSR | ||
| + | |||
| + | Aggregation Centre | ||
Revisi per 17 September 2014 13.22
select hiercode, code, hierindent(name[1],hiercode, false) from infrastructure_types where not del order by hiersort(hiercode)
Semen Collection Centres
Abattoirs
Veterinary Service Offices
Laboratories
Check points
Market PSR
Aggregation Centre