Drupal Delete Spam Accounts

 <?

// Since when did mysql start supporting subqueries

$result = db_query('select uid from users where uid not in (
7077,8842,8304,8558,3975,5756
) and uid not in (
select distinct uid from node
) and uid not in (
select distinct uid from comment
) and uid not in (
select distinct uid from users where picture > 0
) and uid not in (
select distinct uid from profile_value
) and uid not in (
select distinct uid from commerce_order
) and uid not in (
select distinct entity_id from field_data_field_stock_watchlist
)');

foreach ($result as $record)
   if ($record->uid > 6) user_delete($record->uid);

?>