delete from cims_projects_users_roles a where rowid not in (select min(b.rowid) from cims_projects_users_roles b
where a.cims_projects_id=b.cims_projects_id and a.cims_users_id = b.cims_users_id and a.cims_roles_id = b.cims_roles_id);
where a.cims_projects_id=b.cims_projects_id and a.cims_users_id = b.cims_users_id and a.cims_roles_id = b.cims_roles_id);