DELETE FROM pligg_links WHERE link_status = 'queued';

DELETE FROM pligg_links WHERE link_status = 'discard';

DELETE FROM pligg_links WHERE link_status = 'spam';

DELETE FROM pligg_comments WHERE comment_status = 'spam';

UPDATE 
	pligg_users
SET
	user_level = 'Spammer',
	user_enabled = '0'
WHERE 
	pligg_users.user_id NOT IN ( SELECT link_author FROM pligg_links )
	AND pligg_users.user_id NOT IN ( SELECT comment_user_id FROM pligg_comments )
	#AND pligg_users.user_id NOT IN ( SELECT vote_user_id FROM pligg_votes )
	AND pligg_users.user_level <>'god'
	AND pligg_users.user_level <>'admin';

DELETE pligg_votes.* FROM pligg_votes INNER JOIN pligg_users ON pligg_users.user_id = pligg_votes.vote_user_id
WHERE pligg_users.user_level = 'Spammer';