From 6163dccab341ae2d3ec7885224f512b99ca48b02 Mon Sep 17 00:00:00 2001 From: rub Date: Thu, 9 Mar 2006 23:03:57 +0000 Subject: [NBM] Correction of sub-select query (remark about r1070) git-svn-id: http://piwigo.org/svn/trunk@1074 68402e56-0260-453c-a942-63ccdbb3a9ee --- admin/mailtousers.php | 8 ++++---- 1 file 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;'; -- cgit v1.2.3