UPDATE my_temp_table250825121021249081303 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-08-25 12:10:26

update my_temp_table250825121021249081303  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=14 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-08-25 12:10:26

update my_temp_table250825121021249081303  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=14, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-08-25 12:10:26

UPDATE campaign_mapping_1 t1 JOIN my_temp_table250825121021249081303 t2 ON t1.master_id = t2.master_id SET t1.dialed=t2.dialed,t1.CallAgainTime= t2.CallAgainTime, t1.CallAgainType=t2.CallAgainType,t1.stopcalling=t2.stopcalling WHERE t1.FileId =14  AND t1.campaign_id=t2.campaign_id; — 2025-08-25 12:10:26

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,agent  FROM my_temp_table250825121021249081303 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-08-25 12:10:26

update my_temp_table250825121021249081303  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 14 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-08-25 12:10:27

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 14,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table250825121021249081303 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id and t1.File_id =t2.FileId WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null — 2025-08-25 12:10:27

UPDATE my_temp_table250825145201596158419 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-08-25 14:52:02

update my_temp_table250825145201596158419  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=14 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-08-25 14:52:02

update my_temp_table250825145201596158419  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=14, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-08-25 14:52:02

UPDATE campaign_mapping_1 t1 JOIN my_temp_table250825145201596158419 t2 ON t1.master_id = t2.master_id SET t1.dialed=t2.dialed,t1.CallAgainTime= t2.CallAgainTime, t1.CallAgainType=t2.CallAgainType,t1.stopcalling=t2.stopcalling WHERE t1.FileId =14  AND t1.campaign_id=t2.campaign_id; — 2025-08-25 14:52:02

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,agent  FROM my_temp_table250825145201596158419 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-08-25 14:52:02

update my_temp_table250825145201596158419  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 14 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-08-25 14:52:02

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 14,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table250825145201596158419 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id and t1.File_id =t2.FileId WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null — 2025-08-25 14:52:02

UPDATE my_temp_table2509111722122112773434 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-11 17:22:13

update my_temp_table2509111722122112773434  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=25 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-11 17:22:13

update my_temp_table2509111722122112773434  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=25, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-11 17:22:13

UPDATE campaign_mapping_1 t1 JOIN my_temp_table2509111722122112773434 t2 ON t1.master_id = t2.master_id SET t1.dialed=t2.dialed,t1.CallAgainTime= t2.CallAgainTime, t1.CallAgainType=t2.CallAgainType,t1.stopcalling=t2.stopcalling WHERE t1.FileId =25  AND t1.campaign_id=t2.campaign_id; — 2025-09-11 17:22:13

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table2509111722122112773434 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-11 17:22:13

update my_temp_table2509111722122112773434  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 25 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-11 17:22:13

UPDATE my_temp_table2509121105391734389098 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 11:05:40

update my_temp_table2509121105391734389098  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 11:05:40

update my_temp_table2509121105391734389098  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 11:05:40

UPDATE campaign_mapping_1 t1 JOIN my_temp_table2509121105391734389098 t2 ON t1.master_id = t2.master_id SET t1.dialed=t2.dialed,t1.CallAgainTime= t2.CallAgainTime, t1.CallAgainType=t2.CallAgainType,t1.stopcalling=t2.stopcalling WHERE t1.FileId =26  AND t1.campaign_id=t2.campaign_id; — 2025-09-12 11:05:40

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table2509121105391734389098 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 11:05:40

update my_temp_table2509121105391734389098  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 26 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 11:05:40

UPDATE my_temp_table250912110651826113698 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 11:06:51

update my_temp_table250912110651826113698  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 11:06:52

update my_temp_table250912110651826113698  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 11:06:52

UPDATE campaign_mapping_1 t1 JOIN my_temp_table250912110651826113698 t2 ON t1.master_id = t2.master_id SET t1.dialed=t2.dialed,t1.CallAgainTime= t2.CallAgainTime, t1.CallAgainType=t2.CallAgainType,t1.stopcalling=t2.stopcalling WHERE t1.FileId =26  AND t1.campaign_id=t2.campaign_id; — 2025-09-12 11:06:52

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table250912110651826113698 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 11:06:52

update my_temp_table250912110651826113698  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 26 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 11:06:52

UPDATE my_temp_table2509121107452068658259 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 11:07:46

update my_temp_table2509121107452068658259  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 11:07:46

update my_temp_table2509121107452068658259  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 11:07:46

