Sponsors – 2023
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)
FROM Sponsor__c
WHERE Event__r.Id IN ('a0D3b0000168PpOEAU') AND Sponsorship_Type__c NOT IN ('Media Partners','Media Sponsor-Trade')
ORDER BY Sponsorship__c, Sponsor_Name__r.NamestdClass Object
(
[totalSize] => 15
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdMttAAE
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000P8mJUAAZ
)
[Name] => bp
[Website] => www.bp.com
[Company_Description__c] => Gas-Natural
)
[Sponsorship_Type__c] => Sponsors
[Priority__c] =>
[Sponsorship__c] => bp
[Sponsor_Website__c] => https://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/00P3b00001xZXV3EAO
)
[Id] => 00P3b00001xZXV3EAO
[Title] => BP logo.jpeg
)
)
)
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdMkoAAE
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/001C000000yj5LrIAI
)
[Name] => Chevron
[Website] => www.chevron.com
[Company_Description__c] => Plastic Material & Resin Mfg
)
[Sponsorship_Type__c] => Sponsors
[Priority__c] =>
[Sponsorship__c] => Chevron Natural Gas
[Sponsor_Website__c] => http://www.chevron.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/00P3b00001xZU33EAG
)
[Id] => 00P3b00001xZU33EAG
[Title] => Chevron.jpg
)
)
)
)
[2] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdQrgAAE
)
[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] => 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/00P3b00001xapMaEAI
)
[Id] => 00P3b00001xapMaEAI
[Title] => Cleveland Advisory logo.jpg
)
)
)
)
[3] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdPKoAAM
)
[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 - Exposure
[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/00P3b00001xaJEDEA2
)
[Id] => 00P3b00001xaJEDEA2
[Title] => ConocoPhillips.jpg
)
)
)
)
[4] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNFuAAM
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000RrQ9jAAF
)
[Name] => Direct Energy/NRG Energy, LLC
[Website] => www.directenergy.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Sponsor with Speaker & Kiosk
[Priority__c] =>
[Sponsorship__c] => Direct Energy Business Marketing
[Sponsor_Website__c] => https://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/00P3b00001xc4eDEAQ
)
[Id] => 00P3b00001xc4eDEAQ
[Title] => Direct Energy NRG logo 2023.jpg
)
)
)
)
[5] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdMvzAAE
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/001C000001gzXHnIAM
)
[Name] => East Daley Analytics, Inc.
[Website] => www.eastdaley.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Sponsor with Speaker & Kiosk
[Priority__c] =>
[Sponsorship__c] => East Daley Capital Advisors
[Sponsor_Website__c] => https://eastdaley.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/00P3b00001xZYKJEA4
)
[Id] => 00P3b00001xZYKJEA4
[Title] => East Daley.jpg
)
)
)
)
[6] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdOWOAA2
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000P8mQZAAZ
)
[Name] => Enbridge
[Website] => www.enbridge.com
[Company_Description__c] => Gas-Natural
)
[Sponsorship_Type__c] => Sponsor with speaker
[Priority__c] =>
[Sponsorship__c] => Enbridge
[Sponsor_Website__c] => https://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/00P3b00001xa09AEAQ
)
[Id] => 00P3b00001xa09AEAQ
[Title] => Enbridge-Spectra Logo.jpg
)
)
)
)
[7] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdSl2AAE
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/001C000001N4A9wIAF
)
[Name] => Nextera Energy Marketing
[Website] => www.nexteraenergy.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Sponsor with speaker
[Priority__c] =>
[Sponsorship__c] => NextEra Energy Marketing LLC
[Sponsor_Website__c] => www.nexteraenergy.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/00P3b00001xbTHMEA2
)
[Id] => 00P3b00001xbTHMEA2
[Title] => NEM_Marketing_RGB.jpg
)
)
)
)
[8] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002plXDqAAM
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0013b000020EinJAAS
)
[Name] => Permacast Walls
[Website] => www.permacastwalls.com
[Company_Description__c] => Permacast precast concrete walls are the most durable, efficient and affordable on the market. Our research and design team continues to develop innovative products that apply our technology to new solutions and make us the fastest precast manufacturer & installer on the market.
)
[Sponsorship_Type__c] => Sponsor with Speaker & Kiosk
[Priority__c] =>
[Sponsorship__c] => Permacast Walls
[Sponsor_Website__c] => https://www.permacastwalls.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/00P3b00001zvebWEAQ
)
[Id] => 00P3b00001zvebWEAQ
[Title] => Permacast Logo Top.jpg
)
)
)
)
[9] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdKh4AAE
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0013b00001zJ9HbAAK
)
[Name] => Project Canary
[Website] => www.projectcanary.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Sponsor with Speaker & Kiosk
[Priority__c] =>
[Sponsorship__c] => Project Canary
[Sponsor_Website__c] => https://www.projectcanary.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/00P3b00001vnZ5EEAU
)
[Id] => 00P3b00001vnZ5EEAU
[Title] => Project Canary.jpg
)
)
)
)
[10] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002plNFgAAM
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000P8mQlAAJ
)
[Name] => S&P Global Platts
[Website] => www.spglobal.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Sponsor with Speaker & Kiosk
[Priority__c] =>
[Sponsorship__c] => S&P Global Platts
[Sponsor_Website__c] => https://www.spglobal.com/platts/en/commodities/natural-gas
[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/00P3b00001yhAPFEA2
)
[Id] => 00P3b00001yhAPFEA2
[Title] => SPGI Positive Print Logo - CMYK Coated.jpg
)
)
)
)
[11] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002plYw6AAE
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0013b00001rFOuIAAW
)
[Name] => Sapphire Gas Solutions
[Website] => www.sapphiregassolutions.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Sponsor with Speaker & Kiosk
[Priority__c] =>
[Sponsorship__c] => Sapphire Gas Solutions
[Sponsor_Website__c] => https://sapphiregassolutions.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/00P3b00001zw6Q4EAI
)
[Id] => 00P3b00001zw6Q4EAI
[Title] => sapphire gas solutions.jpeg
)
)
)
)
[12] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdTsFAAU
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/001C000001WmwtsIAB
)
[Name] => Spire Midstream
[Website] => www.spireenergy.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Sponsor with speaker
[Priority__c] =>
[Sponsorship__c] => Spire Inc
[Sponsor_Website__c] => http://www.spireenergy.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/00P3b00001xbsWJEAY
)
[Id] => 00P3b00001xbsWJEAY
[Title] => Spire_logo_SM_CMYK.jpeg
)
)
)
)
[13] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdQr2AAE
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0013b00001qoJIoAAM
)
[Name] => Symmetry Energy Solutions
[Website] => www.centerpointenergy.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Sponsors
[Priority__c] =>
[Sponsorship__c] => Symmetry Energy Solutions
[Sponsor_Website__c] => https://symmetryenergy.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/00P3b00001xanYGEAY
)
[Id] => 00P3b00001xanYGEAY
[Title] => Symmetry Energy Solutions.jpg
)
)
)
)
[14] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNVcAAM
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000P8mJeAAJ
)
[Name] => Tenaska Marketing Ventures
[Website] => www.tenaska.com
[Company_Description__c] => Gas-Natural
)
[Sponsorship_Type__c] => Sponsors
[Priority__c] =>
[Sponsorship__c] => Tenaska
[Sponsor_Website__c] => https://www.tenaska.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/00P3b00001xZj4WEAS
)
[Id] => 00P3b00001xZj4WEAS
[Title] => Tenaska.jpg
)
)
)
)
)
)
'