select
    count(*), page_namespace, page_title
from
    pagelinks
inner join
    (select * from page inner join categorylinks on cl_from=page_id where cl_to='English_language_movies') as foo on pl_from=foo.page_id
where
    (pl_title, pl_namespace) in (select page_title, page_namespace from page inner join categorylinks on cl_from=page_id where cl_to='English_language_movies')
    and page_namespace=0 group by page_title, page_namespace order by count desc limit 10;