This query is marked as a draft This query has been published by Wikisaurus.

SQL

AخA
 
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
     AND (tl_title = 'Навигационная_полоса'
          OR tl_title = 'Навигационная_таблица')
     LIMIT 1)
FROM logging
WHERE log_type='move'
    AND log_timestamp >= "20181016"
    AND log_namespace = 10
    AND NOT log_title LIKE "%/doc"
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...