QUERY SYMAX REGISTER

UPDATE GENERAL ANGGOTA VARIANT
UPDATE
    tb_anggota ta2
SET
    ta2.id_variant = (
        SELECT
            (
                CASE
                    WHEN mm.id_member IS NOT NULL AND ml.id_loyal IS NULL THEN 6
                    WHEN ml.id_loyal IS NOT NULL THEN 5
                    ELSE 7
                END
            ) AS new_variant
        FROM
            tb_anggota ta
        LEFT JOIN md_member mm ON
            ta.pmi_id = mm.person_id
        LEFT JOIN md_loyal ml ON
            ta.pmi_id = ml.pmi_id
        LEFT JOIN md_variant mv ON
            ta.id_variant = mv.id_variant
        WHERE
            ta2.id_anggota = ta.id_anggota
)
WHERE EXISTS (
    SELECT 1
    FROM tb_anggota ta
    WHERE ta2.id_anggota = ta.id_anggota
)
AND
ta2.id_login = 'LGN_RZLD66f'
-------------------------------------------------------------------------------------------------------------------------------------
GET EXPECTED VARIANT
SELECT
    ta.id_anggota ,
    mv.id_variant AS old_variant,
    (
        CASE
            WHEN mm.id_member IS NOT NULL AND ml.id_loyal IS NULL THEN 6
            WHEN ml.id_loyal IS NOT NULL THEN 5
            ELSE 7
        END
    ) AS new_variant
FROM
    tb_anggota ta
LEFT JOIN md_member mm ON
    ta.pmi_id = mm.person_id
LEFT JOIN md_loyal ml ON
    ta.pmi_id = ml.pmi_id
LEFT JOIN md_variant mv ON
    ta.id_variant = mv.id_variant
WHERE
    ta.id_login = 'LGN_RZLD66f'