Untitled query #78434

SQL

SELECT
    p.page_title,
    GROUP_CONCAT(REPLACE(red_links.pl_title, '_', ' ') SEPARATOR ',') AS red_links
FROM
    page AS p
JOIN pagelinks AS red_links ON (red_links.pl_from = p.page_id)
JOIN categorylinks AS cl ON (p.page_id = cl.cl_from)
WHERE p.page_is_redirect = 0
AND p.page_namespace = 0
AND cl_to = "جميع_صفحات_توضيح_المقالات"
AND red_links.pl_title NOT IN (
    SELECT red_page.page_title
    FROM page AS red_page
WHERE red_page.page_namespace = 0)
AND red_links.pl_namespace = 0
GROUP BY p.page_title;
SQL

Checking query status...
