code:

---

declare @tbl table
(id int)

-- filter messages to be deleted by date
/*
insert into @tbl
 select id from arc where [date]<'2005-09-20'
*/

-- filter messages to be deleted by subject
/*
insert into @tbl
 select id from arc where full_subject like 'xx%'
*/

-- filter messages to be deleted by email (sender/recipient)
/*
insert into @tbl
 select id from arc_add where email='test@testdomain.com'
*/

-- filter messages to be deleted by owner (use objectGuid from Active Directory)
/*
insert into @tbl
 select id from arc_owners inner join arc_users on arc_owners.usrid=arc_users.usrid
  where [name]='d0fba5f09c43be41ba93dcea92767204'
*/

-- filter messages to be deleted by message-id
/*
insert into @tbl
 select id from arc where message_id = '<001201c5bdeb$182a3270$3200a8c0@testdomain.com>'
*/

delete from arc_sources where id in (select id from @tbl)
delete from arc_bodies where id in (select id from @tbl)
delete from arc_att where id in (select id from @tbl)
delete from arc_add where id in (select id from @tbl)
delete from arc_owners where id in (select id from @tbl)
delete from arc where id in (select id from @tbl)

delete from arc_threads
 where NOT EXISTS(select id from arc where thread_id=arc_threads.thread_id)

---

insert into @tbl
select id from arc where 
exists (select id from arc_add where id=arc.id and email='fred@happy.com' and type in (0,3)) 
and 
exists (select id from arc_add where id=arc.id and email='jerry@happy.com' and type in (1,2,4))