Early morning SQLite
I hope I don’t regret this later:
sqlite> delete from messages
where mailbox =
(select ROWID from mailboxes where url = "local:///ARCHIVE06")
and message_id in
(select message_id from messages where mailbox =
(select ROWID from mailboxes
where url = "imap://bjepson@remote mailbox/ARCHIVE06″));