Untitled query #61904

SQL

	SELECT revision.rev_id, log_id, revision.rev_timestamp, actor_name, log_namespace, log_title, comment_text, log_params 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_userindex AS revision_sibling ON (revision_sibling.rev_timestamp = revision.rev_timestamp OR revision_sibling.rev_timestamp = revision.rev_timestamp + 1) 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...
