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
.
Toggle Highlighting
SQL
SELECT DISTINCT page_title FROM ukwiki_p.page WHERE (page_title LIKE "Ч%") 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 "%ґ%") 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 "%з%") 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 "%к%") 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 "%п%") 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 "%ф%") 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 "%щ%") AND (page_title NOT LIKE "%ь%") AND (page_title NOT LIKE "%ю%") AND (page_title NOT LIKE "%я%") 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 "%.jpg%") AND (page_title NOT LIKE "%.png%") AND (page_title NOT LIKE "%.gif%") AND (page_title NOT LIKE "%.JPG%") AND (page_title NOT LIKE "%.PNG%") AND (page_title NOT LIKE "%.GIF%") ORDER BY page_title ASC
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...