Pages matching "Special talk:"

SQL

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;
SQL

Checking query status...
