SELECT *FROM "SMNTP_VENDOR_INVITE" SVI LEFT JOIN "SMNTP_VENDOR" SV ON "SVI"."VENDOR_INVITE_ID" = "SV"."VENDOR_INVITE_ID"LEFT JOIN "SMNTP_VENDOR_BRAND" SVB ON "SVB"."VENDOR_ID" = "SV"."VENDOR_ID"LEFT JOIN "SMNTP_VENDOR_REP" SVR ON "SVR"."VENDOR_ID" = "SV"."VENDOR_ID"JOIN "SMNTP_VENDOR_STATUS" SVS ON "SVI"."VENDOR_INVITE_ID" = "SVS"."VENDOR_INVITE_ID"JOIN "SMNTP_STATUS" SS ON "SVS"."STATUS_ID" = "SS"."STATUS_ID"JOIN "SMNTP_USERS_MATRIX" UM ON "SVI"."CREATED_BY" = "UM"."USER_ID"LEFT JOIN "SMNTP_STATUS_CONFIG" SSC ON "SVS"."STATUS_ID" = "SSC"."CURRENT_STATUS_ID" AND SSC.CURRENT_POSITION_ID = SVS.POSITION_ID AND (SVS.POSITION_ID = 3 OR SVS.POSITION_ID =0)LEFT JOIN "SMNTP_MESSAGES" MES ON "MES"."INVITE_ID" = "SVI"."VENDOR_INVITE_ID" AND MES.RECIPIENT_ID = 4596487 AND MES.IS_READ = -1 WHERE "UM"."BUHEAD_ID" =  '4596487' AND "SVI"."BUSINESS_TYPE" IN (1, 3);