Medailisté, vítězové, možné problémy

SQL

use cswiki_p;
select page_namespace, page_title from page where not page_is_redirect and page_title like "%edailist%" and page_title like "%(%";
select page_namespace, page_title from page where not page_is_redirect and page_title like "%ítěz%" and page_title like "%(%";
select page_namespace, page_title from page where not page_is_redirect and page_title like "%edailiste%" and page_title rlike "[žŽ]en";
select page_namespace, page_title from page where not page_is_redirect and page_title like "%ítěze%" and page_title rlike "[žŽ]en";
select page_namespace, page_title from page where not page_is_redirect and page_title like "%edailistk%" and page_title rlike "[žŽ]en";
select page_namespace, page_title from page where not page_is_redirect and page_title like "%ítězk%" and page_title rlike "[žŽ]en";
select page_namespace, page_title from page where not page_is_redirect and page_title like "%edailist%" and page_title rlike "x";
select page_namespace, page_title from page where not page_is_redirect and page_title like "%ítěz%" and page_title rlike "x" and page_title not like "%ox%" and page_title not like "%xtralig%";
SQL

Checking query status...
