Start Processing : 2024-09-20 02:48:28
0 rows affectedUPDATE db_hubspot_nurture a INNER JOIN (SELECT _companyName, MIN(_createdDate) '_dt' FROM db_hubspot_nurture WHERE _activityType = 'Email reply from contact' AND YEAR(_date) = YEAR(NOW()) AND (_contactName LIKE '%Hayes McGinley%' OR _contactName LIKE '%Steve Gillin%' OR _contactName LIKE '%Luke Gomez%' OR _contactName LIKE '%Cassidy Mattiola%' OR _contactName LIKE '%Brian Cannon%' OR _contactName LIKE '%Jason Kelly%' OR _contactName LIKE '%Austin Pifani%') GROUP BY _companyName) o SET a._convertedMeeting = 1 WHERE a._companyName = o._companyName AND a._date <= o._dt
[1] 0.41 seconds -> 0 rows affected