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 pagelinks
               JOIN page ON page_title = pl_title AND page_is_redirect = 0
               WHERE pl_from_namespace = 0 AND pl_from = article.page_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 IN 
                ("PlayStation_2_games", "Video_game_publishers", "Video_game_development_companies"))
ORDER BY al_title, link_title
SQL

Checking query status...
