diff options
| author | Dries Buytaert <dries@buytaert.net> | 2003-08-10 10:35:26 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2003-08-10 10:35:26 +0000 |
| commit | b22cd5d1c72ce4a283e6664f5b3059ee37a55e10 (patch) | |
| tree | 74fb656645a1b42f8fa2f8204124f922503178bf | |
| parent | cecaa68e6570a5c9ba65ef3039c1252408c79c58 (diff) | |
| download | brdo-b22cd5d1c72ce4a283e6664f5b3059ee37a55e10.tar.gz brdo-b22cd5d1c72ce4a283e6664f5b3059ee37a55e10.tar.bz2 | |
- Bugfix: changed an inner join back to a left join. Patch by Bart Jansens
| -rw-r--r-- | modules/aggregator.module | 2 | ||||
| -rw-r--r-- | modules/aggregator/aggregator.module | 2 | ||||
| -rw-r--r-- | modules/import.module | 2 |
3 files changed, 3 insertions, 3 deletions
diff --git a/modules/aggregator.module b/modules/aggregator.module index 62261e711..945044a04 100644 --- a/modules/aggregator.module +++ b/modules/aggregator.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>"; diff --git a/modules/aggregator/aggregator.module b/modules/aggregator/aggregator.module index 62261e711..945044a04 100644 --- a/modules/aggregator/aggregator.module +++ b/modules/aggregator/aggregator.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>"; 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>"; |