Untitled query #74033

SQL

WITH direct AS (SELECT *
                FROM pagelinks AS direct
                LEFT JOIN page on direct.pl_from = page_id AND page_is_redirect = 1 AND page_namespace = 4
                WHERE direct.pl_title = "Naming_conventions_(ancient_Romans)" 
                AND direct.pl_namespace = 4
)

#SELECT direct.pl_title
#FROM direct
#LEFT JOIN pagelinks AS indirect ON direct.page_title = indirect.pl_title
#WHERE indirect.pl_namespace = 4
#AND direct.page_id IS NOT NULL
#UNION ALL
#SELECT pl_title
#FROM direct
#WHERE direct.page_id IS NULL

SELECT * from direct
SQL

Checking query status...