UPDATE campaign_mapping_1 t1 JOIN my_temp_table2509121107452068658259 t2 ON t1.master_id = t2.master_id SET t1.dialed=t2.dialed,t1.CallAgainTime= t2.CallAgainTime, t1.CallAgainType=t2.CallAgainType,t1.stopcalling=t2.stopcalling WHERE t1.FileId =26  AND t1.campaign_id=t2.campaign_id; — 2025-09-12 11:07:46

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table2509121107452068658259 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 11:07:46

update my_temp_table2509121107452068658259  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 26 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 11:07:46

UPDATE   my_temp_table2509121107452068658259  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID JOIN campaign_mapping_1 cmpMap ON cmpMap.master_id=t2.id and cmpMap.FileId=26   SET import_status =1  — 2025-09-12 11:07:46

UPDATE my_temp_table2509121108031332739378 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 11:08:04

update my_temp_table2509121108031332739378  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 11:08:04

update my_temp_table2509121108031332739378  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 11:08:04

UPDATE campaign_mapping_1 t1 JOIN my_temp_table2509121108031332739378 t2 ON t1.master_id = t2.master_id SET t1.dialed=t2.dialed,t1.CallAgainTime= t2.CallAgainTime, t1.CallAgainType=t2.CallAgainType,t1.stopcalling=t2.stopcalling WHERE t1.FileId =26  AND t1.campaign_id=t2.campaign_id; — 2025-09-12 11:08:04

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table2509121108031332739378 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 11:08:04

update my_temp_table2509121108031332739378  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 26 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 11:08:04

UPDATE   my_temp_table2509121108031332739378  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID JOIN campaign_mapping_1 cmpMap ON cmpMap.master_id=t2.id and cmpMap.FileId=26   SET t1.import_status =1  — 2025-09-12 11:08:04

UPDATE my_temp_table250912131651409217156 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 13:16:52

update my_temp_table250912131651409217156  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 13:16:52

update my_temp_table250912131651409217156  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 13:16:52

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table250912131651409217156 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 13:16:52

update my_temp_table250912131651409217156  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 26 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 13:16:52

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 26,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table250912131651409217156 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id  WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null — 2025-09-12 13:16:52

UPDATE my_temp_table2509121320581491076285 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 13:20:59

update my_temp_table2509121320581491076285  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 13:20:59

update my_temp_table2509121320581491076285  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 13:20:59

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table2509121320581491076285 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 13:20:59

update my_temp_table2509121320581491076285  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 26 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 13:20:59

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 26,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table2509121320581491076285 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id  WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null — 2025-09-12 13:20:59

UPDATE my_temp_table250912132112939642035 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 13:21:13

update my_temp_table250912132112939642035  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=27 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 13:21:13

update my_temp_table250912132112939642035  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=27, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 13:21:13

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table250912132112939642035 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 13:21:13

update my_temp_table250912132112939642035  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 27 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 13:21:13

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 27,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table250912132112939642035 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id  WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null — 2025-09-12 13:21:13

UPDATE my_temp_table2509121322461765162777 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 13:22:48

update my_temp_table2509121322461765162777  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=27 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 13:22:48

update my_temp_table2509121322461765162777  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=27, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 13:22:48

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table2509121322461765162777 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 13:22:48

update my_temp_table2509121322461765162777  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 27 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 13:22:48

UPDATE my_temp_table2509121334221320969731 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 13:34:22

update my_temp_table2509121334221320969731  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=27 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 13:34:22

update my_temp_table2509121334221320969731  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=27, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 13:34:22

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table2509121334221320969731 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 13:34:22

update my_temp_table2509121334221320969731  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 27 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 13:34:22

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 27,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table2509121334221320969731 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id  WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null — 2025-09-12 13:34:22

UPDATE my_temp_table2509121334522060323521 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 13:34:53

update my_temp_table2509121334522060323521  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 13:34:53

update my_temp_table2509121334522060323521  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 13:34:53

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table2509121334522060323521 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 13:34:53

update my_temp_table2509121334522060323521  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 31 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 13:34:53

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 31,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table2509121334522060323521 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id  WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null — 2025-09-12 13:34:53

UPDATE my_temp_table250912143443929329700 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 14:34:44

update my_temp_table250912143443929329700  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:34:44

update my_temp_table250912143443929329700  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:34:44

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table250912143443929329700 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 14:34:44

