Untitled query #80162

SQL

-- Liste finale des pages liées à César_du_meilleur_film, excluant celles liées par la palette César_du_cinéma
SELECT DISTINCT page_cesar.page_title
FROM (
    SELECT DISTINCT page.page_title
    FROM page
    JOIN pagelinks ON page.page_id = pagelinks.pl_from
    WHERE pagelinks.pl_title = 'César_du_meilleur_film'
    AND pagelinks.pl_namespace = 0
    AND pagelinks.pl_from_namespace = 0
) AS page_cesar
LEFT JOIN (
    SELECT DISTINCT page.page_title
    FROM page
    JOIN pagelinks ON page.page_id = pagelinks.pl_from
    WHERE pagelinks.pl_title = 'Palette_César_du_cinéma'
    AND pagelinks.pl_namespace = 0
    AND pagelinks.pl_from_namespace = 0
) AS page_palette ON page_cesar.page_title = page_palette.page_title
WHERE page_palette.page_title IS NULL;
SQL

Checking query status...
