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 '%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 '% %' )
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...