update my_temp_table250912143443929329700  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 31 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 14:34:44

UPDATE my_temp_table2509121437142119474425 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 14:37:14

update my_temp_table2509121437142119474425  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:37:14

update my_temp_table2509121437142119474425  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:37:14

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table2509121437142119474425 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 14:37:14

update my_temp_table2509121437142119474425  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 31 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 14:37:14

UPDATE   my_temp_table2509121437142119474425  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID JOIN campaign_mapping_1 cmpMap ON cmpMap.master_id=t2.id and cmpMap.FileId=31   SET t1.import_status =1  — 2025-09-12 14:37:14

UPDATE my_temp_table2509121437251523689964 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 14:37:25

update my_temp_table2509121437251523689964  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:37:25

update my_temp_table2509121437251523689964  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:37:25

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table2509121437251523689964 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 14:37:25

update my_temp_table2509121437251523689964  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 31 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 14:37:25

UPDATE   my_temp_table2509121437251523689964  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID JOIN campaign_mapping_1 cmpMap ON cmpMap.master_id=t2.id and cmpMap.FileId=31   SET t1.import_status =1  — 2025-09-12 14:37:25

UPDATE my_temp_table2509121439162068237056 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 14:39:17

update my_temp_table2509121439162068237056  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:39:17

update my_temp_table2509121439162068237056  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:39:17

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table2509121439162068237056 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 14:39:17

update my_temp_table2509121439162068237056  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 31 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 14:39:17

UPDATE   my_temp_table2509121439162068237056  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID JOIN campaign_mapping_1 cmpMap ON cmpMap.master_id=t2.id and cmpMap.FileId=31   SET t1.import_status =1  — 2025-09-12 14:39:17

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 31,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table2509121439162068237056 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id and t1.File_id =t2.FileId WHEREt1.process_id=1 AND t1.master_id is not null and t2.map_id is null  and t1.import_status=1 — 2025-09-12 14:39:17

UPDATE my_temp_table2509121440048839687 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 14:40:04

update my_temp_table2509121440048839687  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:40:04

update my_temp_table2509121440048839687  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:40:04

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table2509121440048839687 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 14:40:04

update my_temp_table2509121440048839687  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 31 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 14:40:04

UPDATE   my_temp_table2509121440048839687  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID JOIN campaign_mapping_1 cmpMap ON cmpMap.master_id=t2.id and cmpMap.FileId=31   SET t1.import_status =1  — 2025-09-12 14:40:04

UPDATE my_temp_table25091214423011628688 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 14:42:31

update my_temp_table25091214423011628688  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:42:31

update my_temp_table25091214423011628688  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:42:31

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table25091214423011628688 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 14:42:31

update my_temp_table25091214423011628688  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 31 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 14:42:31

UPDATE   my_temp_table25091214423011628688  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID JOIN campaign_mapping_1 cmpMap ON cmpMap.master_id=t2.id and cmpMap.FileId=31   SET t1.import_status =1  — 2025-09-12 14:42:31

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 31,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table25091214423011628688 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id and t1.File_id =t2.FileId WHEREt1.process_id=1 AND t1.master_id is not null and t2.map_id is null  and t1.import_status=1 — 2025-09-12 14:42:31

UPDATE my_temp_table250912144251961649551 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 14:42:51

update my_temp_table250912144251961649551  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:42:51

update my_temp_table250912144251961649551  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:42:51

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table250912144251961649551 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 14:42:51

update my_temp_table250912144251961649551  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 31 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 14:42:51

UPDATE   my_temp_table250912144251961649551  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID JOIN campaign_mapping_1 cmpMap ON cmpMap.master_id=t2.id and cmpMap.FileId=31   SET t1.import_status =1  — 2025-09-12 14:42:51

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 31,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table250912144251961649551 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id and t1.File_id =t2.FileId WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null  and t1.import_status=1 — 2025-09-12 14:42:51

UPDATE my_temp_table2509121442571763235077 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 14:42:58

update my_temp_table2509121442571763235077  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:42:58

update my_temp_table2509121442571763235077  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:42:58

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table2509121442571763235077 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 14:42:58

update my_temp_table2509121442571763235077  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 26 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 14:42:58

UPDATE   my_temp_table2509121442571763235077  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID JOIN campaign_mapping_1 cmpMap ON cmpMap.master_id=t2.id and cmpMap.FileId=26   SET t1.import_status =1  — 2025-09-12 14:42:58

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 26,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table2509121442571763235077 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id and t1.File_id =t2.FileId WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null  and t1.import_status=1 — 2025-09-12 14:42:58

