An Error Was Encountered
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 42
SELECT group_id, group_name, group_desc, group_post_rule, group_listed, group_is_public, group_msg_rule, group_bounce_msg, group_echo_rule, group_subscribe_notify, group_unsubscribe_notify, group_twitter_name, group_twitter_password, group_twitter_associate, user_name AS group_owner_name, fk_owner = 0 AS user_owns_group, 0 IN ( SELECT fk_user_id FROM zip_groups_users WHERE fk_group_id = group_id AND approved = 1) AS user_in_group, ( SELECT count(*) FROM zip_groups_users WHERE fk_group_id = group_id AND approved = 1) AS member_count, ( SELECT convert_tz(created, '-6:00', replace(time_zone, '.', ':')) AS created FROM zip_messages, fa_user_profile WHERE id = 0 AND fk_group_id = group_id ORDER BY created desc LIMIT 1) AS last_message, ( SELECT count(*) FROM zip_messages WHERE fk_group_id = group_id) AS message_count FROM zip_groups, fa_user WHERE fk_owner = id AND group_id =