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

SQL

AخA
 
USE tewiki_p;
SELECT CONCAT("మూస:",SUBSTRING_INDEX(templates.page_title, '/', 1)), GROUP_CONCAT(DISTINCT pl_title SEPARATOR ", ") AS disambigs,
    COUNT(DISTINCT tl_from) AS uses
    FROM page_props
    JOIN page AS pages
        ON pages.page_id = pp_page
    JOIN pagelinks
        ON pl_title = pages.page_title AND pl_namespace = pages.page_namespace
    JOIN page AS templates
        ON templates.page_id = pl_from
    LEFT JOIN templatelinks
        ON tl_title = templates.page_title AND tl_namespace = templates.page_namespace
WHERE pp_propname = 'disambiguation' AND tl_from_namespace = 0
GROUP BY pl_from, SUBSTRING_INDEX(templates.page_title, '/', 1)
ORDER BY COUNT(DISTINCT pl_title) DESC, uses DESC, templates.page_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
All SQL code is licensed under CC0 License.

Checking query status...