Priority Syndrome codes - Revision history

Catriona at 14:14, 17 September 2014

2014-09-17T14:14:24Z

Catriona at 08:02, 8 September 2014

2014-09-08T08:02:52Z

Catriona: Created page with "==English== {{#apGetSQL:select s.code, s.name[2], s.description[2], splist as Spesies from syndromes s join ( select synid, string_agg(sp.name[2],', ') as splist from ( ..."

2014-02-23T05:00:17Z

Created page with "==English== {{#apGetSQL:select s.code, s.name[2], s.description[2], splist as Spesies from syndromes s join ( select synid, string_agg(sp.name[2],', ') as splist from ( ..."

Halaman baru

==English==

{{#apGetSQL:select s.code, s.name[2], s.description[2], splist as Spesies
from syndromes s
join (
select synid, string_agg(sp.name[2],', ') as splist from (
select id as synid, unnest(targetspeciesid) as spid from syndromes
) as foo
join species sp on sp.id = spid
group by synid
) as bar on synid = s.id
order by Code,Name[2],Description[2]|code, Name, Description, Species}}

==Bahasa Indonesia==

{{#apGetSQL:select s.code, s.name[1], s.description[1], splist as Spesies
from syndromes s
join (
select synid, string_agg(sp.name[1],', ') as splist from (
select id as synid, unnest(targetspeciesid) as spid from syndromes
) as foo
join species sp on sp.id = spid
group by synid
) as bar on synid = s.id
order by Code,Name[1],Description[1]|Kode, Nama, Description, Spesies}}

← Revisi sebelumnya		Revisi per 17 September 2014 14.14
Baris 1:		Baris 1:
		+	==Kode Sindrom Prioritas : Priority Syndrome codes==
		+
	==Bahasa Indonesia==		==Bahasa Indonesia==

@@ Baris 1: / Baris 1: @@
-==English==
+==Bahasa Indonesia==
-{{#apGetSQL:select s.code,  s.name[2],  s.description[2], splist as Spesies
+{{#apGetSQL:select s.code,  s.name[1],  s.description[1], splist as Spesies
 from syndromes s
 join (
-   select synid, string_agg(sp.name[2],', ') as splist from (
+   select synid, string_agg(sp.name[1],', ') as splist from (
      select id as synid, unnest(targetspeciesid) as spid from syndromes
    ) as foo
@@ Baris 10: / Baris 10: @@
    group by synid
 ) as bar on synid = s.id
-order by Code,Name[2],Description[2]|code, Name, Description, Species}}
+order by Code,Name[1],Description[1]|Kode, Nama, Description, Spesies}}
-==Bahasa Indonesia==
+==English==
-{{#apGetSQL:select s.code,  s.name[1],  s.description[1], splist as Spesies
+{{#apGetSQL:select s.code,  s.name[2],  s.description[2], splist as Spesies
 from syndromes s
 join (
-   select synid, string_agg(sp.name[1],', ') as splist from (
+   select synid, string_agg(sp.name[2],', ') as splist from (
      select id as synid, unnest(targetspeciesid) as spid from syndromes
    ) as foo
@@ Baris 23: / Baris 24: @@
    group by synid
 ) as bar on synid = s.id
-order by Code,Name[1],Description[1]|Kode, Nama, Description, Spesies}}
+order by Code,Name[2],Description[2]|code, Name, Description, Species}}