Untitled query #68575

SQL

SELECT 
    page_title,
    count(pl_title)
FROM pagelinks
INNER JOIN page ON pl_from = page_id
WHERE page_namespace = 0
AND page_title NOT LIKE "%ndex%"
AND page_title NOT LIKE "%ist%"
AND page_title NOT LIKE "%_in_%"
    AND page_is_redirect = 0
    AND NOT EXISTS (
        SELECT *
        FROM langlinks AS t
        WHERE t.ll_lang = "ar"
            AND t.ll_from = pagelinks.pl_from)  
INNER JOIN pagelinks ON pl_from = pl_from
WHERE pl_from EXISTS (
        SELECT *
        FROM langlinks AS t
        WHERE t.ll_lang = "ar"
            AND t.ll_from = pagelinks.pl_from) 
GROUP BY pl_from
ORDER BY count(pl_title) DESC,
    page_title limit 500;
SQL

Checking query status...
