SELECT 

    tl_title AS "Sjabloonnaam",

    COUNT(tl_from) AS "Aantal verwijzingen"

FROM 

    templatelinks

WHERE 

    tl_namespace = 10

    AND tl_title LIKE "Infobox%"

    AND tl_title NOT LIKE "%/%"

    AND EXISTS (

        SELECT 1

        FROM page

        WHERE 

            page_namespace = 10

            AND page_title = tl_title

            AND NOT EXISTS (

                SELECT 1

                FROM page_props

                WHERE 

                    pp_page = page_id

                    AND pp_propname = "templatedata"

            )

    )

GROUP BY 

    tl_title

ORDER BY 

    COUNT(tl_from) DESC

LIMIT 500;