Sponsors – 2022
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 ('a0D3b000015otCpEAI') 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/a063b00002hAGOtAAO
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000P8mJUAAZ
)
[Name] => BP Energy
[Website] => www.bp.com
[Company_Description__c] => Gas-Natural
)
[Sponsorship_Type__c] => Sponsor-Logo Display Only
[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/00P3b00001pQbBAEA0
)
[Id] => 00P3b00001pQbBAEA0
[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/00P3b00001pQbBAEA0
)
[Id] => 00P3b00001pQbBAEA0
[Title] => BP logo.jpeg
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001pQbB5EAK
)
[Id] => 00P3b00001pQbB5EAK
[Title] => BP Email Correspondence.pdf
)
)
)
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAIthAAG
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000lvVtNAAU
)
[Name] => Chevron Natural Gas (a Chevron U.S.A Inc. division)
[Website] => www.chevron.com
[Company_Description__c] => Oil / Gas
)
[Sponsorship_Type__c] => Sponsor with speaker
[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/00P3b00001rL16yEAC
)
[Id] => 00P3b00001rL16yEAC
[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/00P3b00001rL16yEAC
)
[Id] => 00P3b00001rL16yEAC
[Title] => Chevron.jpg
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001rL19TEAS
)
[Id] => 00P3b00001rL19TEAS
[Title] => 2022 Chevron Email Correspondence.pdf
)
)
)
)
[2] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAEwwAAG
)
[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/00P3b00001pQ6MwEAK
)
[Id] => 00P3b00001pQ6MwEAK
[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/00P3b00001pQ6MwEAK
)
[Id] => 00P3b00001pQ6MwEAK
[Title] => Cleveland Advisory logo.jpg
)
)
)
)
[3] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAFZvAAO
)
[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-Logo Display Only
[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/00P3b00001pQKyBEAW
)
[Id] => 00P3b00001pQKyBEAW
[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/00P3b00001pQKyBEAW
)
[Id] => 00P3b00001pQKyBEAW
[Title] => ConocoPhillips.jpg
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001pQKy6EAG
)
[Id] => 00P3b00001pQKy6EAG
[Title] => ConocoPhillips Email Correspondence.pdf
)
)
)
)
[4] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAG9wAAG
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000P8mQZAAZ
)
[Name] => Enbridge
[Website] => https://sakakaweaareaspillresponse.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/00P3b00001pQVxKEAW
)
[Id] => 00P3b00001pQVxKEAW
[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/00P3b00001pQVxFEAW
)
[Id] => 00P3b00001pQVxFEAW
[Title] => Enbridge Email Correspondence.pdf
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001pQVxKEAW
)
[Id] => 00P3b00001pQVxKEAW
[Title] => Enbridge-Spectra Logo.jpg
)
)
)
)
[5] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAI1sAAG
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/001C000001bVgSdIAK
)
[Name] => Natural Gas Intelligence
[Website] => www.naturalgasintel.com
[Company_Description__c] => Natural Gas Intelligence (NGI) Trusted for more than 35 years, Natural Gas Intelligence (NGI) provides natural gas pricing, forward curves, fundamental data & market insights across the U.S., Canada, & Mexico, as well as LNG pricing & data.
Request NGI Data Information & Pricing Here: NatGasIntel.com/Data
)
[Sponsorship_Type__c] => Sponsor-Logo Display Only
[Priority__c] =>
[Sponsorship__c] => Natural Gas Intelligence
[Sponsor_Website__c] => https://www.naturalgasintel.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/00P3b00001rKiAoEAK
)
[Id] => 00P3b00001rKiAoEAK
[Title] => NEW Rounded NGI 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/00P3b00001rKiAoEAK
)
[Id] => 00P3b00001rKiAoEAK
[Title] => NEW Rounded NGI logo.jpg
)
)
)
)
[6] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAG3eAAG
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000PSV5iAAH
)
[Name] => Williams/Sequent Energy Management
[Website] => www.williams.com
[Company_Description__c] => Gas-Natural
)
[Sponsorship_Type__c] => Sponsor-Logo Display Only
[Priority__c] =>
[Sponsorship__c] => Sequent Energy Management/Williams
[Sponsor_Website__c] => https://www.williams.com/sequent/
[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/00P3b00001pQU5BEAW
)
[Id] => 00P3b00001pQU5BEAW
[Title] => Wiliams-Sequent Energy Management 2021.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/00P3b00001pQU56EAG
)
[Id] => 00P3b00001pQU56EAG
[Title] => Williams-Sequent Email Correspondence.pdf
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001pQU5BEAW
)
[Id] => 00P3b00001pQU5BEAW
[Title] => Wiliams-Sequent Energy Management 2021.jpg
)
)
)
)
[7] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAJeVAAW
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/001C000001WmwtsIAB
)
[Name] => Spire Inc
[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/00P3b00001rLFVjEAO
)
[Id] => 00P3b00001rLFVjEAO
[Title] => Spire_logo_SM_CMYK.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/00P3b00001rLFVUEA4
)
[Id] => 00P3b00001rLFVUEA4
[Title] => 2022 Spire Email Correspondence.pdf
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001rLFVjEAO
)
[Id] => 00P3b00001rLFVjEAO
[Title] => Spire_logo_SM_CMYK.JPG
)
)
)
)
[8] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAFvZAAW
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000PSV5iAAH
)
[Name] => Williams/Sequent Energy Management
[Website] => www.williams.com
[Company_Description__c] => Gas-Natural
)
[Sponsorship_Type__c] => Sponsor with speaker
[Priority__c] =>
[Sponsorship__c] => Williams/Sequent Energy Management
[Sponsor_Website__c] => https://www.williams.com/sequent/
[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/00P3b00001pQSJCEA4
)
[Id] => 00P3b00001pQSJCEA4
[Title] => Williams 2021.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/00P3b00001pQSJ7EAO
)
[Id] => 00P3b00001pQSJ7EAO
[Title] => Williams-Sequent Email Correspondence.pdf
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001pQSJCEA4
)
[Id] => 00P3b00001pQSJCEA4
[Title] => Williams 2021.jpg
)
)
)
)
)
)
'