summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--modules/aggregator.module2
-rw-r--r--modules/aggregator/aggregator.module2
-rw-r--r--modules/import.module2
3 files changed, 3 insertions, 3 deletions
diff --git a/modules/aggregator.module b/modules/aggregator.module
index f2e346083..ee0de4fe2 100644
--- a/modules/aggregator.module
+++ b/modules/aggregator.module
@@ -356,7 +356,7 @@ function import_view_bundle() {
function import_view_item() {
global $REQUEST_URI;
- $result = db_query("SELECT i.*, f.title AS feed FROM item i LEFT JOIN feed f ON i.fid = f.fid ORDER BY i.timestamp DESC LIMIT 50");
+ $result = db_query("SELECT i.*, f.title AS feed FROM item i LEFT JOIN feed f ON i.fid = f.fid ORDER BY i.iid DESC LIMIT 50");
$output .= "<form action=\"$REQUEST_URI\" method=\"post\">\n";
$output .= "<table border=\"1\" cellpadding=\"2\" cellspacing=\"2\">\n";
diff --git a/modules/aggregator/aggregator.module b/modules/aggregator/aggregator.module
index f2e346083..ee0de4fe2 100644
--- a/modules/aggregator/aggregator.module
+++ b/modules/aggregator/aggregator.module
@@ -356,7 +356,7 @@ function import_view_bundle() {
function import_view_item() {
global $REQUEST_URI;
- $result = db_query("SELECT i.*, f.title AS feed FROM item i LEFT JOIN feed f ON i.fid = f.fid ORDER BY i.timestamp DESC LIMIT 50");
+ $result = db_query("SELECT i.*, f.title AS feed FROM item i LEFT JOIN feed f ON i.fid = f.fid ORDER BY i.iid DESC LIMIT 50");
$output .= "<form action=\"$REQUEST_URI\" method=\"post\">\n";
$output .= "<table border=\"1\" cellpadding=\"2\" cellspacing=\"2\">\n";
diff --git a/modules/import.module b/modules/import.module
index f2e346083..ee0de4fe2 100644
--- a/modules/import.module
+++ b/modules/import.module
@@ -356,7 +356,7 @@ function import_view_bundle() {
function import_view_item() {
global $REQUEST_URI;
- $result = db_query("SELECT i.*, f.title AS feed FROM item i LEFT JOIN feed f ON i.fid = f.fid ORDER BY i.timestamp DESC LIMIT 50");
+ $result = db_query("SELECT i.*, f.title AS feed FROM item i LEFT JOIN feed f ON i.fid = f.fid ORDER BY i.iid DESC LIMIT 50");
$output .= "<form action=\"$REQUEST_URI\" method=\"post\">\n";
$output .= "<table border=\"1\" cellpadding=\"2\" cellspacing=\"2\">\n";