transclusioncount

SQL

SELECT
        tl_namespace,
        tl_title,
        links,
        page_id,
        pr1.pr_level AS edit_level,
        pr1.pr_expiry AS edit_expiry,
        pr2.pr_level AS move_level,
        pr2.pr_expiry AS move_expiry,
        pt_create_perm,
        pt_expiry
    FROM (
        SELECT
        tl_namespace,
        tl_title,
        COUNT(*) AS links
        FROM templatelinks
        GROUP BY tl_namespace, tl_title
        HAVING links >= 500
    ) templatelinks
    LEFT JOIN page ON tl_namespace = page_namespace AND tl_title = page_title
    LEFT JOIN page_restrictions AS pr1 ON page_id = pr1.pr_page AND pr1.pr_type = 'edit'
    LEFT JOIN page_restrictions AS pr2 ON page_id = pr2.pr_page AND pr2.pr_type = 'move'
    LEFT JOIN protected_titles ON page_id IS NULL AND tl_namespace = pt_namespace AND tl_title = pt_title
SQL

Checking query status...
