Untitled query #24200

SQL

USE kowiki_p;
SELECT user_name,
	user_editcount,
	LEFT(user_registration,4) AS reg,
	MAX(dc.day) AS last_edit,
	GROUP_CONCAT(DISTINCT ug_group SEPARATOR ' ') AS grps,
	CONCAT(ipb_expiry, ' &mdash; ', ipb_reason) AS block
FROM user u
LEFT JOIN user_daily_contribs dc ON dc.user_id=u.user_id
	AND dc.day>DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -180 DAY), "%Y-%m-%d")
LEFT JOIN user_groups ON u.user_id=ug_user
LEFT JOIN ipblocks ON ipb_user=u.user_id
WHERE user_editcount>=5000
GROUP BY user_name
HAVING MAX(dc.day)!="None"
ORDER BY user_editcount DESC;
SQL

Checking query status...
