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"%/مقالات_متعلقة" limit 1) in (

select page_title from page where page_namespace = 10 and page_is_redirect = 0)

limit 50;