SELECT
    P.system_id AS systemId,
    P.person_id AS personId,
    P.email AS email,
    P.employee_code AS employeeCode,
    P.bar_code AS barCode,
    P.rfid AS rfid,
    P.card_number AS cardNumber,
    P.first_name AS firstName,
    P.last_name AS lastName,
    P.primary_telephone AS primaryTelephone,
    P.address1 AS address1,
    P.address2 AS address2,
    P.city AS city,
    P.country AS country,
    P.state_province_region AS stateProvinceRegion,
    P.zip_or_postal_code AS zipOrPostalCode,
    (CASE WHEN A.membershipEnd IS NULL THEN  0 ELSE  1 END) AS deleted,
    P.is_blocked AS blocked,
    A.lastModified AS modifiedAt,
    P.created_at AS createdAt
FROM
    (
        SELECT
            P.person_id AS personId,
            MAX(P.modified_at, UGM.modified_at) AS lastModified,
            UGM.end_date  AS membershipEnd
        FROM
            user_group_membership UGM
                LEFT JOIN person P
                          ON
                                  UGM.member = P.person_id
        WHERE
                UGM.user_group_membership_id IN (
                SELECT
                    MAX(UGM.user_group_membership_id)
                FROM
                    user_group_membership UGM
                        LEFT JOIN person P ON
                            UGM.member = P.person_id
                WHERE
                        P.customer_id = :customerparam
                  AND UGM.customer_id = :customerparam
                  AND UGM.assigned_group_id = :groupparam
                  AND (UGM.modified_at >= :update_after OR P.modified_at >= :update_after )
                GROUP BY
                    UGM.member)) A

        LEFT JOIN person P
                  ON A.personId = P.person_id
WHERE
        A.lastmodified > :update_after
   OR ( A.lastmodified = :update_after
    AND A.personId > :person_id )
ORDER BY
    A.lastmodified ASC,
    A.personId ASC
    LIMIT  :limit OFFSET :offset