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
Tohaomg
.
Useful when organizing article contests
Toggle Highlighting
SQL
SELECT page_title FROM ukwiki_p.page WHERE CHAR_LENGTH(page_title) BETWEEN 7 AND 10 AND (page_title NOT LIKE "%A%") AND (page_title NOT LIKE "%B%") AND (page_title NOT LIKE "%C%") AND (page_title NOT LIKE "%D%") AND (page_title NOT LIKE "%E%") AND (page_title NOT LIKE "%F%") AND (page_title NOT LIKE "%G%") AND (page_title NOT LIKE "%H%") AND (page_title NOT LIKE "%I%") AND (page_title NOT LIKE "%J%") AND (page_title NOT LIKE "%K%") AND (page_title NOT LIKE "%L%") AND (page_title NOT LIKE "%M%") AND (page_title NOT LIKE "%N%") AND (page_title NOT LIKE "%O%") AND (page_title NOT LIKE "%P%") AND (page_title NOT LIKE "%Q%") AND (page_title NOT LIKE "%R%") AND (page_title NOT LIKE "%S%") AND (page_title NOT LIKE "%T%") AND (page_title NOT LIKE "%U%") AND (page_title NOT LIKE "%V%") AND (page_title NOT LIKE "%W%") AND (page_title NOT LIKE "%X%") AND (page_title NOT LIKE "%Y%") AND (page_title NOT LIKE "%Z%") AND (page_title NOT LIKE "%1%") AND (page_title NOT LIKE "%2%") AND (page_title NOT LIKE "%3%") AND (page_title NOT LIKE "%4%") AND (page_title NOT LIKE "%5%") AND (page_title NOT LIKE "%6%") AND (page_title NOT LIKE "%7%") AND (page_title NOT LIKE "%8%") AND (page_title NOT LIKE "%9%") AND (page_title NOT LIKE "%0%") AND (page_title NOT LIKE "%\"%") AND (page_title NOT LIKE "%«%") AND (page_title NOT LIKE "%!%") AND (page_title NOT LIKE "%.%") AND (page_title NOT 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...
