Meta users with extra local autopatrol

This query is marked as a draft This query has been published by DannyS712.

SQL

USE metawiki_p;

SELECT
	*
FROM
	user_groups ug
JOIN (
	SELECT
		other.ug_user AS user_id,
		GROUP_CONCAT(
			CONCAT(
				other.ug_group,
				CASE
					WHEN other.ug_expiry IS NOT NULL THEN CONCAT('-', other.ug_expiry )
					ELSE ''
				END
    		)
	    ) AS user_groups
	FROM
		user_groups other
	WHERE
		other.ug_group <> 'autopatrolled'
	GROUP BY ug.ug_user
) AS other_groups
ON
	ug.ug_user = other_groups.user_id
WHERE
	ug.ug_group = 'autopatrolled'
LIMIT 1000;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...