SQL
AخA
USE commonswiki_p;
SET @u200B = CONCAT('%', CHAR(0xE2808B USING utf8mb3), '%'); #zero width space
SET @u200C = CONCAT(CHAR(0xE2808C USING utf8mb3), '%'); #zero width non-joiner
SET @u200D = 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 @u2060 = 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 @u200B, ' U+200B zero width space', ''),
IF(page_title LIKE @u200C, ' U+200C leading zero width non-joiner', ''),
IF(page_title LIKE @u200D, ' U+200D leading 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 @u2060, ' U+2060 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', ''))
FROM page
WHERE (page_namespace % 2) = 0
AND page_is_redirect = 0
AND (page_title LIKE @u200B
OR page_title LIKE @u200C
OR page_title LIKE @u200D
OR page_title LIKE @u200E
OR page_title LIKE @u200F
OR page_title LIKE @u2028
OR page_title LIKE @u2029
# OR page_title LIKE @u2060
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.