Changeset 1074

Timestamp:

Mar 10, 2006, 12:03:57 AM (18 years ago)

Author:

rub

Message:

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

File:

• trunk/admin/mailtousers.php (modified) (1 diff)

trunk/admin/mailtousers.php

@@ -97 +97 @@
   $query = '
 select
-  id user_id, username, mail_address
+  u.id user_id, u.username, u.mail_address
 from
-  '.USERS_TABLE.'
-where
-  mail_address is not null and 
-  id not in (select user_id from '.USER_MAIL_NOTIFICATION_TABLE.')
+  '.USERS_TABLE.' as u left join '.USER_MAIL_NOTIFICATION_TABLE.' as m on u.id = m.user_id
+where
+  u.mail_address is not null and
+  m.user_id is null
 order by
   id;';