
            select
                 count(  * ) AS cnt 
            from
                -- from
                msg.v_Message M
                left join msg.v_MessageLink ML on ML.Message_id = M.Message_id

                --left join msg.v_NoticeType NT  on NT.NoticeType_id = M.NoticeType_id

                left join msg.v_MessageRecipient MR  on MR.Message_id = M.Message_id
                left join pmUserCache MP  on MP.PMUser_id = '391875777153'

                left join v_Evn E  on E.Evn_id = M.Evn_id

                left join v_Evn rEvn  on rEvn.Evn_id = E.Evn_rid

                left join v_Person_all P  on P.Person_id=E.Person_id and P.PersonEvn_id=E.PersonEvn_id
                left join v_Evnxml exml on e.Evn_rid = exml.Evn_id
                left join msg.v_messagerecipient vmr on (M.message_id = vmr.message_id and vmr.userrecipient_id = '391875777153')

                -- end from
            where
                -- where

                 M.Evn_id is not null and E.EvnClass_SysNick is not null and M.UserSend_ID = 0  and MR.UserRecipient_id = '391875777153' and M.Message_isSent is not null
                -- end where
            
        
