query("SELECT user, vaid FROM admin WHERE user not in (select distinct uid from userlog) AND DATE_SUB(NOW(), INTERVAL 12 Month) > registriert AND DATE_SUB(NOW(), INTERVAL 30 DAY) > mail_inaktiv AND mail_inaktiv != '0000-00-00 00:00:00' AND inaktiv!='J'"); while ($row = $result_abs->fetch_array()){ $sql = $db->query("DELETE FROM profil WHERE user='$row[user]'"); $sql = $db->query("DELETE FROM admin_rollen_user_zuord WHERE vaid='$row[vaid]'"); $sql = $db->query("DELETE FROM admin WHERE vaid='$row[vaid]'"); } ?>