List of PlayStation 2 games that aren't games

SQL

WITH links AS (WITH article AS (SELECT page_id AS article_id, page_title AS article_title
                 FROM page WHERE page_namespace = 0 AND page_title = "List_of_PlayStation_2_games_(L–Z)")
               SELECT article_title AS al_title, pl_title AS link_title, page_id AS link_id
               FROM article, pagelinks
               JOIN page ON page_title = pl_title AND page_is_redirect = 0
               WHERE pl_from_namespace = 0 AND pl_from = article_id AND pl_namespace = 0 AND page_namespace = 0)
SELECT al_title, link_title
FROM links
WHERE NOT EXISTS (SELECT 1 FROM categorylinks WHERE cl_from = link_id AND cl_to REGEXP "Playstation|[Gg]ame")
AND NOT EXISTS (SELECT 1 FROM redirect, page, categorylinks 
                WHERE rd_from = link_id AND page_namespace = 0 AND page_title = rd_title AND cl_from = page_id AND cl_to REGEXP "Playstation|[Gg]ame")
ORDER BY al_title, link_title
SQL

Checking query status...
