SELECT
  CONCAT(mvs.member_club, mvs.member_account, mvs.member_card) AS membership,
  moi.verification_status AS Info_Status,
  mvs.verification_status AS Membership_Status,
  mvs.date_email_verified,
  mvs.date_verified,
  mvs.verified_by
FROM psmt_accounts_api_memb_stage.member_onboarding_info AS moi
JOIN psmt_accounts_api_memb_stage.membership_verification_status mvs ON mvs.info_verified = moi.id
WHERE moi.member_club IN (
            SELECT
              moi.member_club
              -- CONCAT(mvs.member_club, mvs.member_account, mvs.member_card) AS membership

            FROM psmt_accounts_api_memb_stage.member_onboarding_info AS moi
            JOIN psmt_accounts_api_memb_stage.membership_verification_status mvs ON mvs.info_verified = moi.id
            WHERE
                mvs.member_club = "6101"
                OR mvs.member_club = "6105"
                OR mvs.member_club = "6107"
                OR mvs.member_club = "6401"
                OR mvs.member_club = "6403"
                OR mvs.member_club = "6404"
                OR mvs.member_club = "6801"
                OR mvs.member_club = "6802"
                OR mvs.member_club = "8002"
            -- ORDER BY mvs.member_club ASC, mvs.member_account ASC, mvs.member_card ASC
        )
    AND moi.member_account IN (
            SELECT
              moi.member_account
            FROM psmt_accounts_api_memb_stage.member_onboarding_info AS moi
            JOIN psmt_accounts_api_memb_stage.membership_verification_status mvs ON mvs.info_verified = moi.id
            WHERE
                mvs.member_account = "098943"
                OR mvs.member_account = "033396"
                OR mvs.member_account = "018623"
                OR mvs.member_account = "100406"
                OR mvs.member_account = "161040"
                OR mvs.member_account = "240898"
                OR mvs.member_account = "021003"
                OR mvs.member_account = "034896"
                OR mvs.member_account = "034896"
                OR mvs.member_account = "012558"
                OR mvs.member_account = "035886"
                OR mvs.member_account = "077183"
                OR mvs.member_account = "000191"
                OR mvs.member_account = "003007"
                OR mvs.member_account = "141031"
                OR mvs.member_account = "068757"
                OR mvs.member_account = "103089"
                OR mvs.member_account = "042396"
        )
    AND moi.member_card IN (
            SELECT
              moi.member_card
            FROM psmt_accounts_api_memb_stage.member_onboarding_info AS moi
            JOIN psmt_accounts_api_memb_stage.membership_verification_status mvs ON mvs.info_verified = moi.id
            WHERE
                mvs.member_card = "0001"
                OR mvs.member_card = "0002"
                OR mvs.member_card = "0003"
                OR mvs.member_card = "0004"
        )
HAVING membership IN ("61010989430003", "61050333960002", "61070186230002", "64011004060001",
"64011610400001", "64012408980001", "64030210030001", "64030348960001",
"64030348960001", "64040125580001", "64040358860001", "64040771830001",
"68010001910005", "68010030070001", "68011410310004", "68020687570001",
"68021030890002", "80020423960001")
ORDER BY mvs.member_club ASC,
  mvs.member_account ASC,
  mvs.member_card ASC