# HG changeset patch
# User HIROSE Yuuji <yuuji@gentei.org>
# Date 1608602283 -32400
# Node ID 7ca1f11ab5e8996b5fa1f8dcdd55487bfed1b454
# Parent  8229c75e9f946036189145efb497f4e10f5b5f62
Ensure sort by login name in grpaction()

diff -r 8229c75e9f94 -r 7ca1f11ab5e8 s4-funcs.sh
--- a/s4-funcs.sh	Tue Dec 22 08:24:23 2020 +0900
+++ b/s4-funcs.sh	Tue Dec 22 10:58:03 2020 +0900
@@ -3139,7 +3139,7 @@
 	  post POST, team _TEAM_
 	FROM user_post up LEFT JOIN teams t
 	ON up.name=t.user
-	ORDER BY name;"
+	ORDER BY up.name;"
   ## err grpaction: "`echo \"$sql\"`"
   tf=$tmpd/title.$$
   echo "グループ[<a href=\"?grp+$grid\">$htmlgrp</a>]参加メンバーに対する操作" > $tf