Sponsors – 2020
SELECT
Sponsor_Name__r.Name,
Sponsor_Name__r.Website,
Sponsor_Name__r.Company_Description__c,
Sponsorship_Type__c,
Priority__c,
Sponsorship__c,
Sponsor_Website__c,
Sponsor_Contact__c,
Sponsor_Email__c,
Sponsor_Phone__c,
Sponsor_Address__c,
Company_Description__c,
(SELECT Id, Title
FROM NotesAndAttachments
WHERE IsNote = FALSE AND (Title LIKE '%jpg' OR Title LIKE '%gif' OR Title LIKE '%png' OR Title LIKE '%jpeg')
ORDER BY CreatedDate DESC LIMIT 1),
(SELECT Id, Title
FROM CombinedAttachments)
FROM Sponsor__c
WHERE Event__r.Id IN ('a0D3b000013f0UeEAI') AND Sponsorship_Type__c NOT IN ('Media Partners','Media Sponsor-Trade','CANCELLED-Sponsor with Speaker & Kiosk','')
ORDER BY Sponsorship__c, Sponsor_Name__r.NamestdClass Object
(
[totalSize] => 9
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuXJJAA3
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000P8mJUAAZ
)
[Name] => BP Energy Company
[Website] => www.bp.com
[Company_Description__c] => Gas-Natural
)
[Sponsorship_Type__c] => Sponsor-Logo Display Only
[Priority__c] =>
[Sponsorship__c] => BP Energy Company
[Sponsor_Website__c] => www.bp.com
[Sponsor_Contact__c] =>
[Sponsor_Email__c] =>
[Sponsor_Phone__c] =>
[Sponsor_Address__c] =>
[Company_Description__c] =>
[NotesAndAttachments] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => NoteAndAttachment
[url] => /services/data/v41.0/sobjects/NoteAndAttachment/00P3b00001ZXCsLEAX
)
[Id] => 00P3b00001ZXCsLEAX
[Title] => BP logo.jpeg
)
)
)
[CombinedAttachments] => stdClass Object
(
[totalSize] => 2
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ZXCsLEAX
)
[Id] => 00P3b00001ZXCsLEAX
[Title] => BP logo.jpeg
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ZXCplEAH
)
[Id] => 00P3b00001ZXCplEAH
[Title] => doc00801120200127160141.pdf
)
)
)
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002Lua8IAAR
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/001C000001itrwRIAQ
)
[Name] => Cleveland Advisory LLC
[Website] =>
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Supporting Sponsor, Logo Display Only
[Priority__c] =>
[Sponsorship__c] => Cleveland Advisory
[Sponsor_Website__c] => http://www.clevelandadvisory.com/
[Sponsor_Contact__c] =>
[Sponsor_Email__c] =>
[Sponsor_Phone__c] =>
[Sponsor_Address__c] =>
[Company_Description__c] =>
[NotesAndAttachments] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => NoteAndAttachment
[url] => /services/data/v41.0/sobjects/NoteAndAttachment/00P3b00001ZYqXXEA1
)
[Id] => 00P3b00001ZYqXXEA1
[Title] => Cleveland Advisory logo.jpg
)
)
)
[CombinedAttachments] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ZYqXXEA1
)
[Id] => 00P3b00001ZYqXXEA1
[Title] => Cleveland Advisory logo.jpg
)
)
)
)
[2] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuOIFAA3
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/001C000001JfFzRIAV
)
[Name] => ConocoPhillips
[Website] => www.conocophillips.com
[Company_Description__c] => End-User/Corporate Purchaser
)
[Sponsorship_Type__c] => Sponsor with speaker
[Priority__c] =>
[Sponsorship__c] => ConocoPhillips
[Sponsor_Website__c] => www.conocophillips.com
[Sponsor_Contact__c] =>
[Sponsor_Email__c] =>
[Sponsor_Phone__c] =>
[Sponsor_Address__c] =>
[Company_Description__c] =>
[NotesAndAttachments] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => NoteAndAttachment
[url] => /services/data/v41.0/sobjects/NoteAndAttachment/00P3b00001Wx82cEAB
)
[Id] => 00P3b00001Wx82cEAB
[Title] => ConocoPhillips.jpg
)
)
)
[CombinedAttachments] => stdClass Object
(
[totalSize] => 3
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001Wx82cEAB
)
[Id] => 00P3b00001Wx82cEAB
[Title] => ConocoPhillips.jpg
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001Wx4E0EAJ
)
[Id] => 00P3b00001Wx4E0EAJ
[Title] => ConocoPhillips 2020 Contracts.pdf
)
[2] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001Wx7oXEAR
)
[Id] => 00P3b00001Wx7oXEAR
[Title] => ConocoPhillips email confirm.pdf
)
)
)
)
[3] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuahMAAR
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000RrQ9jAAF
)
[Name] => Direct Energy
[Website] => www.directenergy.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Sponsor with Speaker & Kiosk
[Priority__c] =>
[Sponsorship__c] => Direct Energy
[Sponsor_Website__c] => www.directenergy.com
[Sponsor_Contact__c] =>
[Sponsor_Email__c] =>
[Sponsor_Phone__c] =>
[Sponsor_Address__c] =>
[Company_Description__c] =>
[NotesAndAttachments] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => NoteAndAttachment
[url] => /services/data/v41.0/sobjects/NoteAndAttachment/00P3b00001ZZMd1EAH
)
[Id] => 00P3b00001ZZMd1EAH
[Title] => DirectEnergy_2015.jpg
)
)
)
[CombinedAttachments] => stdClass Object
(
[totalSize] => 2
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ZZMccEAH
)
[Id] => 00P3b00001ZZMccEAH
[Title] => Direct Energy.pdf
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ZZMd1EAH
)
[Id] => 00P3b00001ZZMd1EAH
[Title] => DirectEnergy_2015.jpg
)
)
)
)
[4] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuYzNAAV
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000P8mQZAAZ
)
[Name] => Enbridge
[Website] => www.embridge.com
[Company_Description__c] => Gas-Natural
)
[Sponsorship_Type__c] => Sponsor with speaker
[Priority__c] =>
[Sponsorship__c] => Enbridge
[Sponsor_Website__c] => www.enbridge.com
[Sponsor_Contact__c] =>
[Sponsor_Email__c] =>
[Sponsor_Phone__c] =>
[Sponsor_Address__c] =>
[Company_Description__c] =>
[NotesAndAttachments] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => NoteAndAttachment
[url] => /services/data/v41.0/sobjects/NoteAndAttachment/00P3b00001ZYB49EAH
)
[Id] => 00P3b00001ZYB49EAH
[Title] => Enbridge-Spectra Logo.jpg
)
)
)
[CombinedAttachments] => stdClass Object
(
[totalSize] => 2
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ZYB49EAH
)
[Id] => 00P3b00001ZYB49EAH
[Title] => Enbridge-Spectra Logo.jpg
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ZYAL6EAP
)
[Id] => 00P3b00001ZYAL6EAP
[Title] => ENBRIDGE.pdf
)
)
)
)
[5] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuXXPAA3
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000dRwzDAAS
)
[Name] => ICIS
[Website] => www.icis.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Sponsor with speaker
[Priority__c] =>
[Sponsorship__c] => ICIS
[Sponsor_Website__c] => www.icis.com
[Sponsor_Contact__c] =>
[Sponsor_Email__c] =>
[Sponsor_Phone__c] =>
[Sponsor_Address__c] =>
[Company_Description__c] =>
[NotesAndAttachments] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => NoteAndAttachment
[url] => /services/data/v41.0/sobjects/NoteAndAttachment/00P3b00001ZYlmxEAD
)
[Id] => 00P3b00001ZYlmxEAD
[Title] => I.C.I.S_Logo.jpg
)
)
)
[CombinedAttachments] => stdClass Object
(
[totalSize] => 2
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ZXJQJEA5
)
[Id] => 00P3b00001ZXJQJEA5
[Title] => doc00802920200128153302.pdf
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ZYlmxEAD
)
[Id] => 00P3b00001ZYlmxEAD
[Title] => I.C.I.S_Logo.jpg
)
)
)
)
[6] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuQRiAAN
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/001C000001bW6EEIA0
)
[Name] => Latitude Technologies, LLC
[Website] =>
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Sponsor with kiosk
[Priority__c] =>
[Sponsorship__c] => Latitude Technologies, LLC
[Sponsor_Website__c] => www.esgglobal.com
[Sponsor_Contact__c] =>
[Sponsor_Email__c] =>
[Sponsor_Phone__c] =>
[Sponsor_Address__c] =>
[Company_Description__c] =>
[NotesAndAttachments] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => NoteAndAttachment
[url] => /services/data/v41.0/sobjects/NoteAndAttachment/00P3b00001YKBaWEAX
)
[Id] => 00P3b00001YKBaWEAX
[Title] => LatitudeTech_Logo_HiRes.jpg
)
)
)
[CombinedAttachments] => stdClass Object
(
[totalSize] => 2
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001YKBaWEAX
)
[Id] => 00P3b00001YKBaWEAX
[Title] => LatitudeTech_Logo_HiRes.jpg
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001YKBUnEAP
)
[Id] => 00P3b00001YKBUnEAP
[Title] => Latitude Technologies an ESG Company.pdf
)
)
)
)
[7] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuUmlAAF
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000PSV5iAAH
)
[Name] => Sequent Energy Management
[Website] =>
[Company_Description__c] => Gas-Natural
)
[Sponsorship_Type__c] => Sponsor with speaker
[Priority__c] =>
[Sponsorship__c] => Sequent Energy Management
[Sponsor_Website__c] => www.southernco.com
[Sponsor_Contact__c] =>
[Sponsor_Email__c] =>
[Sponsor_Phone__c] =>
[Sponsor_Address__c] =>
[Company_Description__c] =>
[NotesAndAttachments] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => NoteAndAttachment
[url] => /services/data/v41.0/sobjects/NoteAndAttachment/00P3b00001YMKdNEAX
)
[Id] => 00P3b00001YMKdNEAX
[Title] => Sequent-Energy-colored-STACKED.jpg
)
)
)
[CombinedAttachments] => stdClass Object
(
[totalSize] => 2
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001YMKceEAH
)
[Id] => 00P3b00001YMKceEAH
[Title] => Sequent Energy.pdf
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001YMKdNEAX
)
[Id] => 00P3b00001YMKdNEAX
[Title] => Sequent-Energy-colored-STACKED.jpg
)
)
)
)
[8] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuYcbAAF
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0013b00001nE1SSAA0
)
[Name] => Stabilis Energy
[Website] => www.prometheusenergy.com
[Company_Description__c] => Gas-Natural
)
[Sponsorship_Type__c] => Sponsor with Speaker & Kiosk
[Priority__c] =>
[Sponsorship__c] => Stabilis Energy
[Sponsor_Website__c] => www.stabilisenergy.com
[Sponsor_Contact__c] =>
[Sponsor_Email__c] =>
[Sponsor_Phone__c] =>
[Sponsor_Address__c] =>
[Company_Description__c] =>
[NotesAndAttachments] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => NoteAndAttachment
[url] => /services/data/v41.0/sobjects/NoteAndAttachment/00P3b00001ZY0A4EAL
)
[Id] => 00P3b00001ZY0A4EAL
[Title] => stabilis-logo.jpg
)
)
)
[CombinedAttachments] => stdClass Object
(
[totalSize] => 2
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ZXwMUEA1
)
[Id] => 00P3b00001ZXwMUEA1
[Title] => Stabilis Energy.pdf
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ZY0A4EAL
)
[Id] => 00P3b00001ZY0A4EAL
[Title] => stabilis-logo.jpg
)
)
)
)
)
)
Previous Sponsors
'