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