nlwiki Protected user css/js of active non-sysops

SQL

/*SELECT
	page_title,
    GROUP_CONCAT(DISTINCT pr_type) AS pr_type,
    GROUP_CONCAT(DISTINCT pr_level) AS pr_level,
    GROUP_CONCAT(DISTINCT pr_cascade) AS pr_cascade,
    GROUP_CONCAT(DISTINCT pr_user) AS pr_user,
    GROUP_CONCAT(DISTINCT pr_expiry) AS pr_expiry
FROM page, page_restrictions, `user`
WHERE
	page_namespace=2 AND
    page_title REGEXP '/[^/]+\\.(css|js)$' AND
    page_id=pr_page AND
    REGEXP_REPLACE(page_title, '/.*', '')=REPLACE(user_name, ' ', '_') AND
    EXISTS (SELECT DISTINCT * FROM recentchanges, actor WHERE rc_actor=actor_id AND actor_user=user_id) AND
    NOT EXISTS (SELECT * FROM user_groups WHERE ug_user=user_id AND ug_group='sysop')
GROUP BY page_title
LIMIT 100*/

SELECT * FROM recentchanges WHERE rc_actor=61732
SQL

Checking query status...
