بوابة لبذرة

SQL

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"%/مقالات_متعلقة" limit 1) in (
select page_title from page where page_namespace = 10);
SQL

Checking query status...
