Revisions Count Column
Adds a Revisions column to the Posts and Pages lists showing how many saved revisions each item has, linking to the revision browser, to find heavily edited content.
Opens WPIDE on
Code
$wpide_revision_counts = null;
$wpide_revisions_cell = function ( $column, $post_id ) use ( &$wpide_revision_counts ) {
if ( 'wpide_revisions' !== $column ) {
return;
}
if ( null === $wpide_revision_counts ) {
global $wpdb, $wp_query;
$ids = $wp_query && $wp_query->posts ? array_map( 'absint', wp_list_pluck( $wp_query->posts, 'ID' ) ) : array( (int) $post_id );
$wpide_revision_counts = wp_list_pluck( $wpdb->get_results(
"SELECT post_parent, COUNT(*) AS total FROM {$wpdb->posts} WHERE post_type = 'revision' AND post_parent IN (" . implode( ',', $ids ? $ids : array( 0 ) ) . ') GROUP BY post_parent'
), 'total', 'post_parent' );
}
$count = (int) ( $wpide_revision_counts[ $post_id ] ?? 0 );
if ( ! $count ) {
echo '0';
return;
}
$latest = wp_get_post_revisions( $post_id, array( 'posts_per_page' => 1, 'fields' => 'ids' ) );
printf( '<a href="%s">%d</a>', esc_url( admin_url( 'revision.php?revision=' . (int) reset( $latest ) ) ), $count );
};
foreach ( array( 'post', 'page' ) as $wpide_type ) {
add_filter( "manage_{$wpide_type}_posts_columns", function ( $columns ) {
$columns['wpide_revisions'] = 'Revisions';
return $columns;
} );
add_action( "manage_{$wpide_type}_posts_custom_column", $wpide_revisions_cell, 10, 2 );
}
Notes
Counts come from one grouped query per screen.
How to add this snippet
- Install WPIDE on your WordPress site (it is free) and open Code Snippets.
- Use snippet above adds it from the library in one click. Or copy the code into a new snippet with the same code type.
- It is added inactive: review the code and settings, then switch it on.