SELECT ws.Name as 'Название сервиса', us.Email, ub.StateVal, ub.BindKey FROM [IMKORelease].[dbo].[user_User] us
inner join [IMKORelease].[dbo].[wapi_UserBind] ub on us.UserId = ub.UserId
inner join [IMKORelease].[dbo].[wapi_Service] ws on ws.ServiceId = ub.ServiceId
where us.Email like '%<Почта клиента>%' |