Cycling wikiproject

SQL

use arwiki_p;
SELECT DISTINCT p1.page_title , p1.page_namespace
FROM page p1
WHERE p1.page_is_redirect = 0
and p1.page_namespace = 0 

#AND NOT EXISTS (SELECT * FROM page p2 WHERE p2.page_title = p1.page_title AND p2.page_namespace = 1 ) #or  p2.page_namespace = 15

and p1.page_id  in (SELECT tl_from FROM templatelinks WHERE tl_title  = 'Cycling_race' AND tl_namespace = 828)
AND NOT EXISTS (
    SELECT * FROM page p2 , categorylinks 
    WHERE p2.page_title = p1.page_title 
    AND p2.page_namespace = 1
    and cl_to = "مقالات_مشروع_ويكي_ركوب_الدراجات"
    and cl_from = p2.page_id
    )
SQL

Checking query status...
