SELECT

            p.page_namespace,

            CONVERT(p.page_title USING utf8),

            COUNT(*)

        FROM page AS p

        INNER JOIN imagelinks AS il

        ON il.il_from = p.page_id

        INNER JOIN page as f

        ON il.il_to = f.page_title

        INNER JOIN categorylinks AS cl

        ON cl.cl_from = f.page_id

        WHERE

            f.page_namespace = 6

            AND cl.cl_to = '%s'

        GROUP BY p.page_namespace, p.page_title

        HAVING COUNT(*) > 6

        ORDER BY COUNT(*) DESC;