s4
changeset 507:145fb3cca3fb
User email values are in user_m, not user_s.
| author | HIROSE Yuuji <yuuji@gentei.org> |
|---|---|
| date | Wed, 06 Mar 2019 14:15:53 +0900 |
| parents | 36c4d7ea464d |
| children | 944739c3ac5c |
| files | s4-funcs.sh |
| diffstat | 1 files changed, 3 insertions(+), 3 deletions(-) [+] |
line diff
1.1 --- a/s4-funcs.sh Mon Jan 14 02:10:34 2019 +0900 1.2 +++ b/s4-funcs.sh Wed Mar 06 14:15:53 2019 +0900 1.3 @@ -1282,9 +1282,9 @@ 1.4 useremails AS ( 1.5 SELECT user.rowid rid, user.name, val email 1.6 FROM user 1.7 - LEFT JOIN user_s 1.8 - ON user.name=user_s.name AND user_s.key='email') 1.9 - SELECT DISTINCT coalesce(g.email, u.name) 1.10 + LEFT JOIN user_m 1.11 + ON user.name=user_m.name AND user_m.key='email') 1.12 + SELECT DISTINCT coalesce(g.email, u.email, u.name) 1.13 FROM useremails u LEFT JOIN grpemails g 1.14 ON u.name=g.user 1.15 WHERE u.rid in ($uids);"