Group By

SELECT aaa.* FROM (SELECT
        n.REVISION,
        n.CREATED_BY,
        n.CREATED_TIME,
        n.UPDATED_BY,
        n.UPDATED_TIME,
        n.categoryId,
        (
        SELECT
        NAME
        FROM
        category
        WHERE
        id = n.categoryId
        ) categoryName,
        n.learningVolume,
        n.id,
        n.newsName,
        n.newsCode,
        n.title,
        n.subtitle,
        (
        SELECT
        url
        FROM
        file
        WHERE
        id = n.thumbnail
        ) AS thumbnail,
        n.source,
        n.content,
        n.isRelease,
        n.releaseDate,
        n.pageviews,
        n.collection,
        any_value(b.CREATED_TIME) as CREATED_TIME1
        FROM
        news AS n
        LEFT JOIN (
        SELECT
        *
        FROM
        (
        SELECT
        *
        FROM
        recording
        WHERE
        userId = #{condition.userId}
        AND REVISION = 0
        AND type = 0
        AND sort = 1
        ORDER BY
        CREATED_TIME DESC
        ) a
        ORDER BY
        a.CREATED_TIME DESC
        ) AS b ON n.id = b.newsId
        WHERE
        n.REVISION = 0
        AND n.isRelease = 1
        AND b.REVISION = 0
        <if test="condition.name != null and condition.name != ''">
            AND n.newsName LIKE concat('%',#{condition.name},'%')
        </if>
        <if test="condition.userId != null and condition.userId != ''">
            AND b.userId = #{condition.userId}
        </if>
        AND b.type = #{condition.recordingType}
        ORDER BY b.id desc) aaa GROUP BY aaa.id ORDER BY CREATED_TIME1 DESC
        LIMIT #{condition.limit}