Untitled query #30423

SQL

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", "Администраторам", "К_удалению", "Очищать_кэш",
 "Просроченные_подведения_итогов", "Сортировка:_КУ", "Сортировка:_по_странам", "Сортировка:_по_типам", "R_from_acronym", "Заголовок",
 "Заголовок_со_строчной_буквы", "Arguments", "Title_transformations"));
select tl_title from templatelinks
where tl_from = 3209908
SQL

Checking query status...
