2023 Sponsors
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 ('a0D3b0000168PpTEAU') 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] => 7
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdMtyAAE
)
[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/00P3b00001xZXXjEAO
)
[Id] => 00P3b00001xZXXjEAO
[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/00P3b00001xZXXeEAO
)
[Id] => 00P3b00001xZXXeEAO
[Title] => bp email correspondence.pdf
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001xZXXjEAO
)
[Id] => 00P3b00001xZXXjEAO
[Title] => BP logo.jpeg
)
)
)
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdMktAAE
)
[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/00P3b00001xZU3IEAW
)
[Id] => 00P3b00001xZU3IEAW
[Title] => Chevron.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/00P3b00001xZU3DEAW
)
[Id] => 00P3b00001xZU3DEAW
[Title] => Chevron Email Correspondence.pdf
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001xZU3IEAW
)
[Id] => 00P3b00001xZU3IEAW
[Title] => Chevron.jpg
)
)
)
)
[2] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdQrlAAE
)
[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/00P3b00001xapMkEAI
)
[Id] => 00P3b00001xapMkEAI
[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/00P3b00001xapMkEAI
)
[Id] => 00P3b00001xapMkEAI
[Title] => Cleveland Advisory logo.jpg
)
)
)
)
[3] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdPKtAAM
)
[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/00P3b00001xaJF6EAM
)
[Id] => 00P3b00001xaJF6EAM
[Title] => ConocoPhillips.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/00P3b00001xaJF6EAM
)
[Id] => 00P3b00001xaJF6EAM
[Title] => ConocoPhillips.jpg
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001xaJErEAM
)
[Id] => 00P3b00001xaJErEAM
[Title] => ConocoPhillips.pdf
)
)
)
)
[4] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdOWTAA2
)
[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/00P3b00001xa09PEAQ
)
[Id] => 00P3b00001xa09PEAQ
[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/00P3b00001xa01BEAQ
)
[Id] => 00P3b00001xa01BEAQ
[Title] => Enbridge Email Correspondence.pdf
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001xa09PEAQ
)
[Id] => 00P3b00001xa09PEAQ
[Title] => Enbridge-Spectra Logo.jpg
)
)
)
)
[5] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdTsKAAU
)
[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/00P3b00001xbsWxEAI
)
[Id] => 00P3b00001xbsWxEAI
[Title] => Spire_logo_SM_CMYK.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/00P3b00001xbsWsEAI
)
[Id] => 00P3b00001xbsWsEAI
[Title] => Spire.pdf
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001xbsWxEAI
)
[Id] => 00P3b00001xbsWxEAI
[Title] => Spire_logo_SM_CMYK.jpeg
)
)
)
)
[6] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNVhAAM
)
[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/00P3b00001xZj4gEAC
)
[Id] => 00P3b00001xZj4gEAC
[Title] => Tenaska.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/00P3b00001xZj4bEAC
)
[Id] => 00P3b00001xZj4bEAC
[Title] => tenaska.pdf
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001xZj4gEAC
)
[Id] => 00P3b00001xZj4gEAC
[Title] => Tenaska.jpg
)
)
)
)
)
)
'