User:Certes/Reports/Disambiguation pages with links

List disambiguation pages with incoming links from namespace 0, ordered by link count (highest first), from quarry:query/78416

{{Database report

|sql=

WITH dabs_and_redirects AS (

WITH dabs AS (

SELECT page_title AS dab

FROM categorylinks

JOIN page ON page_id=cl_from AND page_namespace=0 AND page_title NOT LIKE "%_(disambiguation)"

WHERE cl_to="All_disambiguation_pages" AND cl_type='page'

)

SELECT dab, dab AS target FROM dabs

UNION

SELECT dab, page_title

FROM dabs

JOIN redirect ON rd_namespace=0 AND rd_title=dab

JOIN page ON page_id=rd_from AND page_namespace=0 AND page_title NOT LIKE "%_(disambiguation)"

)

SELECT dab, COUNT(*) AS links, CONCAT("[","[Special:Whatlinkshere/",dab,"{{!}}list]","]") AS list

FROM dabs_and_redirects

JOIN pagelinks ON pl_namespace=0 AND pl_title=target AND pl_from_namespace=0

JOIN page ON page_id=pl_from AND page_namespace=0 AND page_is_redirect=0

GROUP BY dab

ORDER BY links DESC, dab

|wikilinks= 1

|excerpts=

|comments=

|interval=

|table_style=

|pagination=

|max_pages=

}}

{{error|1=[SQL Error: ER_BAD_FIELD_ERROR: Unknown column 'pl_namespace' in 'on clause' – Consider using [https://quarry.wmflabs.org/ Quarry] to to test your SQL.]}}