UPDATE my_temp_table2509121443171108200968 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 14:43:17

update my_temp_table2509121443171108200968  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:43:17

update my_temp_table2509121443171108200968  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:43:17

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table2509121443171108200968 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 14:43:17

update my_temp_table2509121443171108200968  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 26 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 14:43:17

UPDATE   my_temp_table2509121443171108200968  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID JOIN campaign_mapping_1 cmpMap ON cmpMap.master_id=t2.id and cmpMap.FileId=26   SET t1.import_status =1  — 2025-09-12 14:43:17

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 26,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table2509121443171108200968 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id and t1.File_id =t2.FileId WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null  and t1.import_status=1 — 2025-09-12 14:43:17

UPDATE my_temp_table2509121445221013577108 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 14:45:23

update my_temp_table2509121445221013577108  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:45:23

update my_temp_table2509121445221013577108  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:45:23

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table2509121445221013577108 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 14:45:23

update my_temp_table2509121445221013577108  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 26 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 14:45:23

UPDATE my_temp_table250912145747290197218 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 14:57:48

update my_temp_table250912145747290197218  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:57:48

update my_temp_table250912145747290197218  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:57:48

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table250912145747290197218 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 14:57:48

update my_temp_table250912145747290197218  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 26 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 14:57:48

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 26,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table250912145747290197218 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id and t1.File_id =t2.FileId WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null  and t1.import_status=0 — 2025-09-12 14:57:48

UPDATE my_temp_table250912145814516483973 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 14:58:15

update my_temp_table250912145814516483973  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:58:15

update my_temp_table250912145814516483973  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:58:15

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table250912145814516483973 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 14:58:15

update my_temp_table250912145814516483973  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 26 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 14:58:15

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 26,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table250912145814516483973 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id and t1.File_id =t2.FileId WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null  and t1.import_status=0 — 2025-09-12 14:58:15

UPDATE my_temp_table250912145958600212094 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 14:59:59

update my_temp_table250912145958600212094  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:59:59

update my_temp_table250912145958600212094  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 14:59:59

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table250912145958600212094 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 14:59:59

update my_temp_table250912145958600212094  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 26 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 14:59:59

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 26,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table250912145958600212094 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id and t1.File_id =t2.FileId WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null  and t1.import_status=0 — 2025-09-12 14:59:59

UPDATE my_temp_table2509121502441377063260 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 15:02:45

update my_temp_table2509121502441377063260  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 15:02:45

update my_temp_table2509121502441377063260  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 15:02:45

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table2509121502441377063260 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 15:02:45

update my_temp_table2509121502441377063260  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 26 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 15:02:45

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 26,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table2509121502441377063260 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id and t1.File_id =t2.FileId WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null  and t1.import_status=0 — 2025-09-12 15:02:45

UPDATE my_temp_table2509121508572076747684 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 15:08:58

update my_temp_table2509121508572076747684  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 15:08:58

update my_temp_table2509121508572076747684  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 15:08:58

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table2509121508572076747684 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 15:08:58

update my_temp_table2509121508572076747684  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 26 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 15:08:58

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 26,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table2509121508572076747684 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id and t1.File_id =t2.FileId WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null  and t1.import_status=0 — 2025-09-12 15:08:58

UPDATE my_temp_table250912150931636995291 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 15:09:31

update my_temp_table250912150931636995291  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 15:09:31

update my_temp_table250912150931636995291  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 15:09:31

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table250912150931636995291 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 15:09:31

update my_temp_table250912150931636995291  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 26 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 15:09:32

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 26,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table250912150931636995291 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id and t1.File_id =t2.FileId WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null  and t1.import_status=0 — 2025-09-12 15:09:32

UPDATE my_temp_table250912150945833932809 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 15:09:46

update my_temp_table250912150945833932809  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 15:09:46

update my_temp_table250912150945833932809  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 15:09:46

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table250912150945833932809 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 15:09:46

update my_temp_table250912150945833932809  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 31 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 15:09:46

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 31,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table250912150945833932809 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id and t1.File_id =t2.FileId WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null  and t1.import_status=0 — 2025-09-12 15:09:46

UPDATE my_temp_table25091215105912526547 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 15:11:00

update my_temp_table25091215105912526547  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 15:11:00

