SeLECT DISTINCT P.iPhone
FROM    dbo.mem_tbl_PhoneList P
INNER JOIN rpt_tbl_MemberLTV M
  ON M.iMemberID = P.iMemberID
WHERE P.iPhone <> '8776356225'
AND  P.iPhone NOT IN ( SELECT iPhone FROM    glb_lkp_CallerID  )
AND  ( dtCanceled IS NULL OR dtCanceled > DATEADD( MONTH, -12, GETDATE()) )
