Qualified pages with many incoming links

This query is marked as a draft This query has been published by Certes.

This query lists titles with 100+ incoming links which might be expected to be in italics or quotes and do not have a dab at the base name,
e.g. Abraham_Lincoln_(1930_film).  Links to the page at the base name which are in italics or quotes may be intended for the qualified name.
To reduce run time, it checks one initial at a time with LIKE "A%(%)" etc.

SQL

SET STATEMENT max_statement_time = 1000 FOR
SELECT pl_title, COUNT(*)
FROM pagelinks
WHERE pl_title LIKE "A%(%)" AND pl_from_namespace = 0 AND pl_namespace = 0
GROUP BY pl_title
HAVING COUNT(*) >= 200
ORDER BY pl_title

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...