# HG changeset patch
# User HIROSE Yuuji <yuuji@gentei.org>
# Date 1551849353 -32400
# Node ID 145fb3cca3fbd8d92736420a5560a43f5a213ec5
# Parent  36c4d7ea464d66d237a3a82056577945b2c57e42
User email values are in user_m, not user_s.

diff -r 36c4d7ea464d -r 145fb3cca3fb s4-funcs.sh
--- a/s4-funcs.sh	Mon Jan 14 02:10:34 2019 +0900
+++ b/s4-funcs.sh	Wed Mar 06 14:15:53 2019 +0900
@@ -1282,9 +1282,9 @@
 	useremails AS (
 	  SELECT user.rowid rid, user.name, val email
 	  FROM user
-	       LEFT JOIN user_s
-	       ON user.name=user_s.name AND user_s.key='email')
-	SELECT DISTINCT coalesce(g.email, u.name)
+	       LEFT JOIN user_m
+	       ON user.name=user_m.name AND user_m.key='email')
+	SELECT DISTINCT coalesce(g.email, u.email, u.name)
 	FROM  useremails u LEFT JOIN grpemails g
 	      ON u.name=g.user
 	WHERE u.rid in ($uids);"