Untitled query #11145

SQL

USE fawiki_p;
SELECT DISTINCT CONCAT (
        '#[[',
        page_title,
        ']]'
        )
FROM categorylinks
INNER JOIN page
WHERE cl_from = page_id
    AND page_namespace = 0
    AND cl_to NOT IN (
        SELECT page_title
        FROM categorylinks
        INNER JOIN page
        WHERE cl_from = page_id
            AND cl_to like "%افراد زنده%" or cl_to like "%افراد_زنده%"
            AND page_namespace = 14
        )
    AND cl_to NOT IN (
        SELECT page_title
        FROM categorylinks
        INNER JOIN page
        WHERE cl_from = page_id
            AND cl_to like "%زاده‌گان%"
            AND page_namespace = 14
        );
SQL

Checking query status...
