Untitled query #41512

SQL

use simplewiki_p;

select title as page_title from (

select 1 as type, p2.page_id as base_id, p.page_id as sub_id, p.page_id as id, p2.page_title as base_title, p.page_title as title from page p
-- where p.page_title not like N'%־%'
left join redirect rd on rd.rd_from = p.page_id and rd.rd_namespace = 0 and page_len >= 5000
join page p2 on rd.rd_title = p2.page_title
join categorylinks cat on cat.cl_from = p2.page_id where cat.cl_to="Indian_leaders" 

union

select 0 as type, p.page_id as id, 0 as sub_id, p.page_id as base_id, p.page_title as title, p.page_title as base_title from page p
join categorylinks cat on cat.cl_from = p.page_id where cat.cl_to="Indian_leaders"

order by type, base_title, base_id, sub_id -- order by type to collect nonredirects first
) as res

where not title like '%־%'

-- limit 100
SQL

Checking query status...
