صفحات نقاش موجودة لتحويلات

SQL

use arwiki_p;
SELECT p.page_title, group_concat(el.ll_title)
FROM page p
INNER JOIN langlinks l1 ON l1.ll_from = p.page_id
INNER JOIN enwiki_p.page frpage ON (frpage.page_title) = (replace(l1.ll_title, " ", "_"))
INNER JOIN enwiki_p.templatelinks frtemp ON frtemp.tl_from = frpage.page_id
INNER JOIN enwiki_p.page p2 ON (p2.page_title) = frtemp.tl_title
INNER JOIN enwiki_p.langlinks el ON p2.page_id = el.ll_from
INNER JOIN page p3 ON p3.page_title = el.ll_title
WHERE p.page_is_redirect = 0
  AND p.page_namespace =0
  AND frpage.page_namespace = 0
  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 = 0
  AND frtemp.tl_namespace = 10
  AND el.ll_lang LIKE "ar"
  and frtemp.tl_title like "WikiProject%"
  AND l1.ll_lang LIKE "en"
  group by p.page_title
  limit 20;
SQL

Checking query status...
