Recently moved navboxes in ruwiki

SQL

USE ruwiki_p;
SELECT
    log_namespace,
    log_timestamp,
    log_action,
    log_title,
    log_comment,
    (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)
FROM logging
WHERE log_type='move'
	AND log_timestamp >= "20181016"
    AND log_namespace = 10
    AND NOT log_title LIKE "%/doc"
SQL

Checking query status...
