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.