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.Name
stdClass 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