Fork of
Most locked pages
by DHN
This query is marked as a draft
This query has been published
by NgocAnMaster.
SQL
AخA
SELECT
log_namespace AS namespace,
log_title AS protected_page,
COUNT(log_title) AS occurrences,
MAX(log_timestamp) AS latest_occurence
FROM logging
WHERE log_type = "protect"
GROUP BY namespace, protected_page
ORDER BY occurrences DESC
LIMIT 5000;
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.