Untitled query #80163

SQL

-- Liste finale des pages liées à César_du_meilleur_film, excluant celles dont le titre commence par "Palette"
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 LIKE 'Palette Oscar du meilleur film'
    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...
