use ruwiki_p;

select * from page

where page_namespace = 0

and page_is_redirect

and exists

(select * from templatelinks

 where page_id = tl_from

 and not tl_title in ("R_with_possibilities", "Redirect_template", "Arguments", "No_globals", "Ambox", "Wikidata-redirect", "Arguments",

 "Category_handler", "Category_handler/blacklist", "Category_handler/config", "Category_handler/data", "Category_handler/shared", "Dates",

 "Message_box", "Message_box/configuration", "Namespace_detect/config", "Namespace_detect/data", "Yesno", "Replace",

 "Wikidata-taxon-redirect", "Таксон/Цвет", "String", "Date_Converter", "Nobr", "Администраторам", "К_удалению", "Очищать_кэш",

 "Просроченные_подведения_итогов", "Сортировка:_КУ", "Сортировка:_по_странам", "Сортировка:_по_типам"));

select tl_title from templatelinks

where tl_from = 3209908

​