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

​