Не понял логики, для чего такой запрос? modules/mod_comments

		$sql = "SELECT c.id as id,
                       c.target as target,
                       c.target_id as target_id,
                       c.target_link as target_link, 
					   c.target_title,
                       c.content as content,
                       c.guestname,
                       c.pubdate as fpubdate,
                       IFNULL(c.user_id, 0) as user_id,
                       IFNULL(u.nickname, '') as author,
                       IFNULL(u.login, '') as author_login,
                       IFNULL(v.total_rating, 0) as rating
				FROM cms_comments c
				INNER JOIN cms_users u ON u.id = c.user_id {$guest_sql}
                LEFT JOIN cms_ratings_total v ON v.item_id=c.id AND v.target='comment'
				WHERE c.published=1 {$hidden_sql} {$target_where}
                GROUP BY c.id
                ORDER BY c.id DESC
                LIMIT 70";