General Signs codes for Dinas - Revision history

Catriona at 14:13, 17 September 2014

2014-09-17T14:13:19Z

Catriona at 07:54, 8 September 2014

2014-09-08T07:54:06Z

Catriona: Created page with "==English== {{#apGetSQL:select code, case when array_length(hiersort(hiercode),1)=1 then format('%s',hierindent(name[2],hiercode, true)) else hierindent(name[2]..."

2014-02-23T04:59:19Z

Created page with "==English== {{#apGetSQL:select code, case when array_length(hiersort(hiercode),1)=1 then format('%s',hierindent(name[2],hiercode, true)) else hierindent(name[2]..."

Halaman baru

==English==

{{#apGetSQL:select code,
case when array_length(hiersort(hiercode),1)=1 then
format('%s',hierindent(name[2],hiercode, true))
else hierindent(name[2],hiercode, true) end
from signs
where not del
order by hiersort(hiercode)|Code,Sign}}

==Bahasa Indonesia==

{{#apGetSQL:select code,
case when array_length(hiersort(hiercode),1)=1 then
format('%s',hierindent(name[1],hiercode, true))
else hierindent(name[1],hiercode, true) end
from signs
where not del
order by hiersort(hiercode)|Code,Sign}}

← Revisi sebelumnya		Revisi per 17 September 2014 14.13
Baris 1:		Baris 1:
		+	==Kode Tanda Umum Dinas : Dinas General Signs codes==
		+
	==Bahasa Indonesia==		==Bahasa Indonesia==

@@ Baris 1: / Baris 1: @@
-==English==
+==Bahasa Indonesia==
 {{#apGetSQL:select code,
    case when array_length(hiersort(hiercode),1)=1 then
-   format('<b>%s</b>',hierindent(name[2],hiercode, true))
+   format('<b>%s</b>',hierindent(name[1],hiercode, true))
-   else hierindent(name[2],hiercode, true) end
+   else hierindent(name[1],hiercode, true) end
 from signs
 where not del
 order by hiersort(hiercode)|Code,Sign}}
-==Bahasa Indonesia==
+==English==
 {{#apGetSQL:select code,
    case when array_length(hiersort(hiercode),1)=1 then
-   format('<b>%s</b>',hierindent(name[1],hiercode, true))
+   format('<b>%s</b>',hierindent(name[2],hiercode, true))
-   else hierindent(name[1],hiercode, true) end
+   else hierindent(name[2],hiercode, true) end
 from signs
 where not del
 order by hiersort(hiercode)|Code,Sign}}