SQL
AخA
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.
All SQL code is licensed under CC0 License.