bad characters in page titles on Commons

This query is marked as a draft This query has been published by Achim55.
SQL

SET @u00A0 = CONCAT('%', CHAR(0xC2A0 USING utf8mb3), '%'); #non-breaking space
SET @u00AD = CONCAT('%', CHAR(0xC2AD USING utf8mb3), '%'); #soft hyphen
SET @u200B = CONCAT('%', CHAR(0xE2808B USING utf8mb3), '%'); #zero width space
SET @u200Cs = CONCAT(CHAR(0xE2808C USING utf8mb3), '%'); #zero width non-joiner
SET @u200Ce = CONCAT('%', CHAR(0xE2808C USING utf8mb3)); #zero width non-joiner
SET @u200Ds = CONCAT(CHAR(0xE2808D USING utf8mb3), '%'); #zero width joiner
SET @u200De = CONCAT('%', CHAR(0xE2808D USING utf8mb3)); #zero width joiner
SET @u200E = CONCAT('%', CHAR(0xE2808E USING utf8mb3), '%'); #LTR mark
SET @u200F = CONCAT('%', CHAR(0xE2808F USING utf8mb3), '%'); #RTL mark
SET @u2028 = CONCAT('%', CHAR(0xE280A8 USING utf8mb3), '%'); #line separator
SET @u2029 = CONCAT('%', CHAR(0xE280A9 USING utf8mb3), '%'); #paragraph separator
SET @u202A = CONCAT('%', CHAR(0xE280AA USING utf8mb3), '%'); #left-to-right embedding
SET @u202B = CONCAT('%', CHAR(0xE280AB USING utf8mb3), '%'); #right-to-left embedding
SET @u202C = CONCAT('%', CHAR(0xE280AC USING utf8mb3), '%'); #pop directional formatting
SET @u202D = CONCAT('%', CHAR(0xE280AD USING utf8mb3), '%'); #left-to-right override
SET @u202E = CONCAT('%', CHAR(0xE280A9 USING utf8mb3), '%'); #right-to-left override
SET @u202F = CONCAT('%', CHAR(0xE280AF USING utf8mb3), '%'); #narrow non-breaking space
SET @u2060a = CONCAT('%\_', CHAR(0xE281A0 USING utf8mb3), '%'); #word joiner
SET @u2060b = CONCAT('%', CHAR(0xE281A0 USING utf8mb3), '\_%'); #word joiner
SET @u2060s = CONCAT(CHAR(0xE281A0 USING utf8mb3), '%'); #word joiner
SET @u2060e = CONCAT('%', CHAR(0xE281A0 USING utf8mb3)); #word joiner
SET @u2061 = CONCAT('%', CHAR(0xE281A1 USING utf8mb3), '%'); #function application
SET @u2066 = CONCAT('%', CHAR(0xE281A6 USING utf8mb3), '%'); #LTR isolate
SET @u2067 = CONCAT('%', CHAR(0xE281A7 USING utf8mb3), '%'); #RTL isolate
SET @u2068 = CONCAT('%', CHAR(0xE281A8 USING utf8mb3), '%'); #first strong isolate
SET @u2069 = CONCAT('%', CHAR(0xE281A9 USING utf8mb3), '%'); #pop directional isolate
SET @uFEFF = CONCAT('%', CHAR(0xEFBBBF USING utf8mb3), '%'); #BOM
SET @uFFFC = CONCAT('%', CHAR(0xEFBFBC USING utf8mb3), '%'); #
SET @uFFFD = CONCAT('%', CHAR(0xEFBFBD USING utf8mb3), '%'); #�
SET @uE0001 = CONCAT('%', CHAR(0xF3A08081 USING utf8mb4), '%'); #language tag
SELECT CONCAT('# [[:{{ns:', page_namespace, '}}:', REPLACE(page_title, '_', ' '), ']]',
              IF(page_title LIKE @u00A0, ' U+00A0 non-breaking space', ''),
              IF(page_title LIKE @u00AD, ' U+00AD soft hyphen', ''),
              IF(page_title LIKE @u200B, ' U+200B zero width space', ''),
              IF(page_title LIKE @u200Cs, ' U+200C leading zero width non-joiner', ''),
              IF(page_title LIKE @u200Ce, ' U+200C trailing zero width non-joiner', ''),
              IF(page_title LIKE @u200Ds, ' U+200D leading zero width joiner', ''),
              IF(page_title LIKE @u200De, ' U+200D trailing zero width joiner', ''),
              IF(page_title LIKE @u200E, ' U+200E LTR mark', ''),
              IF(page_title LIKE @u200F, ' U+200F RTL mark', ''),
              IF(page_title LIKE @u2028, ' U+2028 line separator', ''),
              IF(page_title LIKE @u2029, ' U+2029 paragraph separator', ''),
              IF(page_title LIKE @u202F, ' U+202F narrow non-breaking space', ''),
              IF(page_title LIKE @u2060a, ' U+2060 useless word joiner', ''),
              IF(page_title LIKE @u2060b, ' U+2060 useless word joiner', ''),
              IF(page_title LIKE @u2061, ' U+2061 function application', ''),
              IF(page_title LIKE @u2066, ' U+2066 LTR isolate', ''),
              IF(page_title LIKE @u2067, ' U+2067 RTL isolate', ''),
              IF(page_title LIKE @u2068, ' U+2068 first strong isolate', ''),
              IF(page_title LIKE @u2069, ' U+2069 pop directional isolate', ''),
              IF(page_title LIKE @uFEFF, ' U+FEFF BOM', ''),
              IF(page_title LIKE @uFFFC, ' U+FFFC ', ''),
              IF(page_title LIKE @uFFFD, ' U+FFFD �', ''),
              IF(page_title LIKE @uE0001, ' U+E0001 language tag', '')
             ) AS p
FROM page
WHERE page_is_redirect = 0
AND page_namespace NOT IN (2, 3)
AND (page_title LIKE @u00A0
  OR page_title LIKE @u00AD
  OR page_title LIKE @u200B
  OR page_title LIKE @u200Cs
  OR page_title LIKE @u200Ce
  OR page_title LIKE @u200Ds
  OR page_title LIKE @u200De
  OR page_title LIKE @u200E
  OR page_title LIKE @u200F
  OR page_title LIKE @u2028
  OR page_title LIKE @u2029
  OR page_title LIKE @u202A
  OR page_title LIKE @u202B
  OR page_title LIKE @u202C
  OR page_title LIKE @u202D
  OR page_title LIKE @u202E
  OR page_title LIKE @u202F
  OR page_title LIKE @u2060a
  OR page_title LIKE @u2060b
  OR page_title LIKE @u2060s
  OR page_title LIKE @u2060e
  OR page_title LIKE @u2061
  OR page_title LIKE @u2066
  OR page_title LIKE @u2067
  OR page_title LIKE @u2068
  OR page_title LIKE @u2069
  OR page_title LIKE @uFEFF
  OR page_title LIKE @uFFFC
  OR page_title LIKE @uFFFD
  OR page_title LIKE @uE0001)
AND page_title NOT LIKE 'Deletion\_requests/%'
AND page_id NOT IN (SELECT cl_from FROM categorylinks WHERE cl_to = 'Category_redirects')
ORDER BY page_title
LIMIT 500;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
