SELECT 

    lt_title AS "Sjabloonnaam",

    COUNT(tl_from) AS "Aantal verwijzingen"

FROM 

    templatelinks JOIN linktarget ON tl_target_id = lt_id

WHERE 

    lt_namespace = 10

    AND lt_title NOT LIKE "%/%"

    AND EXISTS (

        SELECT 1

        FROM page

        WHERE 

            page_namespace = 10

            AND page_title = lt_title

            AND page_is_redirect = 0

            AND NOT EXISTS (

                SELECT 1

                FROM page_props

                WHERE 

                    pp_page = page_id

                    AND pp_propname = "templatedata"

            )

    )

GROUP BY 

    lt_title

ORDER BY 

    COUNT(tl_from) DESC

LIMIT 500;