update my_temp_table25091215105912526547  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 15:11:00

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table25091215105912526547 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 15:11:00

update my_temp_table25091215105912526547  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 31 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 15:11:00

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 31,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table25091215105912526547 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id and t1.File_id =t2.FileId WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null  and t1.import_status=0 — 2025-09-12 15:11:00

UPDATE my_temp_table2509121511131465537262 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 15:11:14

update my_temp_table2509121511131465537262  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 15:11:14

update my_temp_table2509121511131465537262  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 15:11:14

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table2509121511131465537262 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 15:11:14

update my_temp_table2509121511131465537262  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 26 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 15:11:14

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 26,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table2509121511131465537262 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id and t1.File_id =t2.FileId WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null  and t1.import_status=0 — 2025-09-12 15:11:14

UPDATE my_temp_table2509121554511087652983 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 15:54:51

UPDATE my_temp_table2509121554511087652983 t1
    JOIN process_table_1 t2 
    ON t1.Lead_ID = t2.Lead_ID 
    SET master_id = t2.id, update_flag = 1, File_id = 26, 
        t2.last_agent_id = t1.agent 
    WHERE t1.process_id = 1 — 2025-09-12 15:54:51

UPDATE my_temp_table2509121554511087652983 t1 
    JOIN process_table_1 t2 
    ON t1.Lead_ID = t2.Lead_ID 
    SET master_id = t2.id, update_flag = 1, File_id = 26, 
        t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END, 
        t2.last_agent_id = t1.agent 
    WHERE t1.process_id = 1 — 2025-09-12 15:54:51

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3, last_agent_id) 
                                    SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3, agent 
             FROM my_temp_table2509121554511087652983 t1 
    WHERE t1.process_id = 1 
    AND master_id IS NULL 
    AND update_flag IS NULL — 2025-09-12 15:54:51

UPDATE my_temp_table2509121554511087652983 t1 
    JOIN process_table_1 t2 
    ON t1.Lead_ID = t2.Lead_ID 
    SET master_id = t2.id, t1.Insert_flag = 1, File_id = 26 
    WHERE t1.process_id = 1 
    AND master_id IS NULL 
    AND update_flag IS NULL — 2025-09-12 15:54:51

UPDATE my_temp_table2509121555061968005968 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 15:55:07

UPDATE my_temp_table2509121555061968005968 t1
    JOIN process_table_1 t2 
    ON t1.Lead_ID = t2.Lead_ID 
    SET master_id = t2.id, update_flag = 1, File_id = 26, 
        t2.last_agent_id = t1.agent 
    WHERE t1.process_id = 1 — 2025-09-12 15:55:07

UPDATE my_temp_table2509121555061968005968 t1 
    JOIN process_table_1 t2 
    ON t1.Lead_ID = t2.Lead_ID 
    SET master_id = t2.id, update_flag = 1, File_id = 26, 
        t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END, 
        t2.last_agent_id = t1.agent 
    WHERE t1.process_id = 1 — 2025-09-12 15:55:07

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3, last_agent_id) 
                                    SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3, agent 
             FROM my_temp_table2509121555061968005968 t1 
    WHERE t1.process_id = 1 
    AND master_id IS NULL 
    AND update_flag IS NULL — 2025-09-12 15:55:07

UPDATE my_temp_table2509121555061968005968 t1 
    JOIN process_table_1 t2 
    ON t1.Lead_ID = t2.Lead_ID 
    SET master_id = t2.id, t1.Insert_flag = 1, File_id = 26 
    WHERE t1.process_id = 1 
    AND master_id IS NULL 
    AND update_flag IS NULL — 2025-09-12 15:55:07

UPDATE my_temp_table2509121555241553476985 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 15:55:24

UPDATE my_temp_table2509121555241553476985 t1
    JOIN process_table_1 t2 
    ON t1.Lead_ID = t2.Lead_ID 
    SET master_id = t2.id, update_flag = 1, File_id = 26, 
        t2.last_agent_id = t1.agent 
    WHERE t1.process_id = 1 — 2025-09-12 15:55:24

UPDATE my_temp_table2509121555241553476985 t1 
    JOIN process_table_1 t2 
    ON t1.Lead_ID = t2.Lead_ID 
    SET master_id = t2.id, update_flag = 1, File_id = 26, 
        t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END, 
        t2.last_agent_id = t1.agent 
    WHERE t1.process_id = 1 — 2025-09-12 15:55:24

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3, last_agent_id) 
                                    SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3, agent 
             FROM my_temp_table2509121555241553476985 t1 
    WHERE t1.process_id = 1 
    AND master_id IS NULL 
    AND update_flag IS NULL — 2025-09-12 15:55:24

