Semen Collection Centre - Revision history

Albert at 01:46, 14 November 2016

2016-11-14T01:46:18Z

Albert: /* Semen Collection Centre codes */

2016-11-14T01:35:11Z

‎Semen Collection Centre codes

Catriona: Created page with "==Semen Collection Centre codes== {{#apGetSQL: select i.code, left(i.name,80), t.name[1], get_location(locationid) from infrastructure i join infrastructure_types..."

2014-09-17T14:10:17Z

Created page with "==Semen Collection Centre codes== {{#apGetSQL: select i.code, left(i.name,80), t.name[1], get_location(locationid) from infrastructure i join infrastructure_types..."

Halaman baru

==Semen Collection Centre codes==

{{#apGetSQL:
select
i.code,
left(i.name,80),
t.name[1],
get_location(locationid)
from infrastructure i
join infrastructure_types t on t.id = i.infrastructure_typeid
where i.infratype = 6 and not i.del
order by code|Kode, Nama, Jenis, Lokasi}}

@@ Baris 2: / Baris 2: @@
 {{#apGetSQL:
-select code, name from infrastructure where infratype=7 and not del order by code
+select i.code, i.name,it.name[1] as Jenis_Infrastruktur, get_location(i.locationid) as Lokasi from infrastructure i
 /*select
    i.code,

@@ Baris 2: / Baris 2: @@
 {{#apGetSQL:
-select
+select code, name from infrastructure where infratype=7 and not del order by code
    i.code,
    left(i.name,80),
@@ Baris 10: / Baris 11: @@
 join infrastructure_types t on t.id = i.infrastructure_typeid
 where i.infratype = 6 and not i.del
-order by code|Kode, Nama, Jenis, Lokasi}}
+order by code*/ |Kode, Nama}}