Fork of Unsichtbare Leerzeichen in Wikilinks by Wurgl
This query is marked as a draft This query has been published by Achim55.

SQL

x
 
USE enwikisource_p;
SELECT CONCAT('# [[', IF (page_namespace != 0, CONCAT(':{{ns:', page_namespace,'}}:'), ''), REPLACE(page_title, '_', ' '), ']] ',
              '→ [[:{{ns:', pl_namespace, '}}:]]',
       REPLACE(
         REPLACE(
           REPLACE(
             REPLACE(
               REPLACE(
                 REPLACE(
                   REPLACE(
                     REPLACE(
                       REPLACE(
                         REPLACE(
                           REPLACE(
                             REPLACE(
                               REPLACE(
                                 REPLACE(
                                   REPLACE(
                                     REPLACE(
                                       REPLACE(
                                         REPLACE(
                                           REPLACE(pl_title, '_', ' '),
                                         CHAR(49824),    '<U+00A0>'),
                                       CHAR(14844032), '<U+2000>'),
                                     CHAR(14844033), '<U+2001>'),
                                   CHAR(14844034), '<U+2002>'),
                                 CHAR(14844035), '<U+2003>'),
                               CHAR(14844036), '<U+2004>'),
                             CHAR(14844037), '<U+2005>'),
                           CHAR(14844038), '<U+2006>'),
                         CHAR(14844039), '<U+2007>'),
                       CHAR(14844040), '<U+2008>'),
                     CHAR(14844041), '<U+2009>'),
                   CHAR(14844042), '<U+200A>'),
                 CHAR(14844043), '<U+200B>'),
               CHAR(14844044), '<U+200C>'),
             CHAR(14844045), '<U+200D>'),
           CHAR(14844046), '<U+200E>'),
         CHAR(14844047), '<U+200F>'),
       CHAR(15711167), '<U+FEFF>')) AS title
FROM pagelinks
INNER JOIN page ON page_id = pl_from AND page_namespace IN (0, 6, 10, 14)
WHERE (pl_title LIKE CONCAT('%', CHAR(49824), '%') # C2A0 U+00A0 'NO-BREAK SPACE'
    OR pl_title LIKE '% %' # E28080 U+2000 'EN QUAD'
    OR pl_title LIKE '% %' # E28081 U+2001 'EM QUAD'
    OR pl_title LIKE '% %' # E28082 U+2002 'EN SPACE'
    OR pl_title LIKE '% %' # E28083 U+2003 'EM SPACE'
    OR pl_title LIKE '% %' # E28084 U+2004 'THREE-PER-EM SPACE'
    OR pl_title LIKE '% %' # E28085 U+2005 'FOUR-PER-EM SPACE'
    OR pl_title LIKE '% %' # E28086 U+2006 'SIX-PER-EM SPACE'
    OR pl_title LIKE '% %' # E28087 U+2007 'FIGURE SPACE'
    OR pl_title LIKE '% %' # E28088 U+2008 'PUNCTUATION SPACE'
    OR pl_title LIKE '% %' # E28089 U+2009 'THIN SPACE'
    OR pl_title LIKE '% %' # E2808A U+200A 'HAIR SPACE'
    OR pl_title LIKE '%%' # E2808B U+200B 'ZERO WIDTH SPACE'
    OR pl_title LIKE '%%' # E2808C U+200C 'ZERO WIDTH NON-JOINER'
    OR pl_title LIKE '%%' # E2808D U+200D 'ZERO WIDTH JOINER'
    OR pl_title LIKE '%%' # E2808E U+200E 'LEFT-TO-RIGHT MARK'
    OR pl_title LIKE '%%' # E2808F U+200F 'RIGHT-TO-LEFT MARK'
    OR pl_title LIKE '%%' # EFBBBF U+FEFF 'BYTE ORDER MARK'
       )
LIMIT 50;
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.

Checking query status...