USE wikidatawiki_p;

​

SELECT

    pl_title,

    COUNT(*) 

FROM

    pagelinks LEFT JOIN page ON pl_title=page_title AND pl_namespace=page_namespace

WHERE

    pl_from_namespace IN (0, 120, 146)

    AND pl_namespace IN (0, 120, 146)

    AND page_id IS NULL

GROUP BY

    pl_title

ORDER BY

    COUNT(*) DESC, pl_namespace, pl_title;