Untitled query #28340

SQL

use arwiki_p;
select 
	CONCAT('# [[نقاش:',page.page_title,']]')
from page 
where page_namespace = 1 
and page_id IN (SELECT tl_from FROM templatelinks WHERE tl_title = 'مشروع_ويكي_أعلام') 
and page_id in (select cl_from from categorylinks where cl_to = 'مقالات_أعلام')
and page_id not in (select cl_from from categorylinks where cl_to = 'مقالات_أعلام_بدون_وسيط_حي')
and page_id not in (select cl_from from categorylinks where cl_to = 'مقالات_سير_أشخاص_أحياء')
and page_id in (select cl_from from categorylinks where cl_to = 'مقالات_أعلام_ذكور')

and page_is_redirect = 0
order by page.page_title ASC
LIMIT 100
;
SQL

Checking query status...
