$query = "
				SELECT s.subject_title, c.connection_avatar, c.connection_openid, 
				COUNT(r.reply_id) AS tot_replies, s.subject_id
				FROM " . $this->am_storage->prefix . "_plugin_forum_subject s
				INNER JOIN " . $this->am_storage->prefix . "_connection c
				ON s.connection_id=c.connection_id
				LEFT JOIN " . $this->am_storage->prefix . "_plugin_forum_reply r
				ON s.subject_id=r.subject_id
				GROUP BY s.subject_id"
			;