SELECT Date_Create, San_status FROM #Request.prefix_db_lookup#.EVV WHERE API_Type = AND Agency_ID = AND status = 0 AND ( UPPER(San_status) LIKE '%SUCCESS%' OR UPPER(San_status) LIKE '%TRANSMITTED%' OR UPPER(San_status) LIKE '%TRANSACTION RECEIVED%' ) AND Patient_ID = AND Emp_ID = AND Schedule_ID = ORDER BY EVV_ID DESC LIMIT 1 SELECT COUNT(*) as change_count FROM #Request.prefix_db_agency#.pPatients WHERE Patient_ID = AND Record_Mod_Date IS NOT NULL AND Record_Mod_Date > SELECT COUNT(*) as change_count FROM #Request.prefix_db_lookup#.pEmployee WHERE Emp_ID = AND Record_Mod_Date IS NOT NULL AND Record_Mod_Date > SELECT COUNT(*) as change_count FROM #Request.prefix_db_agency#.pSchedules WHERE Schedule_ID = AND Date_Change IS NOT NULL AND Date_Change > SELECT EVV_ID, San_status FROM #Request.prefix_db_lookup#.EVV WHERE API_Type = AND Agency_ID = AND status = 0 AND ( UPPER(San_status) LIKE '%SUCCESS%' OR UPPER(San_status) LIKE '%TRANSMITTED%' OR UPPER(San_status) LIKE '%TRANSACTION RECEIVED%' ) AND Patient_ID = AND Emp_ID = AND Schedule_ID = ORDER BY EVV_ID DESC LIMIT 1 UPDATE #Request.prefix_db_lookup#.EVV SET San_status = 'Data Changed - Retransmission Required', Date_Update = NOW() WHERE EVV_ID = AND ( UPPER(San_status) LIKE '%SUCCESS%' OR UPPER(San_status) LIKE '%TRANSMITTED%' OR UPPER(San_status) LIKE '%TRANSACTION RECEIVED%' ) AND ( UPPER(San_status) NOT LIKE '%FAILED%' AND UPPER(San_status) NOT LIKE '%ERROR%' AND UPPER(San_status) NOT LIKE '%REJECTED%' AND UPPER(San_status) NOT LIKE '%DATA CHANGED%' ) SELECT San_status, Date_Create FROM #Request.prefix_db_lookup#.EVV WHERE LOWER(TRIM(IFNULL(API_Type, ''))) = AND Agency_ID = AND status = 0 AND Patient_ID = AND Emp_ID = AND Schedule_ID = ORDER BY EVV_ID DESC LIMIT 1 ---> SELECT EVV_Transmission FROM #Request.prefix_db_lookup#.Agency WHERE Agency_ID = LIMIT 1