Untitled query #76026

SQL

SELECT
    page.page_title,
    GROUP_CONCAT(CONCAT('\n[[تصنيف:',REPLACE(categorylinks.cl_to, '_', ' '),']]') SEPARATOR ',') AS categories
FROM
    categorylinks
JOIN
    page ON page.page_id = categorylinks.cl_from
WHERE
    cl_to IN (
        SELECT CONCAT('بوابة_',main.page_title)
        FROM page AS p
        INNER JOIN (
            SELECT page_title
            FROM page 
            WHERE page_namespace = 100 
            AND page_is_redirect = 0
        ) AS main ON main.page_title = SUBSTRING_INDEX(p.page_title, '/', 1)
        WHERE p.page_namespace = 100
    )
    AND page.page_namespace = 0
GROUP BY
    page.page_title;
SQL

Checking query status...
