Warning: include(airtable-call-list.php): failed to open stream: No such file or directory in /var/www/html/dp/load-call-list.php on line 9

Warning: include(): Failed opening 'airtable-call-list.php' for inclusion (include_path='.:/usr/share/php') in /var/www/html/dp/load-call-list.php on line 9
INSERT IGNORE INTO master_call_list (_priority, _date, _firstname, _lastname, _company, _jobTitle, _email, _phone, _comments, _added) SELECT 1,'2024-09-19',SELECT _first_name, _last_name, _companyName, _job_title, _email, _phone, CONCAT('Converted via ',_assetType,' (',_asset,')'), _timestamp FROM `2x`.w_lead_downloads WHERE UNIX_TIMESTAMP(_timestamp) > UNIX_TIMESTAMP()-(86400*7)
INSERT IGNORE INTO master_call_list (_priority, _date, _firstname, _lastname, _company, _jobTitle, _email, _phone, _comments, _added) SELECT 2,'2024-09-19',SELECT TRIM(LEFT(_contactName, LOCATE(" ",_contactName))), TRIM(RIGHT(_contactName,LENGTH(_contactName)- LOCATE(" ",_contactName))), c._company, _jobTitle, _email, _phone, CONCAT('Intent Topic : ',_topics), _dateTS FROM db_intent_contacts c, db_intent_daily d WHERE c._company = d._company AND UNIX_TIMESTAMP(_dateTS) >= UNIX_TIMESTAMP()-(86400*8) AND _topics LIKE '%Outsource%' ORDER BY _dateTS
INSERT IGNORE INTO master_call_list (_priority, _date, _firstname, _lastname, _company, _jobTitle, _email, _phone, _comments, _added) SELECT 3,'2024-09-19',SELECT _firstname, _lastname, _companyName, _title, r._email, _phone, CONCAT('Clicked on email to ',_download_url), _datetime FROM `2x`. w_routables r INNER JOIN (SELECT _email, _download_url, _datetime FROM `2x`.db_sib_combined c, `2x`.db_airtable_email a WHERE c._type = 'clicks' AND UNIX_TIMESTAMP(_datetime) >= UNIX_TIMESTAMP()-(86400*7) AND c._campaignID = a._pardotID AND c._isBot = 0) o WHERE o._email = r._email ORDER BY r._email, _datetime
INSERT IGNORE INTO master_call_list (_priority, _date, _firstname, _lastname, _company, _jobTitle, _email, _phone, _comments, _added) SELECT 4,'2024-09-19',SELECT TRIM(LEFT(_contactName, LOCATE(" ",_contactName))), TRIM(RIGHT(_contactName,LENGTH(_contactName)- LOCATE(" ",_contactName))), c._company, _jobTitle, _email, _phone, CONCAT('Intent Topic : ',_topics), _dateTS FROM db_intent_contacts c, db_intent_daily d WHERE c._company = d._company AND UNIX_TIMESTAMP(_dateTS) >= UNIX_TIMESTAMP()-(86400*8) AND _topics NOT LIKE '%Outsource%' ORDER BY _dateTS
INSERT IGNORE INTO master_call_list (_priority, _date, _firstname, _lastname, _company, _jobTitle, _email, _phone, _comments, _added) SELECT 5,'2024-09-19',SELECT _firstname, _lastname, _companyName, _title, _email, _phone, CONCAT('Company visited ',_ct,' page(s) on website'), c._mx FROM `2x`. w_routables r INNER JOIN (SELECT _domain, MAX(_timestamp) '_mx', COUNT(_ipAddr) '_ct' FROM `2x`.abm_webhits WHERE UNIX_TIMESTAMP(_timestamp) >= UNIX_TIMESTAMP()-(86400*7) GROUP BY _domain) c WHERE c._domain = RIGHT(_email,LOCATE('@',_email))
INSERT IGNORE INTO master_call_list (_priority, _date, _firstname, _lastname, _company, _jobTitle, _email, _phone, _comments, _added) SELECT 6,'2024-09-19',SELECT _firstname, _lastname, _companyName, _title, r._email, _phone, CONCAT('Opened on email to ',_download_url), _datetime FROM `2x`. w_routables r INNER JOIN (SELECT _email, _download_url, _datetime FROM `2x`.db_sib_combined c, `2x`.db_airtable_email a WHERE c._type = 'opens' AND UNIX_TIMESTAMP(_datetime) >= UNIX_TIMESTAMP()-(86400*7) AND c._campaignID = a._pardotID AND c._isBot = 0) o WHERE o._email = r._email ORDER BY r._email, _datetime
UPDATE master_call_list SET _suppressed = 1, _suppressReason = '2X Internal' WHERE _email LIKE '%2x.marketing%' OR _email LIKE '%test%'
UPDATE master_call_list SET _suppressed = 1, _suppressReason = 'No Phone Number' WHERE LENGTH(_phone)=0 OR _phone is NULL
UPDATE master_call_list m, db_suppress_domain d SET _suppressed = 1, _suppressReason = 'Suppressed Domains' WHERE m._domain = d._domain