Changeset 13577

Timestamp:

04/22/2024 01:28:32 AM (11 months ago)

Author:

dd32

Message:

Plugin Directory: Reviews: Fetch the latest reviews by date, not by review ID.

The review_id is an incremental field that may not reflect the same date order as the reviews are in.

File:

• sites/trunk/wordpress.org/public_html/wp-content/plugins/plugin-directory/class-tools.php (modified) (1 diff)

sites/trunk/wordpress.org/public_html/wp-content/plugins/plugin-directory/class-tools.php

@@ -71 +71 @@
                     LEFT JOIN " . $wpdb->base_prefix . WPORG_SUPPORT_FORUMS_BLOGID . "_posts p ON r.post_id = p.ID
                 WHERE r.object_type = 'plugin' AND r.object_slug = %s AND p.post_status = 'publish'
-                ORDER BY r.review_id DESC
+                ORDER BY r.date DESC
                 LIMIT %d",
                 $post->post_name,