Do share!
update dbmail_messages set status=3 where message_idnr in (select message_idnr from dbmail_users as a join dbmail_mailboxes as b on a.user_idnr=b.owner_idnr join dbmail_messages as c on c.mailbox_idnr=b.mailbox_idnr where curmail_size > 1000000 and last_login < (now() - interval '2 month') and status<>3 limit 80000);
This is the one. _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
