Unneeded confirmed rights

SQL

# wiki: days/edits
# default: 4/0
# wikidata: 4/50
SET @days = 4;
SET @edits = 50;

SELECT ug.ug_user, ug.ug_expiry, u.user_id, u.user_name, u.user_registration, u.user_editcount
FROM user_groups ug
JOIN user u
	ON ug.ug_user = u.user_id
WHERE ug.ug_group = 'confirmed'
AND u.user_registration < (DATE_FORMAT((NOW() - INTERVAL @days DAY),'%Y%m%d%H%i%S'))
AND u.user_editcount >= @edits;

SELECT ug.*, u.user_name
FROM user_groups ug
JOIN user u
	ON ug.ug_user = u.user_id
WHERE (
	u.user_name LIKE 'Vanish%' OR
	u.user_name LIKE 'Rename%'
);
SQL

Checking query status...
