Start Processing : 2026-04-18 16:46:54
0 rows affectedUPDATE db_ipqs SET _validity = (select CASE WHEN _recentAbuse = 'TRUE' or _valid = 'FALSE' or _disposable = 'TRUE' or _honeypot = 'TRUE' or _spamTrapScore = 'high' THEN 'Invalid' ELSE 'Valid' END AS _validity) where _validity is null;
[10] 0.7 seconds -> 0 rows affected
update db_contacts a, db_ipqs b set a._validity = b._validity where a._email = b._emailAddress && a._validity is null
[20] 3.97 seconds -> 0 rows affected
update db_contacts a, db_ipqs b set a._spamTrap = b._spamTrapScore where a._email = b._emailAddress && a._spamTrap is null
[30] 2.32 seconds -> 0 rows affected