"select top(50) u.ID_USER, aa.* from USERS as u left join ACTIVITIES as aa on aa.ID_USER = u.ID_USER and aa.ACTIVITY_TYPE='" + Activity.ACTIVITY_TYPE.DOG_PURCHASE + "' and aa.ID_TRANSACTION <> 0 and aa.ID_TRANSACTION > 0 and  aa.DATE>@date where  ID_ACTIVITY is null"
                        , new SqlParameter("@date", DateTime.UtcNow.Date.AddDays(-7))

select top (10) * from MessageQueue as mq left join CommunicationCanal as cc on cc.USER_ID = mq.User_ID " +
                        "left join USERS as usr on usr.ID_USER=mq.User_ID where mq.Sent=0"