为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】：
【CPU】:
【问题描述】*： group by语句报"不是 GROUP BY 表达式"

SELECT
		"u"."user_id",
		"info"."name" AS "user_name",
		ifnull( "pv"."value", '' ) AS "user_post_name",
		ifnull( "info"."headimg_url", '' ) AS "headimg_url",
		"info"."mobile",
		ifnull(( SELECT 1 FROM MYCOMMUNITY_SZJGXCTEST.q_im_user "iu" WHERE "iu"."user_id" = "info"."id" AND "iu"."is_deleted" = 0 LIMIT 1 ), 0 ) AS "is_im_user",
		ifnull( "vl"."live_room_id", '' ) AS "live_room_id",
		"vl"."start_time",
		ifnull( "vl"."live_status", 0 ) AS "live_status",
		"vl"."audience" AS "audience",
		ifnull( "vl"."public", 0 ) AS "public" 
	FROM
		(
		SELECT
			"user_id" 
		FROM
			MYCOMMUNITY_SZJGXCTEST.map_user_project
		WHERE
			"proj_id" = '3a0b697b-d753-b2ee-5f5d-fdef419c14f0'
			AND "user_id" IN (
			SELECT
				"user_id" 
			FROM
				MYCOMMUNITY_SZJGXCTEST.map_user_function
			WHERE
				"function_id" = ifnull(( SELECT "id" FROM MYCOMMUNITY_SZJGXCTEST.t_access_function WHERE "app_code" = 'ZJ_Other' AND "function_code" = 'clairvoyance-live-launch' AND "is_deleted" = 0 LIMIT 1 ), 0 ) 
				OR "function_id" = ifnull(( SELECT "id" FROM MYCOMMUNITY_SZJGXCTEST.t_access_function WHERE "app_code" = 'AiotClairvoyance' AND "function_code" = 'clairvoyance-live-launch' AND "is_deleted" = 0 LIMIT 1 ), 0 ) 
			OR "function_id" = ifnull(( SELECT "id" FROM MYCOMMUNITY_SZJGXCTEST.t_access_function WHERE "app_code" = 'MobileCheckQuality' AND "function_code" = 'clairvoyance-live-launch' AND "is_deleted" = 0 LIMIT 1 ), 0 )) 
		GROUP BY
			"user_id" 
		) AS "u"
		INNER JOIN MYCOMMUNITY_SZJGXCTEST.t_user AS "info" ON "info"."id" = "u"."user_id" 
		AND "info"."is_deleted" = 0
		LEFT JOIN MYCOMMUNITY_SZJGXCTEST.t_user_post_org AS "up" ON "up"."user_id" = "u"."user_id" 
		AND "up"."is_deleted" = 0
		LEFT JOIN MYCOMMUNITY_SZJGXCTEST.t_parameter_value AS "pv" ON "up"."post_id" = "pv"."id" 
		AND "pv"."is_deleted" = 0
		LEFT JOIN MYCOMMUNITY_SZJGXCTEST.q_video_live "vl" ON "vl"."user_id" = "u"."user_id" 
		AND "vl"."proj_id" = '3a0b697b-d753-b2ee-5f5d-fdef419c14f0'
		AND "vl"."is_deleted" = 0 
		AND "vl"."audience" = 1 
	GROUP BY
		"u"."user_id" 

附：