UPDATE my_temp_table2509121555241553476985 t1 
    JOIN process_table_1 t2 
    ON t1.Lead_ID = t2.Lead_ID 
    SET master_id = t2.id, t1.Insert_flag = 1, File_id = 26 
    WHERE t1.process_id = 1 
    AND master_id IS NULL 
    AND update_flag IS NULL — 2025-09-12 15:55:24

UPDATE my_temp_table250912155540233721423 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 15:55:41

UPDATE my_temp_table250912155540233721423 t1
    JOIN process_table_1 t2 
    ON t1.Lead_ID = t2.Lead_ID 
    SET master_id = t2.id, update_flag = 1, File_id = 26, 
        t2.last_agent_id = t1.agent 
    WHERE t1.process_id = 1 — 2025-09-12 15:55:41

UPDATE my_temp_table250912155540233721423 t1 
    JOIN process_table_1 t2 
    ON t1.Lead_ID = t2.Lead_ID 
    SET master_id = t2.id, update_flag = 1, File_id = 26, 
        t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END, 
        t2.last_agent_id = t1.agent 
    WHERE t1.process_id = 1 — 2025-09-12 15:55:41

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3, last_agent_id) 
                                    SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3, agent 
             FROM my_temp_table250912155540233721423 t1 
    WHERE t1.process_id = 1 
    AND master_id IS NULL 
    AND update_flag IS NULL — 2025-09-12 15:55:41

UPDATE my_temp_table250912155540233721423 t1 
    JOIN process_table_1 t2 
    ON t1.Lead_ID = t2.Lead_ID 
    SET master_id = t2.id, t1.Insert_flag = 1, File_id = 26 
    WHERE t1.process_id = 1 
    AND master_id IS NULL 
    AND update_flag IS NULL — 2025-09-12 15:55:41

UPDATE my_temp_table250912170054330445422 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 17:00:54

update my_temp_table250912170054330445422  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 17:00:54

update my_temp_table250912170054330445422  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 17:00:54

UPDATE campaign_mapping_1 t1 JOIN my_temp_table250912170054330445422 t2 ON t1.master_id = t2.master_id SET t1.dialed=t2.dialed,t1.CallAgainTime= t2.CallAgainTime, t1.CallAgainType=t2.CallAgainType,t1.stopcalling=t2.stopcalling WHERE t1.FileId =26  AND t1.campaign_id=t2.campaign_id; — 2025-09-12 17:00:54

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table250912170054330445422 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 17:00:54

update my_temp_table250912170054330445422  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 26 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 17:00:54

UPDATE my_temp_table2509121701251753347831 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 17:01:25

update my_temp_table2509121701251753347831  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 17:01:25

update my_temp_table2509121701251753347831  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 17:01:25

UPDATE campaign_mapping_1 t1 JOIN my_temp_table2509121701251753347831 t2 ON t1.master_id = t2.master_id SET t1.dialed=t2.dialed,t1.CallAgainTime= t2.CallAgainTime, t1.CallAgainType=t2.CallAgainType,t1.stopcalling=t2.stopcalling WHERE t1.FileId =26  AND t1.campaign_id=t2.campaign_id; — 2025-09-12 17:01:25

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table2509121701251753347831 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 17:01:25

update my_temp_table2509121701251753347831  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 26 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 17:01:25

UPDATE my_temp_table250912170833427778541 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 17:08:33

update my_temp_table250912170833427778541  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 17:08:33

update my_temp_table250912170833427778541  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 17:08:33

UPDATE campaign_mapping_1 t1 JOIN my_temp_table250912170833427778541 t2 ON t1.master_id = t2.master_id SET t1.dialed=t2.dialed,t1.CallAgainTime= t2.CallAgainTime, t1.CallAgainType=t2.CallAgainType,t1.stopcalling=t2.stopcalling WHERE t1.FileId =26  AND t1.campaign_id=t2.campaign_id; — 2025-09-12 17:08:33

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table250912170833427778541 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 17:08:33

update my_temp_table250912170833427778541  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 26 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 17:08:33

