Mine
public sql v1 · immutableUPDATE `click_fraud_suspect_ip_addresses` SET `last_activity`=(SELECT max(`timestamp`) as last_activity FROM `webentry` WHERE `ipaddress`='24.6.108.181') WHERE `ip_address` = '24.6.108.181'UPDATE `click_fraud_suspect_ip_addresses` SET `last_activity`=(SELECT max(`timestamp`) as last_activity FROM `webentry` WHERE `ipaddress`='24.6.108.181') WHERE `ip_address` = '24.6.108.181'