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