UPDATE   my_temp_table250912170833427778541  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID JOIN campaign_mapping_1 cmpMap ON cmpMap.master_id=t2.id   SET t1.import_status= 1  WHERE cmpMap.map_id IS NULL  — 2025-09-12 17:08:33

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 26,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table250912170833427778541 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id and t1.File_id =t2.FileId WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null and import_status =1 — 2025-09-12 17:08:33

UPDATE my_temp_table2509121721051045589938 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 17:21:09

update my_temp_table2509121721051045589938  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 17:21:09

update my_temp_table2509121721051045589938  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 17:21:09

UPDATE campaign_mapping_1 t1 JOIN my_temp_table2509121721051045589938 t2 ON t1.master_id = t2.master_id SET t1.dialed=t2.dialed,t1.CallAgainTime= t2.CallAgainTime, t1.CallAgainType=t2.CallAgainType,t1.stopcalling=t2.stopcalling WHERE t1.FileId =26  AND t1.campaign_id=t2.campaign_id; — 2025-09-12 17:21:09

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table2509121721051045589938 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 17:21:09

update my_temp_table2509121721051045589938  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 26 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 17:21:09

UPDATE   my_temp_table2509121721051045589938  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID LEFT JOIN campaign_mapping_1 cmpMap ON cmpMap.master_id=t2.id   SET t1.import_status= 1  WHERE cmpMap.map_id IS NULL  — 2025-09-12 17:21:10

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 26,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table2509121721051045589938 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id and t1.File_id =t2.FileId WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null and import_status =1 — 2025-09-12 17:21:10

UPDATE my_temp_table250912172128184859716 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 17:21:31

update my_temp_table250912172128184859716  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 17:21:32

update my_temp_table250912172128184859716  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=26, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 17:21:32

UPDATE campaign_mapping_1 t1 JOIN my_temp_table250912172128184859716 t2 ON t1.master_id = t2.master_id SET t1.dialed=t2.dialed,t1.CallAgainTime= t2.CallAgainTime, t1.CallAgainType=t2.CallAgainType,t1.stopcalling=t2.stopcalling WHERE t1.FileId =26  AND t1.campaign_id=t2.campaign_id; — 2025-09-12 17:21:32

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table250912172128184859716 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 17:21:32

update my_temp_table250912172128184859716  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 26 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 17:21:32

UPDATE   my_temp_table250912172128184859716  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID LEFT JOIN campaign_mapping_1 cmpMap ON cmpMap.master_id=t2.id   SET t1.import_status= 1  WHERE cmpMap.map_id IS NULL  — 2025-09-12 17:21:32

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 26,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table250912172128184859716 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id and t1.File_id =t2.FileId WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null and import_status =1 — 2025-09-12 17:21:32

UPDATE my_temp_table2509121721481429929271 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 17:21:49

update my_temp_table2509121721481429929271  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 17:21:49

update my_temp_table2509121721481429929271  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 17:21:49

UPDATE campaign_mapping_1 t1 JOIN my_temp_table2509121721481429929271 t2 ON t1.master_id = t2.master_id SET t1.dialed=t2.dialed,t1.CallAgainTime= t2.CallAgainTime, t1.CallAgainType=t2.CallAgainType,t1.stopcalling=t2.stopcalling WHERE t1.FileId =31  AND t1.campaign_id=t2.campaign_id; — 2025-09-12 17:21:49

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table2509121721481429929271 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 17:21:49

update my_temp_table2509121721481429929271  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 31 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 17:21:49

UPDATE   my_temp_table2509121721481429929271  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID LEFT JOIN campaign_mapping_1 cmpMap ON cmpMap.master_id=t2.id   SET t1.import_status= 1  WHERE cmpMap.map_id IS NULL  — 2025-09-12 17:21:49

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 31,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table2509121721481429929271 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id and t1.File_id =t2.FileId WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null and import_status =1 — 2025-09-12 17:21:49

UPDATE my_temp_table2509121722171688753123 tempagent
            SET tempagent.agent = (
                SELECT id
                FROM agent
                WHERE name = tempagent.agent
            ) — 2025-09-12 17:22:17

update my_temp_table2509121722171688753123  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31 ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 17:22:17

