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.