Hour is : 13
SELECT r.id responseId,rem.note,d.url_host,d.url_path,t.*,
rd.*,r.*,d.consult_date,d.created data_created,d.lead_status,d.data,c.header_image,c.footer_image,c.auto_days,c.id clientId
,c.user_ctype,c.v2move,c.url,c.opticall_client,c.email client_email,c.name client_name,ts.server serverTask
,ts.completed,ts.message task_message,ts.send_email send_email_task,f.glc_form_id,f.name_field,f.email_field,f.phone_field,d.seminar_id,ts.data_id taskDataId
,rf.refer_name referrer_name,rf.practice_name referrer_practice from fs_responses r
left join fs_datas d on r.data_id=d.id
left join fs_forms f on f.id=r.form_id and f.client_id = r.client_id
left join fs_clients c on c.id=r.client_id
left join fs_responders rd on r.responder_id=rd.id
left join fs_reminder as rem on rem.id = r.reminderid
left join fs_templates t on rd.template_id=t.id and t.client_id= r.client_id
left join fs_tasks ts on r.task_id=ts.id
left join fs_ods rf on d.ref_id=rf.id
where ((r.reminderid=0 and r.task_id=0 and r.only_test=0 and rd.opened=1) or r.only_test=1 or r.task_id>0 or r.reminderid> 0) and r.sending_date<='2025-04-05 13:31:59' and r.success=0 and isnull(sent_date)
order by r.sending_date desc
limit 5
Total row count : 5
Total Only :5
Mailer Error: SMTP Error: Could not connect to SMTP host.Mailer Error: SMTP Error: Could not connect to SMTP host.UPDATE fs_responses SET success=3 WHERE id=17025302 - Waiting : 8579306-meghnachunduru@gmail.com
Mailer Error: SMTP Error: Could not connect to SMTP host.UPDATE fs_responses SET success=3 WHERE id=16969877 - Waiting : 8276273-lisa.ong818@gmail.com
Total Sent Email : 0