名前空間をまたぐ移動

SQL

SELECT
	L.log_namespace AS '元空間',
    L.log_title AS '移動元ページ名',
    P.page_namespace AS '現空間',
    P.page_title AS '現在のページ名',
    A.actor_name AS '編集者',
    L.log_timestamp AS '日時',
    C.comment_text AS '要約欄'
FROM logging L
INNER JOIN page P ON L.log_page = P.page_id
INNER JOIN actor A ON L.log_actor = A.actor_id
INNER JOIN comment C ON L.log_comment_id = C.comment_id
WHERE L.log_timestamp > 20240101000000
AND L.log_type = 'move'
AND L.log_namespace != P.page_namespace
ORDER BY L.log_timestamp DESC;
SQL

Checking query status...
