articles_in_which_there_is_a_link_to_user_pages

SQL

SELECT cl_to, COUNT(cl_from) AS editcount
FROM (
    SELECT cl_to, cl_from
    FROM categorylinks
    WHERE cl_to NOT LIKE '%rticle%'
    AND cl_to NOT LIKE '%ages%'
    AND cl_to NOT LIKE '%All%'
    AND cl_to NOT LIKE '%using%'
    AND cl_to NOT LIKE '%Good%'
) AS cl
INNER JOIN (
    SELECT DISTINCT ll_from
    FROM langlinks
    WHERE ll_lang = 'ar'
) AS ll ON cl.cl_from = ll.ll_from
WHERE cl.cl_to NOT IN (
    SELECT DISTINCT page_title
    FROM langlinks
    LEFT JOIN page ON page_id = ll_from
    WHERE ll_lang = 'ar'
    AND page_namespace = 14
)
GROUP BY cl_to
ORDER BY editcount DESC
LIMIT 10;

SQL

Checking query status...