Sponsors – 2021
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 ('a0D3b000014mrc4EAA') 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/a063b00002Zw8IgAAJ
)
[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 with speaker
[Priority__c] =>
[Sponsorship__c] => BP Energy Company
[Sponsor_Website__c] => http://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/00P3b00001ifyBAEAY
)
[Id] => 00P3b00001ifyBAEAY
[Title] => BP logo.jpeg
)
)
)
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002ZwDmtAAF
)
[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 (a Chevron U.S.A Inc. division
[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/00P3b00001fCcAVEA0
)
[Id] => 00P3b00001fCcAVEA0
[Title] => Chevron.jpg
)
)
)
)
[2] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002gkCdCAAU
)
[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/00P3b00001jd3kFEAQ
)
[Id] => 00P3b00001jd3kFEAQ
[Title] => Cleveland Advisory logo.jpg
)
)
)
)
[3] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002Zw8JUAAZ
)
[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] => http://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/00P3b00001ifyB5EAI
)
[Id] => 00P3b00001ifyB5EAI
[Title] => ConocoPhillips.jpg
)
)
)
)
[4] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002ZwDn3AAF
)
[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] => http://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/00P3b00001fCcFrEAK
)
[Id] => 00P3b00001fCcFrEAK
[Title] => DirectEnergy_2015.jpg
)
)
)
)
[5] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002ZwB6fAAF
)
[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] => http://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/00P3b00001fB1s1EAC
)
[Id] => 00P3b00001fB1s1EAC
[Title] => Enbridge-Spectra Logo.jpg
)
)
)
)
[6] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002ZwYj2AAF
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000f9CswAAE
)
[Name] => Golden Pass LNG
[Website] => www.gpterminal.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Sponsor with Speaker & Keynote Lunch
[Priority__c] =>
[Sponsorship__c] => Golden Pass LNG
[Sponsor_Website__c] => http://www.gpterminal.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/00P3b00001ifyBFEAY
)
[Id] => 00P3b00001ifyBFEAY
[Title] => Golden Pass LNG.jpg
)
)
)
)
[7] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002Zw7EYAAZ
)
[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] => http://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/00P3b00001e3ImhEAE
)
[Id] => 00P3b00001e3ImhEAE
[Title] => I.C.I.S_Logo.jpg
)
)
)
)
[8] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002ZwM6NAAV
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0013b00001qH0wQAAS
)
[Name] => Marlin Gas Services
[Website] =>
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Sponsor with Speaker & Kiosk
[Priority__c] =>
[Sponsorship__c] => Marlin Gas Services
[Sponsor_Website__c] => http://www.chpk.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/00P3b00001gTIbmEAG
)
[Id] => 00P3b00001gTIbmEAG
[Title] => MarlinGas-Logo .jpg
)
)
)
)
[9] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002gk9i9AAA
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/001C000001bVgSdIAK
)
[Name] => Natural Gas Intelligence (NGI)
[Website] => www.naturalgasintel.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Sponsor with speaker
[Priority__c] =>
[Sponsorship__c] => Natural Gas Intelligence
[Sponsor_Website__c] => http://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/00P3b00001jcRCqEAM
)
[Id] => 00P3b00001jcRCqEAM
[Title] => NGI_Logo_Square_High_Res.jpg
)
)
)
)
[10] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002ZwZHRAA3
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0013b00001rFOuIAAW
)
[Name] => Sapphire Gas Solutions
[Website] =>
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Sponsor with speaker
[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/00P3b00001is8qjEAA
)
[Id] => 00P3b00001is8qjEAA
[Title] => sapphire gas solutions.jpg
)
)
)
)
[11] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002ZwDnmAAF
)
[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] => http://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/00P3b00001fCcNxEAK
)
[Id] => 00P3b00001fCcNxEAK
[Title] => Sequent Energy Management.jpg
)
)
)
)
[12] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002ZwB6VAAV
)
[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/00P3b00001fB1rgEAC
)
[Id] => 00P3b00001fB1rgEAC
[Title] => Spire_logo_SM_CMYK.JPG
)
)
)
)
[13] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002ZwZJNAA3
)
[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] => http://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/00P3b00001ifnXGEAY
)
[Id] => 00P3b00001ifnXGEAY
[Title] => stabilis-logo-2020.jpg
)
)
)
)
[14] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002ZwYk0AAF
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0013b00001qoJIoAAM
)
[Name] => Symmetry Energy Solutions
[Website] => SymmetryEnergy.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Sponsor with speaker
[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/00P3b00001ifyB0EAI
)
[Id] => 00P3b00001ifyB0EAI
[Title] => Symmetry Energy Solutions.jpg
)
)
)
)
)
)
'