Wiki Sumber Informasi iSIKHNAS

==Kode Sindrom Prioritas : Priority Syndrome codes==

==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}}


==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}}