Ticket #47642: patch.47642.20190923.1

Index: src/wp-admin/includes/post.php
===================================================================
--- src/wp-admin/includes/post.php      (revision 46194)
+++ src/wp-admin/includes/post.php      (working copy)
@@ -1180,6 +1180,13 @@
                $query['fields']                 = 'id=>parent';
        }
 
+       // Database fix where paginated resultsets in wp-admin CPT table listing with only orderby = comment_count
+       // have the very same subset of results troughout the pagination. Add any other field to the orderby.
+       // Ticket #47642
+       if( $orderby == 'comment_count' && $posts_per_page > 0 ) {
+           $query['orderby'] = array( $orderby => $order, 'ID' => $order );
+       }
+       
        if ( ! empty( $q['show_sticky'] ) ) {
                $query['post__in'] = (array) get_option( 'sticky_posts' );
        }