Sponsors – 2020
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 ('a0D3b000013f0UZEAY') AND Sponsorship_Type__c NOT IN ('Media Partners','Media Sponsor-Trade')
ORDER BY Sponsorship__c, Sponsor_Name__r.NamestdClass Object
(
[totalSize] => 13
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v29.0/sobjects/Sponsor__c/a063b00002LuXJEAA3
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v29.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] => 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/v29.0/sobjects/NoteAndAttachment/00P3b00001ZXCsVEAX
)
[Id] => 00P3b00001ZXCsVEAX
[Title] => BP logo.jpeg
)
)
)
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v29.0/sobjects/Sponsor__c/a063b00002LuZvZAAV
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v29.0/sobjects/Account/001C000001CfxqOIAR
)
[Name] => CenterPoint Energy Services, Inc.
[Website] =>
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Sponsor with Speaker & Kiosk
[Priority__c] =>
[Sponsorship__c] => CenterPoint Energy Services, Inc.
[Sponsor_Website__c] => www.centerpointenergy.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/v29.0/sobjects/NoteAndAttachment/00P3b00001ZZGLVEA5
)
[Id] => 00P3b00001ZZGLVEA5
[Title] => CenterPoint Energy.jpg
)
)
)
)
[2] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v29.0/sobjects/Sponsor__c/a063b00002Lua88AAB
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v29.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] => http://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/v29.0/sobjects/NoteAndAttachment/00P3b00001ZYqZYEA1
)
[Id] => 00P3b00001ZYqZYEA1
[Title] => Cleveland Advisory logo.jpg
)
)
)
)
[3] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v29.0/sobjects/Sponsor__c/a063b00002LuOIAAA3
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v29.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] => 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/v29.0/sobjects/NoteAndAttachment/00P3b00001Wx82SEAR
)
[Id] => 00P3b00001Wx82SEAR
[Title] => ConocoPhillips.jpg
)
)
)
)
[4] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v29.0/sobjects/Sponsor__c/a063b00002LuahCAAR
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v29.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] => 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/v29.0/sobjects/NoteAndAttachment/00P3b00001ZZMdQEAX
)
[Id] => 00P3b00001ZZMdQEAX
[Title] => DirectEnergy_2015.jpg
)
)
)
)
[5] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v29.0/sobjects/Sponsor__c/a063b00002LuYzSAAV
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v29.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] => 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/v29.0/sobjects/NoteAndAttachment/00P3b00001ZYB44EAH
)
[Id] => 00P3b00001ZYB44EAH
[Title] => Enbridge-Spectra Logo.jpg
)
)
)
)
[6] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v29.0/sobjects/Sponsor__c/a063b00002LuXXFAA3
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v29.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] => 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/v29.0/sobjects/NoteAndAttachment/00P3b00001ZYln2EAD
)
[Id] => 00P3b00001ZYln2EAD
[Title] => I.C.I.S_Logo.jpg
)
)
)
)
[7] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v29.0/sobjects/Sponsor__c/a063b00002LuQRdAAN
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v29.0/sobjects/Account/001C000001bW6EEIA0
)
[Name] => Latitude Technologies, LLC
[Website] =>
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Sponsor with kiosk
[Priority__c] =>
[Sponsorship__c] => Latitude Technologies, LLC
[Sponsor_Website__c] => www.esgglobal.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/v29.0/sobjects/NoteAndAttachment/00P3b00001YKCbVEAX
)
[Id] => 00P3b00001YKCbVEAX
[Title] => LatitudeTech_Logo_HiRes.jpg
)
)
)
)
[8] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v29.0/sobjects/Sponsor__c/a063b00002LuZ74AAF
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v29.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] => 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/v29.0/sobjects/NoteAndAttachment/00P3b00001ZYFekEAH
)
[Id] => 00P3b00001ZYFekEAH
[Title] => MarlinGas-Logo .jpg
)
)
)
)
[9] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v29.0/sobjects/Sponsor__c/a063b00002LuOHgAAN
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v29.0/sobjects/Account/001C000001KonOOIAZ
)
[Name] => OPIS by IHS Markit
[Website] =>
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Sponsor with speaker
[Priority__c] =>
[Sponsorship__c] => OPIS by IHS Markit
[Sponsor_Website__c] => http://www.ihsmarkit.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/v29.0/sobjects/NoteAndAttachment/00P3b00001Wx83BEAR
)
[Id] => 00P3b00001Wx83BEAR
[Title] => IHSMarkit Logo.jpg
)
)
)
)
[10] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v29.0/sobjects/Sponsor__c/a063b00002LuUmgAAF
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v29.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] => 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/v29.0/sobjects/NoteAndAttachment/00P3b00001YMKdSEAX
)
[Id] => 00P3b00001YMKdSEAX
[Title] => Sequent-Energy-colored-STACKED.jpg
)
)
)
)
[11] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v29.0/sobjects/Sponsor__c/a063b00002LuYcWAAV
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v29.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] => 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/v29.0/sobjects/NoteAndAttachment/00P3b00001ZY0A9EAL
)
[Id] => 00P3b00001ZY0A9EAL
[Title] => stabilis-logo.jpg
)
)
)
)
[12] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v29.0/sobjects/Sponsor__c/a063b00002LuXWWAA3
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v29.0/sobjects/Account/001C000001iD5BwIAK
)
[Name] => Thigpen Solutions
[Website] =>
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Sponsor with Speaker & Kiosk
[Priority__c] =>
[Sponsorship__c] => Thigpen Solutions
[Sponsor_Website__c] => www.thigpenenergy.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/v29.0/sobjects/NoteAndAttachment/00P3b00001ZXIvVEAX
)
[Id] => 00P3b00001ZXIvVEAX
[Title] => Thigpen Solutions Logo.jpg
)
)
)
)
)
)
'