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] => 6
[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/a063b00002tdNFuAAM
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000RrQ9jAAF
)
[Name] => Direct Energy Business Marketing
[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/00P3b00001xZefIEAS
)
[Id] => 00P3b00001xZefIEAS
[Title] => DirectEnergy_2015.jpg
)
)
)
)
[3] => 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
[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
)
)
)
)
[4] => 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
)
)
)
)
[5] => 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
)
)
)
)
)
)
'