Start Processing : 2025-03-15 02:58:23
0 rows affectedUPDATE db_mql_sal_sql_customer_table SET _becameMQLTS = STR_TO_DATE(_BOTbecameMQLDate, '%Y-%m-%d') where LENGTH(_BOTbecameMQLDate)>0;
[10] 0.01 seconds -> 0 rows affected
UPDATE db_mql_sal_sql_customer_table SET _becameSALTS = STR_TO_DATE(_BOTbecameSALDate, '%Y-%m-%d') where LENGTH(_BOTbecameSALDate)>0;
[20] 0.01 seconds -> 0 rows affected
UPDATE db_mql_sal_sql_customer_table SET _becameSQLTS = STR_TO_DATE(_BOTbecameSQLDate, '%Y-%m-%d') where LENGTH(_BOTbecameSQLDate)>0;
[30] 0 seconds -> 0 rows affected
UPDATE db_mql_sal_sql_customer_table SET _becameCustomerTS = STR_TO_DATE(_BOTbecameCustomerDate, '%Y-%m-%d') where LENGTH(_BOTbecameCustomerDate)>0;
[40] 0 seconds -> 0 rows affected
DELETE FROM db_mql_sal_sql_customer_table WHERE _email LIKE '%*2x.marketing';
[50] 0 seconds -> 0 rows affected
DELETE FROM db_mql_sal_sql_customer_table WHERE _email LIKE '%botanacor.com';
[60] 0 seconds -> 0 rows affected
DELETE FROM db_mql_sal_sql_customer_table WHERE _email LIKE '%riversidecompany.com';
[70] 0 seconds -> 0 rows affected
DELETE FROM db_mql_sal_sql_customer_table WHERE _email LIKE '%agricorlabs.com';
[80] 0 seconds -> 0 rows affected
UPDATE db_mql_sal_sql_customer_table SET _source = 'Email Marketing' WHERE _source = 'Offline Sources';
[90] 0 seconds -> 0 rows affected
UPDATE db_mql_sal_sql_customer_table SET _source = 'Email Marketing' WHERE _source = 'Other Campaigns';
[100] 0 seconds -> 0 rows affected