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),
(SELECT Id, Title
FROM CombinedAttachments)
FROM Sponsor__c
WHERE Event__r.Id IN ('a0D3b000014mrc9EAA') 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] => 8
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002gkCdHAAU
)
[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/00P3b00001jd3kQEAQ
)
[Id] => 00P3b00001jd3kQEAQ
[Title] => Cleveland Advisory 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/00P3b00001jd3kQEAQ
)
[Id] => 00P3b00001jd3kQEAQ
[Title] => Cleveland Advisory logo.jpg
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001jd3ktEAA
)
[Id] => 00P3b00001jd3ktEAA
[Title] => Cleveland Advisory Email Correspondence.pdf
)
)
)
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002Zw8YKAAZ
)
[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] => 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/00P3b00001ify8zEAA
)
[Id] => 00P3b00001ify8zEAA
[Title] => ConocoPhillips.jpg
)
)
)
[CombinedAttachments] => stdClass Object
(
[totalSize] => 3
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001e3nzJEAQ
)
[Id] => 00P3b00001e3nzJEAQ
[Title] => ConocoPhillips Correspondence NGF20 and transfers.pdf
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001e3nzEEAQ
)
[Id] => 00P3b00001e3nzEEAQ
[Title] => 2020 Correspondence.pdf
)
[2] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ify8zEAA
)
[Id] => 00P3b00001ify8zEAA
[Title] => ConocoPhillips.jpg
)
)
)
)
[2] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002ZwAtIAAV
)
[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/00P3b00001fAukfEAC
)
[Id] => 00P3b00001fAukfEAC
[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/00P3b00001fAukfEAC
)
[Id] => 00P3b00001fAukfEAC
[Title] => Enbridge-Spectra Logo.jpg
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001fAuHOEA0
)
[Id] => 00P3b00001fAuHOEA0
[Title] => Enbridge NGF20 Email Correspondence.pdf
)
)
)
)
[3] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002Zw7EiAAJ
)
[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/00P3b00001e3IpMEAU
)
[Id] => 00P3b00001e3IpMEAU
[Title] => I.C.I.S_Logo.jpg
)
)
)
[CombinedAttachments] => stdClass Object
(
[totalSize] => 3
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001e3IqqEAE
)
[Id] => 00P3b00001e3IqqEAE
[Title] => ICIS transfer of 2020 Sponsorship to 2021 .pdf
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001e3IpMEAU
)
[Id] => 00P3b00001e3IpMEAU
[Title] => I.C.I.S_Logo.jpg
)
[2] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001e3IpWEAU
)
[Id] => 00P3b00001e3IpWEAU
[Title] => US-Mexico - ICIS 2020.pdf
)
)
)
)
[4] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002gk9i4AAA
)
[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/00P3b00001jcRClEAM
)
[Id] => 00P3b00001jcRClEAM
[Title] => NGI_Logo_Square_High_Res.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/00P3b00001is1pmEAA
)
[Id] => 00P3b00001is1pmEAA
[Title] => NGI Email Correspondence.pdf
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001jcRClEAM
)
[Id] => 00P3b00001jcRClEAM
[Title] => NGI_Logo_Square_High_Res.jpg
)
)
)
)
[5] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002ZwV2FAAV
)
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0013b00001rFQCnAAO
)
[Name] => Nikkiso-Cryogenics Industries, LLC
[Website] => www.cryoind.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Sponsor with kiosk
[Priority__c] =>
[Sponsorship__c] => Nikkiso-Cryogenics Industries, LLC
[Sponsor_Website__c] => http://www.cosmodyne.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/00P3b00001hd4BLEAY
)
[Id] => 00P3b00001hd4BLEAY
[Title] => NIKKISO_COSMODYNE_NEW_190226.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/00P3b00001hd4BLEAY
)
[Id] => 00P3b00001hd4BLEAY
[Title] => NIKKISO_COSMODYNE_NEW_190226.jpg
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001hd4BBEAY
)
[Id] => 00P3b00001hd4BBEAY
[Title] => 2021 Nikkiso Cryogenics Sponsorships Email Correspondence.pdf
)
)
)
)
[6] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002ZwZHWAA3
)
[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] =>
[CombinedAttachments] => stdClass Object
(
[totalSize] => 2
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ifmjkEAA
)
[Id] => 00P3b00001ifmjkEAA
[Title] => Sapphire Gas Solutions Email Correspondence.pdf
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ify99EAA
)
[Id] => 00P3b00001ify99EAA
[Title] => sapphire gas solutions
)
)
)
)
[7] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002ZwZJSAA3
)
[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/00P3b00001ifnYJEAY
)
[Id] => 00P3b00001ifnYJEAY
[Title] => stabilis-logo-2020.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/00P3b00001ifnYJEAY
)
[Id] => 00P3b00001ifnYJEAY
[Title] => stabilis-logo-2020.jpg
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ifnY4EAI
)
[Id] => 00P3b00001ifnY4EAI
[Title] => Stabilis 2021 Email Correspondence.pdf
)
)
)
)
)
)
Previous Sponsors
'