بوابة لبذرة

SQL

use arwiki_p;
select page_title,  (select replace(replace(cl_to,"بوابة_",""),"/مقالات_متعلقة","") from categorylinks where cl_from = page_id and cl_to like"%/مقالات_متعلقة" limit 1) from page
inner join categorylinks cl1
on cl1.cl_from = page_id
where cl1.cl_to = "مقالات_بذور_عامة"
and (select concat("بذرة_",replace(replace(cl_to,"بوابة_",""),"/مقالات_متعلقة","")) from categorylinks where cl_from = page_id and cl_to like"%/مقالات_متعلقة") in (
select page_title from page where page_namespace = 10 and page_is_redirect = 0)
limit 50;
SQL

Checking query status...
