Query Run
SELECT page_id, CASE WHEN page_namespace = 1 THEN CONCAT('[[Talk:',... 5 years ago
SELECT page_id, CONCAT('[[{{ns:', page_namespace, '}}:', page_title,... 5 years ago
SELECT page_id, CONCAT('[[', page_title, ']]') AS 'page title', ... 5 years ago