Queries Tester

SQL

SELECT page.page_id, page.page_title, page.page_is_redirect AS "RD", rd_from, rd.page_title AS rd_page_title, rd_fragment, cl_sortkey_prefix
FROM page
LEFT JOIN redirect ON rd_namespace=page.page_namespace AND rd_title=page.page_title
LEFT JOIN page AS rd ON rd.page_id=rd_from AND rd.page_namespace=0
JOIN categorylinks ON cl_from = page.page_id

WHERE page.page_namespace=0 AND cl_to IN (
  "Arcade_games", "Atari_arcade_games","Sega_arcade_games","Arcade-only_games",
  "PlayChoice-10_games","Discrete_video_arcade_games","Cancelled_arcade_games",
  "Namco_arcade_games","Arcade_game_stubs","Vector_arcade_games","Hyper_Neogeo_64_games",
  "Nintendo_Vs._Series_games","Sega_System_32_games","Sega_System_1_games","Taito_NESiCAxLive_games"
)
GROUP BY page.page_id, rd_from
SQL

Checking query status...
