הפניות חסרות ספר החוקים הפתוח

SQL

USE hewikisource_p;

SELECT p.page_title, pl.pl_title
FROM (
    SELECT page_id, page_title
    FROM page
    WHERE page_namespace = 0
    AND page_id IN (
        SELECT cl_from
        FROM categorylinks
        WHERE cl_to = 'בוט_חוקים'
    )
) AS p
JOIN (
    SELECT pl_from, pl_title
    FROM pagelinks
    WHERE pl_namespace = 0
) AS pl ON pl.pl_from = p.page_id
LEFT JOIN (
    SELECT page_title, page_namespace, page_id
    FROM page
    WHERE page_namespace = 0 OR page_namespace = 116
) AS p2 ON p2.page_title = pl.pl_title
WHERE p2.page_id IS NULL

ORDER BY pl.pl_title;

SQL

Checking query status...