empty - Quarry

SQL

use arwiki_p;
SELECT DISTINCT concat('تصنيف:' , p1.page_title) as title
, p1.page_namespace as p
FROM page p1
WHERE p1.page_namespace = 14
and p1.page_is_redirect = 0
and p1.page_title like "%_في_الولايات_المتحدة"# or p1.page_title like "الولايات_المتحدة_في_%"

AND NOT EXISTS (SELECT * FROM page p2 WHERE p2.page_title = p1.page_title AND p2.page_namespace = 15 )
/*
and p1.page_title not in ( SELECT p2.page_title FROM page p2 , categorylinks
    WHERE p2.page_namespace = 1
    and p2.page_title = p1.page_title
    and cl_to = "مقالات_مشروع_ويكي_الولايات_المتحدة"
    and cl_from = p2.page_id
    )*/

 limit 15000
SQL

Checking query status...
