SELECT 
    `aid, COUNT(aid),
    `email`,      COUNT(email)
FROM
    `cam_test`
GROUP BY 
    `aid` ,  
    `email`
HAVING  COUNT(aid) > 1
    AND COUNT(email) > 1;
    

DELETE z.* 
  FROM `cam_test` AS w
  JOIN `cam_test` AS z ON z.aid = w.aid
                  AND z.email = w.email
                  AND z.id > w.id -- or what primary key you have
;