Untitled query #54693

SQL

SET @noedit = (SELECT COUNT(*)
FROM user_groups
LEFT JOIN user ON ug_user = user_id
WHERE ug_group = 'ipblock-exempt'
	AND user_registration < DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 14 DAY), '%Y%m%d%H%i%s')
	AND user_registration > DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 104 DAY), '%Y%m%d%H%i%s')
    AND user_editcount = 0);

SET @all = (SELECT COUNT(*)
FROM user_groups
LEFT JOIN user ON ug_user = user_id
WHERE ug_group = 'ipblock-exempt'
	AND user_registration < DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 14 DAY), '%Y%m%d%H%i%s')
    AND user_registration > DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 104 DAY), '%Y%m%d%H%i%s'));

SELECT @noedit, @all, @noedit / @all;

SELECT user_id, user_name, user_editcount, user_registration
FROM user_groups
LEFT JOIN user ON ug_user = user_id
WHERE ug_group = 'ipblock-exempt'
	AND user_registration < DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 14 DAY), '%Y%m%d%H%i%s')
	AND user_registration > DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 104 DAY), '%Y%m%d%H%i%s');
SQL

Checking query status...
