All articles in a category with redirects to them

SQL

select concat('# [[', page_title, ']] -> [[', rd_title, ']]') as answer from redirect join page
on page_id = rd_from
where rd_title like 'Император_%'
and rd_title = concat('Император_', page_title)
and not exists
(select * from page_props
 where pp_propname = 'disambiguation'
 and pp_page in
 (select page_id from page
  where page_title = rd_title
  and page_namespace = rd_namespace))
order by rd_title

​x
 
select concat('# [[', page_title, ']] -> [[', rd_title, ']]') as answer from redirect join pageon page_id = rd_fromwhere rd_title like 'Император_%'and rd_title = concat('Император_', page_title)and not exists(select * from page_props where pp_propname = 'disambiguation' and pp_page in (select page_id from page  where page_title = rd_title  and page_namespace = rd_namespace))order by rd_title​

SQL

Checking query status...