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"));