From c475f8610c3393827330941d91916bf8dd7a2e1e Mon Sep 17 00:00:00 2001 From: Chuck Hagenbuch Date: Fri, 17 Sep 2010 01:40:48 -0400 Subject: [PATCH] Don't filter out stories with no tags --- jonah/lib/Driver/Sql.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/jonah/lib/Driver/Sql.php b/jonah/lib/Driver/Sql.php index 9d1c3d198..eb4cc2e71 100644 --- a/jonah/lib/Driver/Sql.php +++ b/jonah/lib/Driver/Sql.php @@ -377,7 +377,7 @@ class Jonah_Driver_Sql extends Jonah_Driver 'stories.story_updated AS updated, ' . 'stories.story_read AS readcount ' . 'FROM jonah_stories AS stories ' . - 'JOIN jonah_stories_tags tags ON (stories.story_id = tags.story_id) ' . + 'LEFT JOIN jonah_stories_tags tags ON (stories.story_id = tags.story_id) ' . 'WHERE stories.channel_id=?'; $values = array($criteria['channel_id']); -- 2.11.0