Recently moved navboxes in ruwiki

SQL

USE ruwiki_p;
SELECT
    log_timestamp,
    log_title,
    (SELECT
     	rd_title
     FROM redirect
     WHERE
     	rd_from = (SELECT
                  		page_id
                  FROM page
                  WHERE page_title = log_title
                  		AND page_namespace = log_namespace
                 )
     	AND rd_namespace = 10
    ) AS moved_to_title,
    log_comment
FROM logging
WHERE log_type='move'
	AND log_timestamp >= "20160101"
	AND log_timestamp <= "20170101"
    AND log_namespace = 10
    AND NOT log_title LIKE "%/doc"
    AND EXISTS (SELECT
                    tl_title
                 FROM templatelinks
                 WHERE tl_from = (SELECT
                                      page_id
                                  FROM page
                                  WHERE
                                      page_title = (SELECT
                                                        rd_title
                                                    FROM redirect
                                                    WHERE
                                                        rd_from = (SELECT
                                                                        page_id
                                                                   FROM page
                                                                   WHERE page_title = log_title
                                                                        AND page_namespace = log_namespace
                                                                  )
                                                        AND rd_namespace = 10
                                                   )
                                      AND page_namespace = 10
                                 )
                 AND tl_from_namespace = 10
                 AND (tl_title = 'Навигационная_полоса'
                      OR tl_title = 'Навигационная_таблица')
                 )
SQL

Checking query status...
