البوابات المعادلة الفرنسية

SQL

use arwiki_p;
SELECT p.page_title, p3.page_title,
       group_concat(el.ll_title SEPARATOR '***') AS ll_title
FROM page p
INNER JOIN langlinks l1 ON l1.ll_from = p.page_id
INNER JOIN frwiki_p.page frpage ON (frpage.page_title) = (replace(l1.ll_title, " ", "_"))
INNER JOIN frwiki_p.templatelinks frtemp ON frtemp.tl_from = frpage.page_id
INNER JOIN frwiki_p.page p2 ON (p2.page_title) = (replace(frtemp.tl_title, "Portail_", ""))
INNER JOIN frwiki_p.langlinks el ON p2.page_id = el.ll_from
INNER JOIN page p3 ON p3.page_title = replace(replace(el.ll_title, "بوابة:", ""), " ", "_")
WHERE p.page_is_redirect = 0
  AND p.page_namespace =14
  AND frpage.page_namespace = 14
  AND frpage.page_is_redirect = 0
  AND p2.page_is_redirect = 0
  AND p2.page_namespace = 100
  AND p3.page_namespace = 100
  AND p3.page_is_redirect = 0
  AND frtemp.tl_from_namespace = 14
  AND frtemp.tl_namespace = 10
  AND el.ll_lang LIKE "ar"
  AND frtemp.tl_title LIKE "Portail%"
  AND p.page_id NOT IN
    (SELECT cl_from
     FROM categorylinks
     WHERE cl_to = concat("بوابة_", p3.page_title, "/مقالات_متعلقة"))
  AND l1.ll_lang LIKE "fr"
  AND p.page_title NOT IN
    (SELECT cl_from
     FROM categorylinks
     WHERE cl_to LIKE "%صفحات_توضيح%"
       AND cl_from = p.page_title)
  AND p.page_title NOT IN
    (SELECT cl_from
     FROM categorylinks
     WHERE cl_to LIKE "%الصفحات_التي_لا_تقبل_ربط_البوابات_المعادل%"
       AND cl_from = p.page_title)
  AND el.ll_title not like "%مثلية%" and el.ll_title not like "%إرهاب%"
GROUP BY p.page_title;
SQL

Checking query status...
