INSERT IGNORE INTO dashboard_mql_combined (_email, _firstname, _lastname,_source, _datasource, _companyName, _jobTitle, _date,_industry) SELECT _email, _firstname, _lastname, _campaignSource, 'Discovery Call', _accountName,_title, o._date, _industry FROM dashboard_contact c INNER JOIN (SELECT _contactID, _oppCampaignSource '_campaignSource', _latestOppDiscovery '_date' FROM map_contact_opportunity_activity WHERE YEAR(_latestOppDiscovery) = 2020 AND YEAR(_latestContactDiscovery)=2020 AND _oppCampaignBucket = 'Marketing' AND (_firstContactDiscovery >= '2020-01-01' OR _firstContactDiscovery < '2019-01-01') AND (YEAR(_hubspotDate)=2020 OR _hubspotDate IS NULL)) o WHERE c._contactID = o._contactID<BR>