Untitled query #31418

SQL

use arwiki_p;
select 
	CONCAT('# [[نقاش:',page.page_title,']]') AS "تعارض بذرة وبداية"
from page 
where page_namespace = 1
and page.page_id in (select cl_from from categorylinks where cl_to REGEXP 'مقالات_(.*)_ذات_صنف_بذرة') 
and (page.page_id in (select cl_from from categorylinks where cl_to REGEXP 'مقالات_(.*)_ذات_صنف_ب')
     or page.page_id in (select cl_from from categorylinks where cl_to REGEXP 'مقالات_(.*)_ذات_صنف_ج')) 
and page_is_redirect = 0 
order by page.page_title ASC
LIMIT 100;
SQL

Checking query status...
