Tech_category - Quarry

SQL

use enwiki_p;

select base_id, id, 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
join page p2 on rd.rd_title = p2.page_title
join categorylinks cat on cat.cl_from = p2.page_id where cat.cl_to="Science"

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="Science"

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...
