SELECT CONCAT('[[{{ns:', page_namespace, '}}:', page_title, ']]') AS 'page title',

       CASE WHEN page_is_redirect = 0 THEN NULL

            ELSE (SELECT CASE WHEN rd_namespace = 0 THEN CONCAT('[[', rd_title, ']]')

                              ELSE CONCAT('[[{{ns:', rd_namespace, '}}:', rd_title, ']]')

                              END

                  FROM redirect

                  WHERE rd_from = page_id)

            END AS 'redirect to'

FROM page

WHERE page_title RLIKE '\\([qQpP][0-9]+';