From 99bf815ca50ab3c43f1c6611a23b44d36559a0c4 Mon Sep 17 00:00:00 2001 From: Michael J Rubinsky Date: Sat, 29 Jan 2011 23:18:50 -0500 Subject: [PATCH] don't use 'as' for table alias --- jonah/lib/Driver/Sql.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/jonah/lib/Driver/Sql.php b/jonah/lib/Driver/Sql.php index 9d5b8873d..1c867a397 100644 --- a/jonah/lib/Driver/Sql.php +++ b/jonah/lib/Driver/Sql.php @@ -750,9 +750,9 @@ class Jonah_Driver_Sql extends Jonah_Driver } else { $stories = array(); $sql = 'SELECT DISTINCT s.story_id, s.channel_id FROM jonah_stories' - . ' as s, jonah_stories_tags as t'; + . ' s, jonah_stories_tags t'; for ($i = 0; $i < count($ids); $i++) { - $sql .= ', jonah_stories_tags as t' . $i; + $sql .= ', jonah_stories_tags t' . $i; } $sql .= ' WHERE s.story_id = t.story_id'; for ($i = 0 ; $i < count($ids); $i++) { -- 2.11.0