SET @pat1 = 'Special\_talk:%';

SET @pat2 = 'Special\_Talk:%';

SELECT CONCAT('[[', REPLACE(page_title, '_', ' '), ']]') AS title,

        EXISTS (SELECT 1

                FROM page p2

                WHERE p2.page_namespace = sq.page_namespace

                  AND p2.page_title = sq.page_title) AS existing,

        COUNT(log_namespace) AS `times deleted`,

        GROUP_CONCAT(log_timestamp SEPARATOR ' // ') AS `deletion times`,

        GROUP_CONCAT(comment_text SEPARATOR ' // ') AS `deletion comments`,

        (SELECT GROUP_CONCAT(comment_text SEPARATOR ' // ')

         FROM logging_logindex

         JOIN comment_logging ON comment_id = log_comment_id

         WHERE log_namespace = page_namespace

           AND log_title = page_title

           AND log_type = 'protect'

           AND log_action = 'protect'

           AND log_params LIKE '%create=%') AS `salt comments`

FROM (SELECT page_namespace, page_title

      FROM page

      WHERE page_namespace = 0

        AND (page_title LIKE @pat1

             OR page_title LIKE @pat2)

      UNION DISTINCT

      SELECT ar_namespace, ar_title

      FROM archive

      WHERE ar_namespace = 0

        AND (ar_title LIKE @pat1

             OR ar_title LIKE @pat2)) sq

LEFT JOIN logging_logindex ON log_namespace = page_namespace

                          AND log_title = page_title

                          AND log_action = 'delete'

                          AND log_type = 'delete'

LEFT JOIN comment_logging ON comment_id = log_comment_id

GROUP BY page_namespace, page_title

ORDER BY `existing` DESC, page_namespace ASC, page_title ASC;

​