Here's a simple query for anyone who didn't already know this.
DELETE FROM accounts WHERE lastip = '0.0.0.0'
It deletes every account in the accounts table with the lastip of 0.0.0.0
If the account has the IP 0.0.0.0 that means it has never been logged into.
DELETE FROM accounts WHERE lastip = '0.0.0.0'
It deletes every account in the accounts table with the lastip of 0.0.0.0
If the account has the IP 0.0.0.0 that means it has never been logged into.