Untitled query #37612

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) AS "stub"
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...
