https://wiki.isikhnas.com/index.php?action=history&feed=atom&title=Translations%3ABasic_Field_Epi%3A_Course_Resource_Book%2F80%2Fid 2026-08-19T14:54:07Z Revision history for this page on the wiki MediaWiki 1.31.16 https://wiki.isikhnas.com/index.php?title=Translations:Basic_Field_Epi:_Course_Resource_Book/80/id&diff=28716&oldid=prev 2015-03-18T16:11:21Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="id"> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Revisi sebelumnya</td> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revisi per 18 Maret 2015 16.11</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Baris 1:</td> <td colspan="2" class="diff-lineno">Baris 1:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''List of iSIKHNAS priority syndromes'''</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''List of iSIKHNAS priority syndromes'''</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>{{#apGetSQL:select s.code,&#160; s.name[<del class="diffchange diffchange-inline">2</del>],&#160; s.description[<del class="diffchange diffchange-inline">2</del>], splist as Spesies</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>{{#apGetSQL:select s.code,&#160; s.name[<ins class="diffchange diffchange-inline">1</ins>],&#160; s.description[<ins class="diffchange diffchange-inline">1</ins>], splist as Spesies</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>from syndromes s</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>from syndromes s</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>join (</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>join (</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>&#160;&#160; select synid, string_agg(sp.name[<del class="diffchange diffchange-inline">2</del>],', ') as splist from (</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&#160;&#160; select synid, string_agg(sp.name[<ins class="diffchange diffchange-inline">1</ins>],', ') as splist from (</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#160;&#160; &#160; select id as synid, unnest(targetspeciesid) as spid from syndromes</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#160;&#160; &#160; select id as synid, unnest(targetspeciesid) as spid from syndromes</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#160;&#160; ) as foo</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#160;&#160; ) as foo</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l9" >Baris 9:</td> <td colspan="2" class="diff-lineno">Baris 9:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#160;&#160; group by synid</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#160;&#160; group by synid</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>) as bar on synid = s.id</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>) as bar on synid = s.id</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>order by Code,Name[<del class="diffchange diffchange-inline">2</del>],Description[<del class="diffchange diffchange-inline">2</del>]|code, Name, Description, Species}}</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>order by Code,Name[<ins class="diffchange diffchange-inline">1</ins>],Description[<ins class="diffchange diffchange-inline">1</ins>]|code, Name, Description, Species}}</div></td></tr> </table>

Catriona https://wiki.isikhnas.com/index.php?title=Translations:Basic_Field_Epi:_Course_Resource_Book/80/id&diff=19435&oldid=prev 2014-10-07T02:18:07Z

<p>Created page with &quot;&#039;&#039;&#039;List of iSIKHNAS priority syndromes&#039;&#039;&#039; {{#apGetSQL:select s.code, s.name[2], s.description[2], splist as Spesies from syndromes s join ( select synid, string_agg(sp.nam...&quot;</p> <p><b>Halaman baru</b></p><div>'''List of iSIKHNAS priority syndromes'''<br /> {{#apGetSQL:select s.code, s.name[2], s.description[2], splist as Spesies<br /> from syndromes s<br /> join (<br /> select synid, string_agg(sp.name[2],', ') as splist from (<br /> select id as synid, unnest(targetspeciesid) as spid from syndromes<br /> ) as foo<br /> join species sp on sp.id = spid<br /> group by synid<br /> ) as bar on synid = s.id<br /> order by Code,Name[2],Description[2]|code, Name, Description, Species}}</div>

Effa Respati