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 20.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