Media & Association Partners – 2023
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 ('a0D3b0000168PpOEAU') AND Sponsorship_Type__c IN ('Media Partners','Media Sponsor-Trade') ORDER BY Sponsorship__c, Sponsor_Name__r.Name
stdClass Object ( [totalSize] => 17 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNT7AAM ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b00001vLNchAAG ) [Name] => Midstream Calendar [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Allstream Calendar [Sponsor_Website__c] => https://allstreamep.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/00P3b00001xZinjEAC ) [Id] => 00P3b00001xZinjEAC [Title] => Allstream.jpg ) ) ) ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNkKAAU ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0018000000UrtvuAAB ) [Name] => BIC Alliance [Website] => www.bicalliance.com [Company_Description__c] => Miscellaneous Chemical Products Mfg ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => BIC Alliance [Sponsor_Website__c] => https://www.bicalliance.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/00P3b00001xZkHmEAK ) [Id] => 00P3b00001xZkHmEAK [Title] => bicmagazine_logo.jpg ) ) ) ) [2] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNjgAAE ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000000qA6aBIAS ) [Name] => Center for Liquefied Natural Gas [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Center for Liquefied Natural Gas [Sponsor_Website__c] => https://www.lngfacts.org/ [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/00P3b00001xZkFMEA0 ) [Id] => 00P3b00001xZkFMEA0 [Title] => 2022 CLNG.jpg ) ) ) ) [3] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNSOAA2 ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b00001vLNchAAG ) [Name] => Midstream Calendar [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Downstream Calendar [Sponsor_Website__c] => https://downstreamcalendar.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/00P3b00001xZilLEAS ) [Id] => 00P3b00001xZilLEAS [Title] => Downstream-Calendar-Logo.jpg ) ) ) ) [4] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNUeAAM ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C00000140uYWIAY ) [Name] => GAS Power [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => GAS Power [Sponsor_Website__c] => http://www.powermag.com/category/gas/ [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/00P3b00001xZiuGEAS ) [Id] => 00P3b00001xZiuGEAS [Title] => Gas POWER_white.jpg ) ) ) ) [5] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNS9AAM ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b00001vLNchAAG ) [Name] => Midstream Calendar [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Midstream Calendar [Sponsor_Website__c] => https://midstreamcalendar.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/00P3b00001xZikEEAS ) [Id] => 00P3b00001xZikEEAS [Title] => Midstream Calendar.jpg ) ) ) ) [6] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNU5AAM ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b00001yeUGPAA2 ) [Name] => Mississippi Natural Gas Association [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Mississippi Natural Gas Association [Sponsor_Website__c] => https://www.mnga.org/ [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/00P3b00001xZirgEAC ) [Id] => 00P3b00001xZirgEAC [Title] => MNGA_Logo .jpg ) ) ) ) [7] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNisAAE ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001deiGfIAI ) [Name] => Nape/Aapl [Website] => http://napeexpo.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => NAPE/AAPL [Sponsor_Website__c] => www.napeexpo.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/00P3b00001xZkDkEAK ) [Id] => 00P3b00001xZkDkEAK [Title] => NAPE_Logo.jpg ) ) ) ) [8] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNjlAAE ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0018000000RkRcCAAV ) [Name] => Natural Gas Supply Association [Website] => www.ngsa.org [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Natural Gas Supply Association [Sponsor_Website__c] => www.ngsa.org [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/00P3b00001xZkF2EAK ) [Id] => 00P3b00001xZkF2EAK [Title] => NGSA_cmyk.jpg ) ) ) ) [9] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdSZ6AAM ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000000nwGhrIAE ) [Name] => Kleinfelder Personnel [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Pipeliners club of Atlanta [Sponsor_Website__c] => https://www.atlantapipeliners.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/00P3b00001xbP3GEAU ) [Id] => 00P3b00001xbP3GEAU [Title] => Pipeliners club of atlanta.jpeg ) ) ) ) [10] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNV8AAM ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0018000000SGSjMAAX ) [Name] => POWER magazine [Website] => www.accessintel.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => POWER magazine [Sponsor_Website__c] => www.powermag.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/00P3b00001xZiwCEAS ) [Id] => 00P3b00001xZiwCEAS [Title] => POWER logo.jpg ) ) ) ) [11] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNiEAAU ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b00001qHYZvAAO ) [Name] => Renewable Natural Gas (RNG) Coalition [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Renewable Natural Gas (RNG) Coalition [Sponsor_Website__c] => https://www.rngcoalition.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/00P3b00001xZk4FEAS ) [Id] => 00P3b00001xZk4FEAS [Title] => Coalition for Renewable Natural Gas.jpg ) ) ) ) [12] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNTMAA2 ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b00001vLNchAAG ) [Name] => Midstream Calendar [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Renewables Calendar [Sponsor_Website__c] => http://www.RenewablesCalendar.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/00P3b00001xZilWEAS ) [Id] => 00P3b00001xZilWEAS [Title] => Renewables Calendar .jpg ) ) ) ) [13] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002plOMBAA2 ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001Lr3miIAB ) [Name] => Southern Gas Association [SGA] [Website] => www.southerngas.org [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => Southern Gas Association (SGA) [Sponsor_Website__c] => www.southerngas.org [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/00P3b00001yhRIUEA2 ) [Id] => 00P3b00001yhRIUEA2 [Title] => SGA logo cmyk - HighRes.jpg ) ) ) ) [14] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002plWAtAAM ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001GDGE2IAP ) [Name] => Utility Dive [Website] => https://www.utilitydive.com/ [Company_Description__c] => Utility Dive is an industry dashboard designed to keep energy industry professionals connected with information that is critical to their jobs. We monitor news, trending commentary and social insights, stock market updates, jobs, industry research, and more. Our editorial team selects the most important, interesting, and relevant content for our dashboard. Give us 60 seconds, and we can give you everything you need to know to stay ahead. ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => Utility Dive [Sponsor_Website__c] => https://www.utilitydive.com/link/5985/?utm_campaign=LDC-Partnership-202301052023 [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/00P3b00001yhqyXEAQ ) [Id] => 00P3b00001yhqyXEAQ [Title] => Utility_Logo_black.jpg ) ) ) ) [15] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNkAAAU ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0018000000ld3fUAAQ ) [Name] => World Oils [Website] => worldoils.com/showevents.php?id=7719 [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => WorldOils [Sponsor_Website__c] => https://worldoils.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/00P3b00001xZkH3EAK ) [Id] => 00P3b00001xZkH3EAK [Title] => World Oils.jpg ) ) ) ) [16] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNv7AAE ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b000022iZ5WAAU ) [Name] => Young Pipeline Professionals [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Young Pipeline Professionals [Sponsor_Website__c] => https://www.yppusa.org/ [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/00P3b00001xZrxAEAS ) [Id] => 00P3b00001xZrxAEAS [Title] => YPPUSA_Logo_Website_FNL_Dec29.jpg ) ) ) ) ) )
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 ('a0D3b000015otCuEAI') AND Sponsorship_Type__c IN ('Media Partners','Media Sponsor-Trade') ORDER BY Sponsorship__c, Sponsor_Name__r.Name
stdClass Object ( [totalSize] => 19 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002kkTZnAAM ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b00001vLNchAAG ) [Name] => Midstream Calendar [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Allstream Calendar [Sponsor_Website__c] => https://allstreamep.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/00P3b00001s8PLIEA2 ) [Id] => 00P3b00001s8PLIEA2 [Title] => Allstream.jpg ) ) ) ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGO5AAO ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0018000000UrtvuAAB ) [Name] => BIC Alliance [Website] => www.bicalliance.com [Company_Description__c] => Miscellaneous Chemical Products Mfg ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => BIC Alliance [Sponsor_Website__c] => https://www.bicalliance.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/00P3b00001pQaLcEAK ) [Id] => 00P3b00001pQaLcEAK [Title] => bicmagazine_logo.jpg ) ) ) ) [2] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGMnAAO ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000000qA6aBIAS ) [Name] => Center for Liquefied Natural Gas [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Center for Liquefied Natural Gas [Sponsor_Website__c] => https://www.lngfacts.org/ [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/00P3b00001v8h32EAA ) [Id] => 00P3b00001v8h32EAA [Title] => 2022 CLNG.jpg ) ) ) ) [3] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002kkXPNAA2 ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001GDGE2IAP ) [Name] => Utility Dive [Website] => https://www.utilitydive.com/ [Company_Description__c] => Utility Dive is an industry dashboard designed to keep energy industry professionals connected with information that is critical to their jobs. We monitor news, trending commentary and social insights, stock market updates, jobs, industry research, and more. Our editorial team selects the most important, interesting, and relevant content for our dashboard. Give us 60 seconds, and we can give you everything you need to know to stay ahead. ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Dive Wire [Sponsor_Website__c] => https://www.utilitydive.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/00P3b00001v7n9KEAQ ) [Id] => 00P3b00001v7n9KEAQ [Title] => divewire-color.jpg ) ) ) ) [4] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGabAAG ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b00001vLNchAAG ) [Name] => Midstream Calendar [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Downstream Calendar [Sponsor_Website__c] => https://downstreamcalendar.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/00P3b00001pQdQ6EAK ) [Id] => 00P3b00001pQdQ6EAK [Title] => Downstream-Calendar-Logo.jpg ) ) ) ) [5] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002SN8WlAAL ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b00001zJF7UAAW ) [Name] => Energy Strong [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Energy Strong [Sponsor_Website__c] => https://energystrong.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/00P3b00001rVw40EAC ) [Id] => 00P3b00001rVw40EAC [Title] => Energy Strong.jpg ) ) ) ) [6] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGJFAA4 ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C00000140uYWIAY ) [Name] => GAS Power [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => GAS Power [Sponsor_Website__c] => http://www.powermag.com/category/gas/ [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/00P3b00001pQZvEEAW ) [Id] => 00P3b00001pQZvEEAW [Title] => Gas POWER_white.jpg ) ) ) ) [7] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGGzAAO ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b00001vLNchAAG ) [Name] => Midstream Calendar [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Midstream Calendar [Sponsor_Website__c] => https://midstreamcalendar.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/00P3b00001pQYf5EAG ) [Id] => 00P3b00001pQYf5EAG [Title] => Midstream Calendar.jpg ) ) ) ) [8] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGHTAA4 ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b00001yeUGPAA2 ) [Name] => Mississippi Natural Gas Association [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Mississippi Natural Gas Association [Sponsor_Website__c] => https://www.mnga.org/ [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/00P3b00001pQYjFEAW ) [Id] => 00P3b00001pQYjFEAW [Title] => MNGA_Logo .jpg ) ) ) ) [9] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGJuAAO ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001deiGfIAI ) [Name] => Nape/Aapl [Website] => http://napeexpo.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => NAPE/AAPL [Sponsor_Website__c] => www.napeexpo.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/00P3b00001pQa39EAC ) [Id] => 00P3b00001pQa39EAC [Title] => NAPE_Logo.jpg ) ) ) ) [10] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGNbAAO ) [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] => Media Partners [Priority__c] => [Sponsorship__c] => Natural Gas Intelligence [Sponsor_Website__c] => 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/00P3b00001pQaF7EAK ) [Id] => 00P3b00001pQaF7EAK [Title] => NGI_Logo_Square_High_Res.jpg ) ) ) ) [11] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGMEAA4 ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0018000000RkRcCAAV ) [Name] => Natural Gas Supply Association [Website] => www.ngsa.org [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Natural Gas Supply Association [Sponsor_Website__c] => www.ngsa.org [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/00P3b00001pQaAAEA0 ) [Id] => 00P3b00001pQaAAEA0 [Title] => NGSA_cmyk.jpg ) ) ) ) [12] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGHxAAO ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001c9xzTIAQ ) [Name] => OG Directory [Website] => www.ongmarketplace.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => OG Directory [Sponsor_Website__c] => www.ogdirectory.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/00P3b00001pQYnmEAG ) [Id] => 00P3b00001pQYnmEAG [Title] => OG Directory JPEG Tall.jpg ) ) ) ) [13] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGJjAAO ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0018000000SGSjMAAX ) [Name] => POWER magazine [Website] => www.accessintel.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => POWER magazine [Sponsor_Website__c] => www.powermag.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/00P3b00001pQZvnEAG ) [Id] => 00P3b00001pQZvnEAG [Title] => POWER logo.jpg ) ) ) ) [14] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGIRAA4 ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000000xAKemIAG ) [Name] => RBN Energy LLC [Website] => www.rbnenergy.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => RBN Energy LLC [Sponsor_Website__c] => https://rbnenergy.com/before-the-deluge-more-mexican-gas-pipelines-on-the-way-but-challenges-loom [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/00P3b00001pQYv2EAG ) [Id] => 00P3b00001pQYv2EAG [Title] => RBN Logo Horz.jpg ) ) ) ) [15] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGN7AAO ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b00001qHYZvAAO ) [Name] => Renewable Natural Gas (RNG) Coalition [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Renewable Natural Gas (RNG) Coalition [Sponsor_Website__c] => https://www.rngcoalition.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/00P3b00001pQaDsEAK ) [Id] => 00P3b00001pQaDsEAK [Title] => Coalition for Renewable Natural Gas.jpg ) ) ) ) [16] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGKmAAO ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001ahUU5IAM ) [Name] => South Texas Energy & Economic Roundtable [Website] => www.steer.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => STEER [Sponsor_Website__c] => https://www.steer.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/00P3b00001pQZzxEAG ) [Id] => 00P3b00001pQZzxEAG [Title] => Logo-STEER_spot.jpg ) ) ) ) [17] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGKIAA4 ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001FHLDbIAP ) [Name] => Texas Oil & Gas Association [Website] => www.txoga.org [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Texas Oil & Gas Association [Sponsor_Website__c] => https://www.txoga.org [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/00P3b00001pQZyyEAG ) [Id] => 00P3b00001pQZyyEAG [Title] => TXOGA-2015.color.tag.jpg ) ) ) ) [18] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGLGAA4 ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b00001qHoPyAAK ) [Name] => World Gas Conference/CWC Event Solutions [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => World Gas Conference/CWC Event Solutions [Sponsor_Website__c] => www.wgc2021.org [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/00P3b00001pQa1OEAS ) [Id] => 00P3b00001pQa1OEAS [Title] => WGC2022 logo_horizontal.jpg ) ) ) ) ) )
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 IN ('Media Partners','Media Sponsor-Trade') 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/a063b00002gkAA1AAM ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000000qA6aBIAS ) [Name] => Center for Liquefied Natural Gas [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Center for Liquefied Natural Gas [Sponsor_Website__c] => www.lngfacts.org [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/00P3b00001jcNFoEAM ) [Id] => 00P3b00001jcNFoEAM [Title] => CLNG Logo.jpg ) ) ) ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002ZwZbvAAF ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C00000140uYWIAY ) [Name] => GAS Power [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => GAS Power [Sponsor_Website__c] => www.powermag.com/category/gas/ [Sponsor_Contact__c] => [Sponsor_Email__c] => [Sponsor_Phone__c] => [Sponsor_Address__c] => [Company_Description__c] => GAS POWER Direct delivers the latest news and technology stories about the gas-fired generation market to subscribers around the world. Companies targeting the gas segment of the power generation industry can have their advertisements delivered directly to readers. [NotesAndAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => NoteAndAttachment [url] => /services/data/v41.0/sobjects/NoteAndAttachment/00P3b00001ifyewEAA ) [Id] => 00P3b00001ifyewEAA [Title] => Gas POWER_white.jpg ) ) ) ) [2] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002cAmvuAAC ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b00001vLNchAAG ) [Name] => Midstream Calendar [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Midstream Calendar [Sponsor_Website__c] => https://midstreamcalendar.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/00P3b00001loQYBEA2 ) [Id] => 00P3b00001loQYBEA2 [Title] => Midstream Calendar.jpg ) ) ) ) [3] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002ZwZZuAAN ) [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] => Media Partners [Priority__c] => [Sponsorship__c] => Natural Gas Intelligence [Sponsor_Website__c] => 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/00P3b00001jcRENEA2 ) [Id] => 00P3b00001jcRENEA2 [Title] => NGI_Logo_Square_High_Res.jpg ) ) ) ) [4] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002gkAAaAAM ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0018000000RkRcCAAV ) [Name] => Natural Gas Supply Association [Website] => www.ngsa.org [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Natural Gas Supply Association [Sponsor_Website__c] => www.ngsa.org [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/00P3b00001jcNHxEAM ) [Id] => 00P3b00001jcNHxEAM [Title] => NGSA_cmyk.jpg ) ) ) ) [5] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002ZwZanAAF ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001c9xzTIAQ ) [Name] => OG Directory [Website] => www.ongmarketplace.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => OG Directory [Sponsor_Website__c] => www.ogdirectory.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/00P3b00001lnMZFEA2 ) [Id] => 00P3b00001lnMZFEA2 [Title] => JPEG Tall.jpg ) ) ) ) [6] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002gkCRCAA2 ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C0000018OafNIAS ) [Name] => Texas Alliance of Energy Producers [Website] => www.texasalliance.org [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Texas Alliance of Energy Producers [Sponsor_Website__c] => www.texasalliance.org [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/00P3b00001jd0DpEAI ) [Id] => 00P3b00001jd0DpEAI [Title] => Texas Alliance color logo.jpg ) ) ) ) [7] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002ZwZaxAAF ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b00001qHoPyAAK ) [Name] => World Gas Conference/CWC Event Solutions [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => World Gas Conference/CWC Event Solutions [Sponsor_Website__c] => www.wgc2021.org [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/00P3b00001ifyV5EAI ) [Id] => 00P3b00001ifyV5EAI [Title] => WGC2022 logo_horizontal.jpg ) ) ) ) ) )
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 IN ('Media Partners','Media Sponsor-Trade') ORDER BY Sponsorship__c, Sponsor_Name__r.Name
stdClass Object ( [totalSize] => 9 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuZKvAAN ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000000qA6aBIAS ) [Name] => Center for Liquefied Natural Gas [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Center for Liquefied Natural Gas [Sponsor_Website__c] => www.lngfacts.org [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/00P3b00001ZYRRWEA5 ) [Id] => 00P3b00001ZYRRWEA5 [Title] => CLNG Logo.jpg ) ) ) ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuVlYAAV ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001h3DQdIAM ) [Name] => FMN Media LLC [Website] => fuelsmarketnews.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => Fuels Market News [Sponsor_Website__c] => https://fuelsmarketnews.com/industry-calendar/ [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/00P3b00001YMrjAEAT ) [Id] => 00P3b00001YMrjAEAT [Title] => FMN-Logo.jpg ) ) ) ) [2] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuYaGAAV ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C00000140uYWIAY ) [Name] => GAS Power [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => GAS Power [Sponsor_Website__c] => http://www.powermag.com/category/gas/ [Sponsor_Contact__c] => [Sponsor_Email__c] => [Sponsor_Phone__c] => [Sponsor_Address__c] => [Company_Description__c] => GAS POWER Direct delivers the latest news and technology stories about the gas-fired generation market to subscribers around the world. Companies targeting the gas segment of the power generation industry can have their advertisements delivered directly to readers. [NotesAndAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => NoteAndAttachment [url] => /services/data/v41.0/sobjects/NoteAndAttachment/00P3b00001ZXrsPEAT ) [Id] => 00P3b00001ZXrsPEAT [Title] => Gas POWER_white.jpg ) ) ) ) [3] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuWTYAA3 ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001njOhkIAE ) [Name] => Gastech/DMG Events [Website] => www.dmgevens.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Gastech [Sponsor_Website__c] => www.gastechevent.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/00P3b00001YNM35EAH ) [Id] => 00P3b00001YNM35EAH [Title] => GasTech.jpg ) ) ) ) [4] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LubCgAAJ ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001nFEY0IAO ) [Name] => NGV Transportation/LNG Forum Series [Website] => http://naturalgasglobal.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => LNG Forum Series [Sponsor_Website__c] => http://www.lng-world.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/00P3b00001ZZeHoEAL ) [Id] => 00P3b00001ZZeHoEAL [Title] => LNG Forum Series Logo.jpg ) ) ) ) [5] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuceYAAR ) [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] => Media Partners [Priority__c] => [Sponsorship__c] => Natural Gas Intelligence [Sponsor_Website__c] => 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/00P3b00001ZaHCEEA3 ) [Id] => 00P3b00001ZaHCEEA3 [Title] => NGI Logo- UPDATED.jpg ) ) ) ) [6] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuZKWAA3 ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0018000000RkRcCAAV ) [Name] => Natural Gas Supply Association [Website] => www.ngsa.org [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Natural Gas Supply Association [Sponsor_Website__c] => www.ngsa.org [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/00P3b00001ZYRSUEA5 ) [Id] => 00P3b00001ZYRSUEA5 [Title] => NGSA_cmyk.jpg ) ) ) ) [7] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuYZhAAN ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0018000000SGSjMAAX ) [Name] => POWER magazine [Website] => www.accessintel.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => POWER magazine [Sponsor_Website__c] => www.powermag.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/00P3b00001ZXruvEAD ) [Id] => 00P3b00001ZXruvEAD [Title] => POWER logo.jpg ) ) ) ) [8] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LubD5AAJ ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b00001qHoPyAAK ) [Name] => World Gas Conference/CWC Event Solutions [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => World Gas Conference/CWC Event Solutions [Sponsor_Website__c] => www.wgc2021.org [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/00P3b00001ZZeJFEA1 ) [Id] => 00P3b00001ZZeJFEA1 [Title] => WGC 2021 Horizontal Logo.jpg ) ) ) ) ) )
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 ('a0DC000000zkO1zMAE') AND Sponsorship_Type__c IN ('Media Partners','Media Sponsor-Trade') ORDER BY Sponsorship__c, Sponsor_Name__r.Name
stdClass Object ( [totalSize] => 14 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBoMGIA1 ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000000qA6aBIAS ) [Name] => Center for Liquefied Natural Gas [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Center for Liquefied Natural Gas [Sponsor_Website__c] => www.lngfacts.org [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/00PC000001QnTHrMAN ) [Id] => 00PC000001QnTHrMAN [Title] => CLNG Logo.jpg ) ) ) ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002IN63sIAD ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001h3DQdIAM ) [Name] => FMN Media LLC [Website] => fuelsmarketnews.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => FMN Media LLC [Sponsor_Website__c] => https://fuelsmarketnews.com/industry-calendar/ [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/00PC000001R7jqCMAR ) [Id] => 00PC000001R7jqCMAR [Title] => FMN Logo Horz.jpg ) ) ) ) [2] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002IN74XIAT ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C00000140uYWIAY ) [Name] => GAS Power [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => GAS Power [Sponsor_Website__c] => http://www.powermag.com/category/gas/ [Sponsor_Contact__c] => [Sponsor_Email__c] => [Sponsor_Phone__c] => [Sponsor_Address__c] => [Company_Description__c] => GAS POWER Direct delivers the latest news and technology stories about the gas-fired generation market to subscribers around the world. Companies targeting the gas segment of the power generation industry can have their advertisements delivered directly to readers. [NotesAndAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => NoteAndAttachment [url] => /services/data/v41.0/sobjects/NoteAndAttachment/00PC000001R8B01MAF ) [Id] => 00PC000001R8B01MAF [Title] => Gas POWER_white.jpg ) ) ) ) [3] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuCAvAAN ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001njOhkIAE ) [Name] => Gastech/DMG Events [Website] => www.dmgevens.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Gastech [Sponsor_Website__c] => www.gastechevent.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/00P3b00001Viv4BEAR ) [Id] => 00P3b00001Viv4BEAR [Title] => GT_Logo_Varient_Houston 2019-01[1].jpg ) ) ) ) [4] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002Lu9LiAAJ ) [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] => Media Partners [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/v41.0/sobjects/NoteAndAttachment/00P3b00001VhR5wEAF ) [Id] => 00P3b00001VhR5wEAF [Title] => ICIS Logo updated.jpg ) ) ) ) [5] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBs5nIAD ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001nkAwtIAE ) [Name] => HHB Fair Organization Advertising Inc. [Website] => www.hhbexpo.com.tr [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => INGAS [Sponsor_Website__c] => http://www.ingas.istanbul/en/index.html [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/00PC000001SQ2S8MAL ) [Id] => 00PC000001SQ2S8MAL [Title] => INGAS Logo.jpg ) ) ) ) [6] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002IN5UTIA1 ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001nFEY0IAO ) [Name] => NGV Transportation/LNG Forum Series [Website] => http://naturalgasglobal.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => LNG Forum Series [Sponsor_Website__c] => http://naturalgasglobal.com/events/ [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/00PC000001QfNMoMAN ) [Id] => 00PC000001QfNMoMAN [Title] => LNG Logo.jpg ) ) ) ) [7] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002IN73PIAT ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001nFxkfIAC ) [Name] => LNG Marketplace [Website] => www.lngmarketplace.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => LNG Marketplace [Sponsor_Website__c] => www.lngmarketplace.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/00PC000001RRl24MAD ) [Id] => 00PC000001RRl24MAD [Title] => LNG Marketplace Logo Color.jpg ) ) ) ) [8] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002IN64bIAD ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001deiGfIAI ) [Name] => Nape/Aapl [Website] => http://napeexpo.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => NAPE [Sponsor_Website__c] => www.napeexpo.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/00PC000001R7jrKMAR ) [Id] => 00PC000001R7jrKMAR [Title] => NAPE_logo+tagBLACK.jpg ) ) ) ) [9] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b000025Qg6qAAC ) [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] => Media Partners [Priority__c] => [Sponsorship__c] => Natural Gas Intelligence [Sponsor_Website__c] => 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/00P3b00001U5sx7EAB ) [Id] => 00P3b00001U5sx7EAB [Title] => NGI Logo- UPDATED.jpg ) ) ) ) [10] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBoLcIAL ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0018000000RkRcCAAV ) [Name] => Natural Gas Supply Association [Website] => www.ngsa.org [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Natural Gas Supply Association [Sponsor_Website__c] => www.ngsa.org [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/00PC000001QnTG0MAN ) [Id] => 00PC000001QnTG0MAN [Title] => NGSA_cmyk.jpg ) ) ) ) [11] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuCBZAA3 ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001c9xzTIAQ ) [Name] => OG Directory [Website] => www.ongmarketplace.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => ONG Marketplace [Sponsor_Website__c] => www.ongmarketplace.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/00P3b00001ViwljEAB ) [Id] => 00P3b00001ViwljEAB [Title] => ONG Marketplace logo.jpg ) ) ) ) [12] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002IN71YIAT ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0018000000SGSjMAAX ) [Name] => POWER magazine [Website] => www.accessintel.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => POWER magazine [Sponsor_Website__c] => [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/00PC000001R89TeMAJ ) [Id] => 00PC000001R89TeMAJ [Title] => POWER logo.jpg ) ) ) ) [13] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002IN65AIAT ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000000xAKemIAG ) [Name] => RBN Energy LLC [Website] => www.rbnenergy.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => RBN Energy LLC [Sponsor_Website__c] => https://rbnenergy.com/before-the-deluge-more-mexican-gas-pipelines-on-the-way-but-challenges-loom [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/00PC000001R7js9MAB ) [Id] => 00PC000001R7js9MAB [Title] => RBN Logo Horz.jpg ) ) ) ) ) )
Special Thanks to our Media & Association Partners below, who have helped us spread the word about the 2023 Gulf Coast Energy Forum!