Thursday 28th of March 2024 07:21:22 PM
SMS
Thursday 28th of March 2024 07:21:22 PM
DRIP
Thursday 28th of March 2024 07:21:22 PM
COUNTER1
START
Thursday 28th of March 2024 07:21:22 PM
Thursday 28th of March 2024 07:21:22 PM
select distinct *, r.campaign as rcampaign from realtors r join prospects p on r.pk_realtor = p.fk_realtor join emails e where p.pdone = 0 and r.realtor_status <> 'terminated' and ifnull(r.toolkit_email,'') > '' and ifnull(r.toolkit_first_name,'') > '' and ifnull(r.toolkit_last_name,'') > '' and p.optout_flag = 0 and p.stop_flag = 0 and ((to_days(now()) - to_days(p.created_date)) * 24 + hour(now()) - hour(p.created_date)) >= e.hours and e.campaign = p.campaign and e.face = r.face and e.subject is not null and ifnull(prospect_email,'') > '' and e.locale = r.locale and (e.hours > p.last_email_hours or p.last_email_hours is null) and r.fk_user not in (select pk_user from users where account_status = 'terminated') and e.realtor_id = r.realtor_id order by e.hours, e.subject
Thursday 28th of March 2024 07:21:22 PM
TOTAL ROWS 0
Thursday 28th of March 2024 07:21:22 PM
COUNTER2
START
Thursday 28th of March 2024 07:21:22 PM
Thursday 28th of March 2024 07:21:22 PM
select distinct *, r.campaign as rcampaign from realtors r join prospects p on r.pk_realtor = p.fk_realtor join email_defaults e USE INDEX (campaign_face) where p.pdone = 0 and r.realtor_status <> 'terminated' and ifnull(r.toolkit_email,'') > '' and ifnull(r.toolkit_first_name,'') > '' and ifnull(r.toolkit_last_name,'') > '' and p.optout_flag = 0 and p.stop_flag = 0 and ((to_days(now()) - to_days(p.created_date)) * 24 + hour(now()) - hour(p.created_date)) >= e.hours and e.campaign = p.campaign and e.face = r.face and e.subject is not null and ifnull(prospect_email,'') > '' and e.locale = r.locale and (e.hours > p.last_email_hours or p.last_email_hours is null) and r.fk_user not in (select pk_user from users where account_status = 'terminated') and not exists (select 1 from emails em use index (cam_re_face) where em.realtor_id = r.realtor_id and em.face = r.face and em.campaign = p.campaign) order by e.hours, e.subject
Thursday 28th of March 2024 07:21:22 PM
TOTAL ROWS 0
Thursday 28th of March 2024 07:21:22 PM
LATE-
Thursday 28th of March 2024 07:21:22 PM