Untitled query #61904

SQL

    SELECT * FROM revision
    JOIN page ON page_id = rev_page AND page_namespace = 0 AND page_title = "ViacomCBS_Networks_International"
    # log entry might have a larger timestamp than the revision entry since it's added after
    JOIN logging_userindex ON log_actor = rev_actor AND (log_timestamp = rev_timestamp OR log_timestamp = rev_timestamp + 1) AND log_type = 'move'
    JOIN revision AS revision_parent ON revision_parent.rev_id = revision.rev_parent_id AND revision_parent.rev_len = revision.rev_len
    JOIN revision AS revision_sibling ON revision_sibling.rev_id = revision.rev_parent_id AND revision_sibling.rev_len = revision.rev_len
    LEFT JOIN comment_logging ON log_comment_id = comment_id
    LEFT JOIN actor_logging ON log_actor = actor_id
    ORDER BY log_timestamp DESC
SQL

Checking query status...
