Articles and categories

صفحات متشابهة الإسم في المقالة و التصنيف بشرط أن تكون المقالة موجودة في العربية و التصنيف لايكون.
Articles and categories  with same name (without arabic cat's )

SQL

/*use enwiki_p;
SELECT cl_to
FROM page, categorylinks 
WHERE    cl_to IN (
                SELECT page_title FROM page WHERE page_namespace = 0 AND   page_id IN (
                SELECT ll_from
                FROM langlinks
                WHERE ll_lang = "ar"
                ))
AND   cl_to NOT IN (
                SELECT ll_from FROM langlinks WHERE ll_lang = "ar" 
                )
GROUP BY cl_to;
limit 1;*/
use enwiki_p;
SELECT cl_to, (select ll_title from langlinks where ll_from = page_id and ll_lang = 'ar') title_ar
FROM page, categorylinks 
WHERE    cl_to IN (
                SELECT page_title FROM page 
                WHERE page_namespace = 0 
                AND   page_id IN (
                SELECT ll_from
                FROM langlinks
                WHERE ll_lang = "ar"
                ))
AND   cl_to NOT IN (
                SELECT ll_from
                FROM langlinks
                WHERE ll_lang = "ar" 
                )
GROUP BY cl_to  
limit 100;

SQL

Checking query status...