[NBM] Correction of sub-select query (remark about r1070)

git-svn-id: http://piwigo.org/svn/trunk@1074 68402e56-0260-453c-a942-63ccdbb3a9ee

1 files changed, 4 insertions, 4 deletions

diff --git a/admin/mailtousers.php b/admin/mailtousers.php
index 2ed9e3158..c2539a398 100644
--- a/admin/mailtousers.php
+++ b/admin/mailtousers.php
@@ -96,12 +96,12 @@ where
 
   $query = '
 select
-  id user_id, username, mail_address
+  u.id user_id, u.username, u.mail_address
 from
-  '.USERS_TABLE.'
+  '.USERS_TABLE.' as u left join '.USER_MAIL_NOTIFICATION_TABLE.' as m on u.id = m.user_id
 where
-  mail_address is not null and 
-  id not in (select user_id from '.USER_MAIL_NOTIFICATION_TABLE.')
+  u.mail_address is not null and
+  m.user_id is null
 order by
   id;';