From b22cd5d1c72ce4a283e6664f5b3059ee37a55e10 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Sun, 10 Aug 2003 10:35:26 +0000
Subject: - Bugfix: changed an inner join back to a left join.  Patch by Bart
 Jansens

---
 modules/import.module | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'modules/import.module')

diff --git a/modules/import.module b/modules/import.module
index 62261e711..945044a04 100644
--- a/modules/import.module
+++ b/modules/import.module
@@ -501,7 +501,7 @@ function import_get_bundle($bid) {
 }
 
 function import_view() {
-  $result = db_query("SELECT f.*, COUNT(i.iid) AS items FROM {feed} f INNER JOIN {item} i ON f.fid = i.fid GROUP BY f.fid, f.title, f.url, f.refresh, f.timestamp, f.attributes, f.link, f.description ORDER BY f.title");
+  $result = db_query("SELECT f.*, COUNT(i.iid) AS items FROM {feed} f LEFT JOIN {item} i ON f.fid = i.fid GROUP BY f.fid, f.title, f.url, f.refresh, f.timestamp, f.attributes, f.link, f.description ORDER BY f.title");
 
   $output .= "<h3>Feed overview</h3>";
 
-- 
cgit v1.2.3