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
Jack who built the house
.
Toggle Highlighting
SQL
use ruwiki_p; select page_title from page where instr(page_title, ' (') and not ( instr(page_title, 'а') or instr(page_title, 'б') or instr(page_title, 'в') or instr(page_title, 'г') or instr(page_title, 'д') or instr(page_title, 'е') or instr(page_title, 'ё') or instr(page_title, 'ж') or instr(page_title, 'з') or instr(page_title, 'и') or instr(page_title, 'й') or instr(page_title, 'к') or instr(page_title, 'л') or instr(page_title, 'м') or instr(page_title, 'н') or instr(page_title, 'о') or instr(page_title, 'п') or instr(page_title, 'р') or instr(page_title, 'с') or instr(page_title, 'т') or instr(page_title, 'у') or instr(page_title, 'ф') or instr(page_title, 'ъ') or instr(page_title, 'ц') or instr(page_title, 'ч') or instr(page_title, 'ш') or instr(page_title, 'щ') or instr(page_title, 'ъ') or instr(page_title, 'ы') or instr(page_title, 'ь') or instr(page_title, 'э') or instr(page_title, 'ю') or instr(page_title, 'я') or instr(page_title, 'А') or instr(page_title, 'Б') or instr(page_title, 'В') or instr(page_title, 'Г') or instr(page_title, 'Д') or instr(page_title, 'Е') or instr(page_title, 'ё') or instr(page_title, 'Ж') or instr(page_title, 'З') or instr(page_title, 'И') or instr(page_title, 'Й') or instr(page_title, 'К') or instr(page_title, 'Л') or instr(page_title, 'М') or instr(page_title, 'Н') or instr(page_title, 'О') or instr(page_title, 'П') or instr(page_title, 'Р') or instr(page_title, 'С') or instr(page_title, 'Т') or instr(page_title, 'У') or instr(page_title, 'Ф') or instr(page_title, 'Ъ') or instr(page_title, 'Ц') or instr(page_title, 'Ч') or instr(page_title, 'Ш') or instr(page_title, 'Щ') or instr(page_title, 'Ъ') or instr(page_title, 'Ы') or instr(page_title, 'Ь') or instr(page_title, 'Э') or instr(page_title, 'Ю') or instr(page_title, 'Я') )
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...