Untitled query #66286

SQL

SELECT
	B.user_name,
	B.edits,
	B.groups,
	B.former_groups,
    B.cl_to
FROM
(
	SELECT
		u.user_name,
		u.user_editcount AS edits,
		GROUP_CONCAT(DISTINCT ug.ug_group) AS groups,
        GROUP_CONCAT(DISTINCT ufg.ufg_group) AS former_groups,
        cl.cl_to
	FROM user u
	LEFT JOIN user_groups ug ON u.user_id = ug.ug_user
	LEFT JOIN user_former_groups ufg ON u.user_id = ufg.ufg_user
    LEFT JOIN page p ON p.page_namespace = 2 AND p.page_title = u.user_name
    LEFT JOIN categorylinks cl ON cl.cl_from = p.page_id AND cl.cl_to = 'OnaysÄ±z_botlar'
	WHERE (ug.ug_group IS NULL OR ug.ug_group <> 'editor')
	GROUP BY u.user_id
	HAVING edits > 0
) B

ORDER BY B.edits DESC
SQL

Checking query status...
