English Wikipedia portals by age and number of edits, editors

This query takes all pages in the Portal namespace and aggregates them by base page name (the name before the first slash), then it aggregates the timestamps and username for all the corresponding revisions. It helps find portals which, in aggregate, have very few edits and/or editors (either in total or relative to their age since creation), or where the average revision is very old.

In some cases the results are produced by subpages which were left lingering after the actual portal was deleted or redirected. Such subpages may need to be redirected or speedy deleted themselves.

SQL

Checking query status...