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