SQL
AخA
SELECT edit.pr_level, edit.pr_expiry = 'infinity' AS 'indefinite?', COUNT(*)
FROM page_restrictions AS edit
LEFT JOIN page_restrictions AS move ON move.pr_page = edit.pr_page AND move.pr_type = 'move'
JOIN page ON page_id = edit.pr_page
WHERE edit.pr_type = 'edit'
AND move.pr_page IS NULL
GROUP BY edit.pr_level, edit.pr_expiry = 'infinity';
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.