update my_temp_table2509121722171688753123  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,update_flag=1 ,File_id=31, t2.last_disposition = CASE WHEN t1.last_disposition IS NOT NULL THEN t1.last_disposition ELSE t2.last_disposition END, t2.test_link = CASE WHEN t1.test_link IS NOT NULL THEN t1.test_link ELSE t2.test_link END, t2.test_link_demo = CASE WHEN t1.test_link_demo IS NOT NULL THEN t1.test_link_demo ELSE t2.test_link_demo END, t2.feedback = CASE WHEN t1.feedback IS NOT NULL THEN t1.feedback ELSE t2.feedback END, t2.fb_page_name = CASE WHEN t1.fb_page_name IS NOT NULL THEN t1.fb_page_name ELSE t2.fb_page_name END, t2.fb_form_name = CASE WHEN t1.fb_form_name IS NOT NULL THEN t1.fb_form_name ELSE t2.fb_form_name END, t2.Mobile_Number = CASE WHEN t1.Mobile_Number IS NOT NULL THEN t1.Mobile_Number ELSE t2.Mobile_Number END, t2.attempt_count_master = CASE WHEN t1.attempt_count_master IS NOT NULL THEN t1.attempt_count_master ELSE t2.attempt_count_master END, t2.phon = CASE WHEN t1.phon IS NOT NULL THEN t1.phon ELSE t2.phon END, t2.Customer_name = CASE WHEN t1.Customer_name IS NOT NULL THEN t1.Customer_name ELSE t2.Customer_name END, t2.dateCreate = CASE WHEN t1.dateCreate IS NOT NULL THEN t1.dateCreate ELSE t2.dateCreate END, t2.LOB = CASE WHEN t1.LOB IS NOT NULL THEN t1.LOB ELSE t2.LOB END, t2.company_Name = CASE WHEN t1.company_Name IS NOT NULL THEN t1.company_Name ELSE t2.company_Name END, t2.company_name_2 = CASE WHEN t1.company_name_2 IS NOT NULL THEN t1.company_name_2 ELSE t2.company_name_2 END, t2.company_name_3 = CASE WHEN t1.company_name_3 IS NOT NULL THEN t1.company_name_3 ELSE t2.company_name_3 END ,t2.last_agent_id= t1.agent WHERE t1.process_id= 1 — 2025-09-12 17:22:17

UPDATE campaign_mapping_1 t1 JOIN my_temp_table2509121722171688753123 t2 ON t1.master_id = t2.master_id SET t1.dialed=t2.dialed,t1.CallAgainTime= t2.CallAgainTime, t1.CallAgainType=t2.CallAgainType,t1.stopcalling=t2.stopcalling WHERE t1.FileId =31  AND t1.campaign_id=t2.campaign_id; — 2025-09-12 17:22:17

INSERT INTO process_table_1(last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,last_agent_id) SELECT last_disposition ,test_link ,test_link_demo ,feedback ,fb_page_name ,fb_form_name ,Lead_ID ,Mobile_Number ,attempt_count_master ,phon ,Customer_name ,dateCreate ,LOB ,company_Name ,company_name_2 ,company_name_3 ,agent  FROM my_temp_table2509121722171688753123 t1 WHERE t1.process_id=1 AND master_id IS NULL AND update_flag IS null — 2025-09-12 17:22:17

update my_temp_table2509121722171688753123  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID SET master_id=t2.id,t1.Insert_flag=1 , File_id= 31 WHERE t1.process_id= 1 AND master_id IS NULL AND update_flag IS NULL — 2025-09-12 17:22:17

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 31,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table2509121722171688753123 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id and t1.File_id =t2.FileId WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null — 2025-09-12 17:22:17

UPDATE   my_temp_table2509121722171688753123  t1 JOIN process_table_1 t2 ON t1.Lead_ID = t2.Lead_ID LEFT JOIN campaign_mapping_1 cmpMap ON cmpMap.master_id=t2.id   SET t1.import_status= 1  WHERE cmpMap.map_id IS NULL  — 2025-09-12 17:22:17

INSERT INTO campaign_mapping_1(FileId, campaign_id,master_id,dialed,agent_id,CallAgainTime,CallAgainType,stopcalling) SELECT 31,  t1.campaign_id,t1.master_id,t1.dialed,t1.agent ,t1.CallAgainTime,t1.CallAgainType,t1.stopcalling FROM my_temp_table2509121722171688753123 t1  left join   campaign_mapping_1 t2 on t1.master_id=t2.master_id and t1.campaign_id=t2.campaign_id and t1.File_id =t2.FileId WHERE t1.process_id=1 AND t1.master_id is not null and t2.map_id is null and import_status =1 — 2025-09-12 17:22:17