-- 更新staff_assess
WITH t_staff_assess AS (
    SELECT
        *
    FROM
        staff_assess
    WHERE
        1 = 1
        AND cycle_id = 1653724699349225472
        AND NOT EXISTS (
            SELECT
                *
            FROM
                staff_assess_content
            WHERE
                staff_assess_content.staff_assess_id = staff_assess.id))
UPDATE
    staff_assess
SET
    deleted_at = now()
WHERE
    1 = 1
    AND staff_assess.id IN (
        SELECT
            id
        FROM
            t_staff_assess);

-- 更新staff_assess
WITH t_staff_assess AS (
    SELECT
        row_number() OVER (PARTITION BY evaluation_project_id,
            "types",
            staff_assess.begin_time) AS row_id,
        *
    FROM
        staff_assess
    WHERE
        1 = 1
        AND cycle_id = 1653724699349225472
        AND NOT EXISTS (
            SELECT
                *
            FROM
                staff_assess_content
            WHERE
                staff_assess_content.staff_assess_id = staff_assess.id)
),
t_staff_assess_2 AS (
    SELECT
        *
    FROM
        t_staff_assess
    WHERE
        row_id = 1)
UPDATE
    staff_assess
SET
    deleted_at = NULL
WHERE
    1 = 1
    AND cycle_id = 1653724699349225472
    AND staff_assess.id IN (
        SELECT
            id
        FROM
            t_staff_assess_2);

;

UPDATE
    staff_assess
SET
    deleted_at = now()
WHERE
    id IN (18404, 18458);