nlwiki Protected user css/js of active non-sysops

SQL

SELECT DISTINCT * FROM recentchanges, actor WHERE rc_actor=actor_id LIMIT 10
/*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)
GROUP BY page_title
LIMIT 10*/

SQL

Checking query status...