DELETE AbpUserRoles WHERE Id IN (

SELECT AUR.Id FROM AbpUserRoles AUR WHERE AUR.UserId  IN (

SELECT B.UserId
FROM TL_USER A
LEFT JOIN AbpUserRoles B ON A.ID = B.UserId
WHERE B.CreatorUserId <> 0
GROUP BY B.UserId,B.RoleId
HAVING COUNT(*) > 1 )
AND AUR.CreatorUserId <> 0
)

DELETE AbpUserRoles WHERE Id IN (

SELECT AUR.Id FROM AbpUserRoles AUR WHERE AUR.UserId  IN (

SELECT B.UserId
FROM TL_USER A
LEFT JOIN AbpUserRoles B ON A.ID = B.UserId
GROUP BY B.UserId,B.RoleId
HAVING COUNT(*) > 1 )
AND AUR.CreatorUserId <> 0
--ORDER BY AUR.UserId

)