Untitled query #37124

SQL

use arwiki_p;
select distinct concat (SUBSTRING_INDEX(SUBSTRING_INDEX(page_title, '_', 2), '_', -1)) AS "cat", page_title
from page
where page_namespace = 14
and page_is_redirect = 0
and concat('',SUBSTRING_INDEX(`page_title`, '_', 1) * 1) <> SUBSTRING_INDEX(`page_title`, '_', 1)
and concat (SUBSTRING_INDEX(SUBSTRING_INDEX(page_title, '_', 2), '_', -1))  in (select page_title from page where page_namespace = 100)
and concat (SUBSTRING_INDEX(SUBSTRING_INDEX(page_title, '_', 2), '_', -1))  not like "%/%"
limit 100;
SQL

Checking query status...
