USE wikidatawiki_p;

​

SELECT COUNT(*) AS count, ips_site_page AS language

FROM wb_items_per_site

WHERE ips_site_id = 'enwiki' AND ips_item_id IN (

    SELECT ips_item_id FROM wb_items_per_site WHERE ips_site_id = 'enwiki' AND ips_item_id IN (

        SELECT DISTINCT iri FROM wb_property_info WHERE propname = 'P1412'

    )

)

GROUP BY ips_site_page

ORDER BY count DESC

LIMIT 10;