System had some dramatic Meeting record duplication after using the Outlook plugin plus and an Exchange integration at the same time. Luckily, the duplicate records seem to match exactly on the name and date_start, so we have something solid to merge off of.

MLCMI Meeting Cleanup

-- create a temp table to house dup'd ids
create table `meetings_dup_ids` (
`id` varchar(36) NOT NULL,
PRIMARY KEY (`id`)
);

-- copy the dup IDs into the temp table...
insert into meetings_dup_ids(id)
select distinct(one.id) from meetings one
    join meetings two on one.name = two.name and one.date_start=two.date_start
    and two.deleted = 0
    where one.deleted = 0;

-- select duplicated groups with min/max start date and a total 'dupes'
-- select id,name,
-- max(date_start) as max,min(date_start) as min,
-- count(*) as dups from meetings
-- where meetings.deleted = 0
-- group by name
-- order by dups desc;

-- the wrapup, showing only dups with matching datestamps
-- select * from
-- (
--     select id,name,
--     max(date_start) as max,min(date_start) as min,
--     count(*) as dups from meetings
--     where meetings.deleted = 0
--     group by name
--     order by dups desc
-- ) as sub
-- where sub.max = sub.min and sub.dups > 1;

-- the re-wrapped update sets deleted=2, which means 'save me!'
update meetings set deleted=2 where id in
(
    select id from
    (
        select id,name,
        max(date_start) as max,min(date_start) as min,
        count(*) as dups from meetings
        where meetings.deleted = 0
        group by name
        order by dups desc
    ) as sub
    where sub.max = sub.min and sub.dups > 1
);

-- the re-wrapped update that actually soft-deletes things...
update meetings 
set deleted=1 where deleted=0 and id in 
(
    select id from meetings_dup_ids
);

-- and re-activate the '2' group
update meetings set deleted=0 where deleted=2;

-- and see what we have now
-- select * from meetings where deleted = 0;

-- drop that temp table
drop table `meetings_dup_ids`;

Will, I think you are/were right the first time. The definition of these duplicates is same name + same start date/time. We've pushed back to the customer to show us real duplicates using that definition in the test instance. They had a guy out of town late last week, so we're just waiting on them to approve before we go live.

Matthew,

Sounds good. Keep us posted. I'll be checking in periodically.

Thanks

Matthew,

I ran the update queries. Please confirm with the customer and Tim when everything is verified.

Thanks and take care,

Will