• So i ended up going with a union query that syncs grouped by carbon_copy_id and one without and it seems to be doing the job.

    Thanks guys for getting me this far.