Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Tomigaoka
.
Toggle Highlighting
SQL
SELECT P.page_namespace, P.page_title FROM page P WHERE (P.page_namespace=0 OR P.page_namespace=10 OR P.page_namespace=14) AND ( P.page_title LIKE '%·%' OR P.page_title LIKE '%·%' OR P.page_title LIKE '%•%' OR P.page_title LIKE '%∙%' OR P.page_title LIKE '%⋅%' OR P.page_title LIKE '%・%' OR P.page_title LIKE '%ア%' OR P.page_title LIKE '%イ%' OR P.page_title LIKE '%ウ%' OR P.page_title LIKE '%エ%' OR P.page_title LIKE '%オ%' OR P.page_title LIKE '%カ%' OR P.page_title LIKE '%キ%' OR P.page_title LIKE '%ク%' OR P.page_title LIKE '%ケ%' OR P.page_title LIKE '%コ%' OR P.page_title LIKE '%サ%' OR P.page_title LIKE '%シ%' OR P.page_title LIKE '%ス%' OR P.page_title LIKE '%セ%' OR P.page_title LIKE '%ソ%' OR P.page_title LIKE '%タ%' OR P.page_title LIKE '%チ%' OR P.page_title LIKE '%ツ%' OR P.page_title LIKE '%テ%' OR P.page_title LIKE '%ト%' OR P.page_title LIKE '%ナ%' OR P.page_title LIKE '%ニ%' OR P.page_title LIKE '%ヌ%' OR P.page_title LIKE '%ネ%' OR P.page_title LIKE '%ノ%' OR P.page_title LIKE '%ハ%' OR P.page_title LIKE '%ヒ%' OR P.page_title LIKE '%フ%' OR P.page_title LIKE '%ヘ%' OR P.page_title LIKE '%ホ%' OR P.page_title LIKE '%マ%' OR P.page_title LIKE '%ミ%' OR P.page_title LIKE '%ム%' OR P.page_title LIKE '%メ%' OR P.page_title LIKE '%モ%' OR P.page_title LIKE '%ヤ%' OR P.page_title LIKE '%ヨ%' OR P.page_title LIKE '%ヨ%' OR P.page_title LIKE '%ラ%' OR P.page_title LIKE '%リ%' OR P.page_title LIKE '%ル%' OR P.page_title LIKE '%レ%' OR P.page_title LIKE '%ロ%' OR P.page_title LIKE '%ワ%' OR P.page_title LIKE '%ヲ%' OR P.page_title LIKE '%ン%' OR P.page_title LIKE '%ァ%' OR P.page_title LIKE '%ィ%' OR P.page_title LIKE '%ゥ%' OR P.page_title LIKE '%ェ%' OR P.page_title LIKE '%ォ%' OR P.page_title LIKE '%ャ%' OR P.page_title LIKE '%ュ%' OR P.page_title LIKE '%ョ%' OR P.page_title LIKE '%ッ%' OR P.page_title LIKE '%ー%' OR P.page_title LIKE '%゙%' OR P.page_title LIKE '%゚%' OR P.page_title LIKE '%、%' OR P.page_title LIKE '%。%' OR P.page_title LIKE '%「%' OR P.page_title LIKE '%」%' OR P.page_title LIKE '%1%' OR P.page_title LIKE '%2%' OR P.page_title LIKE '%3%' OR P.page_title LIKE '%4%' OR P.page_title LIKE '%5%' OR P.page_title LIKE '%6%' OR P.page_title LIKE '%7%' OR P.page_title LIKE '%8%' OR P.page_title LIKE '%9%' OR P.page_title LIKE '%0%' OR P.page_title LIKE '%A%' OR P.page_title LIKE '%B%' OR P.page_title LIKE '%C%' OR P.page_title LIKE '%D%' OR P.page_title LIKE '%E%' OR P.page_title LIKE '%F%' OR P.page_title LIKE '%G%' OR P.page_title LIKE '%H%' OR P.page_title LIKE '%I%' OR P.page_title LIKE '%J%' OR P.page_title LIKE '%K%' OR P.page_title LIKE '%L%' OR P.page_title LIKE '%M%' OR P.page_title LIKE '%N%' OR P.page_title LIKE '%O%' OR P.page_title LIKE '%P%' OR P.page_title LIKE '%Q%' OR P.page_title LIKE '%R%' OR P.page_title LIKE '%S%' OR P.page_title LIKE '%T%' OR P.page_title LIKE '%U%' OR P.page_title LIKE '%V%' OR P.page_title LIKE '%W%' OR P.page_title LIKE '%X%' OR P.page_title LIKE '%Y%' OR P.page_title LIKE '%Z%' OR P.page_title LIKE '%a%' OR P.page_title LIKE '%b%' OR P.page_title LIKE '%c%' OR P.page_title LIKE '%d%' OR P.page_title LIKE '%e%' OR P.page_title LIKE '%f%' OR P.page_title LIKE '%g%' OR P.page_title LIKE '%h%' OR P.page_title LIKE '%i%' OR P.page_title LIKE '%j%' OR P.page_title LIKE '%k%' OR P.page_title LIKE '%l%' OR P.page_title LIKE '%m%' OR P.page_title LIKE '%n%' OR P.page_title LIKE '%o%' OR P.page_title LIKE '%p%' OR P.page_title LIKE '%q%' OR P.page_title LIKE '%r%' OR P.page_title LIKE '%s%' OR P.page_title LIKE '%t%' OR P.page_title LIKE '%u%' OR P.page_title LIKE '%v%' OR P.page_title LIKE '%w%' OR P.page_title LIKE '%x%' OR P.page_title LIKE '%y%' OR P.page_title LIKE '%z%' OR P.page_title LIKE '%ⅰ%' OR P.page_title LIKE '%ⅱ%' OR P.page_title LIKE '%ⅲ%' OR P.page_title LIKE '%ⅳ%' OR P.page_title LIKE '%ⅴ%' OR P.page_title LIKE '%ⅵ%' OR P.page_title LIKE '%ⅶ%' OR P.page_title LIKE '%ⅷ%' OR P.page_title LIKE '%ⅸ%' OR P.page_title LIKE '%ⅹ%' OR P.page_title LIKE '%Ⅰ%' OR P.page_title LIKE '%Ⅱ%' OR P.page_title LIKE '%Ⅲ%' OR P.page_title LIKE '%Ⅳ%' OR P.page_title LIKE '%Ⅴ%' OR P.page_title LIKE '%Ⅵ%' OR P.page_title LIKE '%Ⅶ%' OR P.page_title LIKE '%Ⅷ%' OR P.page_title LIKE '%Ⅸ%' OR P.page_title LIKE '%Ⅹ%' OR P.page_title LIKE '% %' )
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
.
Checking query status...