SELECT wp_users.ID FROM wp_users LEFT JOIN wp_usermeta ON wp_users.ID = wp_usermeta.user_id WHERE meta_key LIKE 'wp_capabilities' AND meta_value LIKE '%subscriber%' AND DATEDIFF(CURDATE(), wp_users.user_registered) >= 1

Warning: Cannot modify header information - headers already sent by (output started at /home/content/08/8457608/html/wp-content/plugins/auto-delete-user/includes/frontend/frontend.php:28) in /home/content/08/8457608/html/wp-includes/pluggable.php on line 1179