Untitled query #63531

SQL

WITH ns(ns_n, ns_s) AS (VALUES (-2, 'Media:'), (-1, 'Special:'), (0, ''), (1, 'Talk:'), (2, 'User:'), (3, 'User talk:'), (4,
  'Wikipedia:'), (5, 'Wikipedia talk:'), (6, ':File:'), (7, 'File talk:'), (8, 'MediaWiki:'), (9, 'MediaWiki talk:'), (10, 'Template:'),
  (11, 'Template talk:'), (12, 'Help:'), (13, 'Help talk:'), (14, ':Category:'), (15, 'Category talk:'), (100, 'Portal:'), (101,
  'Portal talk:'), (118, 'Draft:'), (119, 'Draft talk:'), (126, 'MOS:'), (127, 'MOS talk:'), (710, 'TimedText:'), (711, 'TimedText talk:'),
  (828, 'Module:'), (829, 'Module talk:'))
SELECT CONCAT(COALESCE(nsp.ns_s, '?:'), page_title) AS title,
       IF(rd_namespace IS NULL, NULL, CONCAT(COALESCE(nsr.ns_s, '?:'), rd_title)) AS redirect_to
FROM page
LEFT JOIN ns AS nsp ON nsp.ns_n = page_namespace
LEFT JOIN redirect ON rd_from = page_id
LEFT JOIN ns AS nsr ON nsr.ns_n = rd_namespace
  AND page_title LIKE '%blake%alma%'
ORDER BY page_namespace ASC, page_title ASC;
SQL

Checking query status...
