Media & Association Partners
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 ('a0D3b0000168PpTEAU') 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/a063b00002tdOpkAAE ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001WDCecIAH ) [Name] => AEM Bilateral Energy Committee [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => AEM [Sponsor_Website__c] => https://aemusa.org/chapter-san-antonio/ [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/00P3b00001xa5fkEAA ) [Id] => 00P3b00001xa5fkEAA [Title] => AEM-logo.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001xa5fkEAA ) [Id] => 00P3b00001xa5fkEAA [Title] => AEM-logo.jpg ) ) ) ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNTCAA2 ) [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/00P3b00001xZinoEAC ) [Id] => 00P3b00001xZinoEAC [Title] => Allstream.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001xZinoEAC ) [Id] => 00P3b00001xZinoEAC [Title] => Allstream.jpg ) ) ) ) [2] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdOppAAE ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b00001qFcteAAC ) [Name] => Association Mexicana de Energia (AME) [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => AME [Sponsor_Website__c] => https://asociacionmexicanadeenergia.com.mx/en/ [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/00P3b00001xa5goEAA ) [Id] => 00P3b00001xa5goEAA [Title] => LOGO AME.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/00P3b00001xa5gKEAQ ) [Id] => 00P3b00001xa5gKEAQ [Title] => AMEpdf.pdf ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001xa5goEAA ) [Id] => 00P3b00001xa5goEAA [Title] => LOGO AME.jpg ) ) ) ) [3] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNjqAAE ) [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/00P3b00001xZkFbEAK ) [Id] => 00P3b00001xZkFbEAK [Title] => 2022 CLNG.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001xZkFbEAK ) [Id] => 00P3b00001xZkFbEAK [Title] => 2022 CLNG.jpg ) ) ) ) [4] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06Rd000002emrBIAQ ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001Rd000002ljtNIAQ ) [Name] => Mexican Council for Energy (COMENER) [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => COMENER [Sponsor_Website__c] => https://comener.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/00PRd000001SgDSMA0 ) [Id] => 00PRd000001SgDSMA0 [Title] => COMENER_3-1.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/00PRd000001SgDSMA0 ) [Id] => 00PRd000001SgDSMA0 [Title] => COMENER_3-1.jpg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PRd000001Si7BMAS ) [Id] => 00PRd000001Si7BMAS [Title] => COMENER.pdf ) ) ) ) [5] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNSJAA2 ) [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/00P3b00001xZikdEAC ) [Id] => 00P3b00001xZikdEAC [Title] => Downstream-Calendar-Logo.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001xZikdEAC ) [Id] => 00P3b00001xZikdEAC [Title] => Downstream-Calendar-Logo.jpg ) ) ) ) [6] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002pld5LAAQ ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0018000000V4EVKAA3 ) [Name] => Scudder Publishing Group [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Enelyst [Sponsor_Website__c] => https://www.enelyst.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/00P3b00001zxWvOEAU ) [Id] => 00P3b00001zxWvOEAU [Title] => EnelystLogo.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001zxWvOEAU ) [Id] => 00P3b00001zxWvOEAU [Title] => EnelystLogo.jpg ) ) ) ) [7] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNUjAAM ) [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/00P3b00001xZiuLEAS ) [Id] => 00P3b00001xZiuLEAS [Title] => Gas POWER_white.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001xZiuLEAS ) [Id] => 00P3b00001xZiuLEAS [Title] => Gas POWER_white.jpg ) ) ) ) [8] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002zcFZNAA2 ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b000026AfhJAAS ) [Name] => LNG Global [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => LNG Global [Sponsor_Website__c] => https://www.lngglobal.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/00P3b00001zSC5BEAW ) [Id] => 00P3b00001zSC5BEAW [Title] => lng-global-logo.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001zSC5BEAW ) [Id] => 00P3b00001zSC5BEAW [Title] => lng-global-logo.jpg ) ) ) ) [9] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNSEAA2 ) [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/00P3b00001xZikYEAS ) [Id] => 00P3b00001xZikYEAS [Title] => Midstream Calendar.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001xZikYEAS ) [Id] => 00P3b00001xZikYEAS [Title] => Midstream Calendar.jpg ) ) ) ) [10] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNUAAA2 ) [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/00P3b00001xZirNEAS ) [Id] => 00P3b00001xZirNEAS [Title] => MNGA_Logo .jpeg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001xZirNEAS ) [Id] => 00P3b00001xZirNEAS [Title] => MNGA_Logo .jpeg ) ) ) ) [11] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNixAAE ) [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/00P3b00001xZkDpEAK ) [Id] => 00P3b00001xZkDpEAK [Title] => NAPE_Logo.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001xZkDpEAK ) [Id] => 00P3b00001xZkDpEAK [Title] => NAPE_Logo.jpg ) ) ) ) [12] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002zcFcHAAU ) [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 Sponsor-Trade [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/00P3b0000221esjEAA ) [Id] => 00P3b0000221esjEAA [Title] => NEW Rounded NGI logo.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b0000221esjEAA ) [Id] => 00P3b0000221esjEAA [Title] => NEW Rounded NGI logo.jpg ) ) ) ) [13] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNjvAAE ) [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/00P3b00001xZkF7EAK ) [Id] => 00P3b00001xZkF7EAK [Title] => NGSA_cmyk.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001xZkF7EAK ) [Id] => 00P3b00001xZkF7EAK [Title] => NGSA_cmyk.jpg ) ) ) ) [14] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNVDAA2 ) [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/00P3b00001xZiwMEAS ) [Id] => 00P3b00001xZiwMEAS [Title] => POWER logo.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001xZiwMEAS ) [Id] => 00P3b00001xZiwMEAS [Title] => POWER logo.jpg ) ) ) ) [15] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNiJAAU ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b00001qHYZvAAO ) [Name] => 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/00P3b00001xZk4KEAS ) [Id] => 00P3b00001xZk4KEAS [Title] => Coalition for Renewable Natural Gas.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001xZk4KEAS ) [Id] => 00P3b00001xZk4KEAS [Title] => Coalition for Renewable Natural Gas.jpg ) ) ) ) [16] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002tdNTHAA2 ) [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/00P3b00001xZioNEAS ) [Id] => 00P3b00001xZioNEAS [Title] => Renewables Calendar .jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001xZioNEAS ) [Id] => 00P3b00001xZioNEAS [Title] => Renewables Calendar .jpg ) ) ) ) [17] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002plWAyAAM ) [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/00P3b00001yhqzaEAA ) [Id] => 00P3b00001yhqzaEAA [Title] => Utility_Logo_black.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/00P3b00001yhoJyEAI ) [Id] => 00P3b00001yhoJyEAI [Title] => Industy Utility Dive.pdf ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001yhqzaEAA ) [Id] => 00P3b00001yhqzaEAA [Title] => Utility_Logo_black.jpg ) ) ) ) [18] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002plcSsAAI ) [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/00P3b00001zx2x1EAA ) [Id] => 00P3b00001zx2x1EAA [Title] => World Oils.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001zx2x1EAA ) [Id] => 00P3b00001zx2x1EAA [Title] => World Oils.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), (SELECT Id, Title FROM CombinedAttachments) FROM Sponsor__c WHERE Event__r.Id IN ('a0D3b000015otCpEAI') AND Sponsorship_Type__c IN ('Media Partners','Media Sponsor-Trade') ORDER BY Sponsorship__c, Sponsor_Name__r.Name
stdClass Object ( [totalSize] => 21 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAHk5AAG ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001WDCecIAH ) [Name] => AEM Bilateral Energy Committee [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => AEM [Sponsor_Website__c] => https://aemusa.org/chapter-san-antonio/ [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/00P3b00001pR6xkEAC ) [Id] => 00P3b00001pR6xkEAC [Title] => AEM-logo-1.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001pR6xkEAC ) [Id] => 00P3b00001pR6xkEAC [Title] => AEM-logo-1.jpg ) ) ) ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002kkTZiAAM ) [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/00P3b00001s8PL3EAM ) [Id] => 00P3b00001s8PL3EAM [Title] => Allstream.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001s8PL3EAM ) [Id] => 00P3b00001s8PL3EAM [Title] => Allstream.jpg ) ) ) ) [2] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGOAAA4 ) [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/00P3b00001pQaLwEAK ) [Id] => 00P3b00001pQaLwEAK [Title] => bicmagazine_logo.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001pQaLwEAK ) [Id] => 00P3b00001pQaLwEAK [Title] => bicmagazine_logo.jpg ) ) ) ) [3] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGMxAAO ) [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/00P3b00001v8h1pEAA ) [Id] => 00P3b00001v8h1pEAA [Title] => 2022 CLNG.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001v8h1pEAA ) [Id] => 00P3b00001v8h1pEAA [Title] => 2022 CLNG.jpg ) ) ) ) [4] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002kkXPSAA2 ) [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/00P3b00001v7n9AEAQ ) [Id] => 00P3b00001v7n9AEAQ [Title] => divewire-color.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/00P3b00001su9jmEAA ) [Id] => 00P3b00001su9jmEAA [Title] => Utility Dive Press Releases Email Correspondence.pdf ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001v7n9AEAQ ) [Id] => 00P3b00001v7n9AEAQ [Title] => divewire-color.jpg ) ) ) ) [5] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGa2AAG ) [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/00P3b00001pQdP8EAK ) [Id] => 00P3b00001pQdP8EAK [Title] => Downstream-Calendar-Logo.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001pQdP8EAK ) [Id] => 00P3b00001pQdP8EAK [Title] => Downstream-Calendar-Logo.jpg ) ) ) ) [6] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002SN8WqAAL ) [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/00P3b00001rVw45EAC ) [Id] => 00P3b00001rVw45EAC [Title] => Energy Strong.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001rVw45EAC ) [Id] => 00P3b00001rVw45EAC [Title] => Energy Strong.jpg ) ) ) ) [7] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGJKAA4 ) [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/00P3b00001pQZvJEAW ) [Id] => 00P3b00001pQZvJEAW [Title] => Gas POWER_white.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001pQZvJEAW ) [Id] => 00P3b00001pQZvJEAW [Title] => Gas POWER_white.jpg ) ) ) ) [8] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGH4AAO ) [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/00P3b00001pQYfKEAW ) [Id] => 00P3b00001pQYfKEAW [Title] => Midstream Calendar.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001pQYfKEAW ) [Id] => 00P3b00001pQYfKEAW [Title] => Midstream Calendar.jpg ) ) ) ) [9] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGHYAA4 ) [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/00P3b00001pQYloEAG ) [Id] => 00P3b00001pQYloEAG [Title] => MNGA_Logo .jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001pQYloEAG ) [Id] => 00P3b00001pQYloEAG [Title] => MNGA_Logo .jpg ) ) ) ) [10] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGLpAAO ) [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/00P3b00001pQa3JEAS ) [Id] => 00P3b00001pQa3JEAS [Title] => NAPE_Logo.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001pQa3JEAS ) [Id] => 00P3b00001pQa3JEAS [Title] => NAPE_Logo.jpg ) ) ) ) [11] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAI1sAAG ) [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 Sponsor-Trade [Priority__c] => [Sponsorship__c] => Natural Gas Intelligence [Sponsor_Website__c] => https://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/00P3b00001vlEFJEA2 ) [Id] => 00P3b00001vlEFJEA2 [Title] => NEW Rounded NGI logo.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001vlEFJEA2 ) [Id] => 00P3b00001vlEFJEA2 [Title] => NEW Rounded NGI logo.jpg ) ) ) ) [12] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGM9AAO ) [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/00P3b00001pQa9gEAC ) [Id] => 00P3b00001pQa9gEAC [Title] => NGSA_cmyk.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001pQa9gEAC ) [Id] => 00P3b00001pQa9gEAC [Title] => NGSA_cmyk.jpg ) ) ) ) [13] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGI2AAO ) [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/00P3b00001pQYnrEAG ) [Id] => 00P3b00001pQYnrEAG [Title] => OG Directory JPEG Tall.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001pQYnrEAG ) [Id] => 00P3b00001pQYnrEAG [Title] => OG Directory JPEG Tall.jpg ) ) ) ) [14] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGJoAAO ) [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/00P3b00001pQZvsEAG ) [Id] => 00P3b00001pQZvsEAG [Title] => POWER logo.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001pQZvsEAG ) [Id] => 00P3b00001pQZvsEAG [Title] => POWER logo.jpg ) ) ) ) [15] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGIbAAO ) [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/00P3b00001pQYvCEAW ) [Id] => 00P3b00001pQYvCEAW [Title] => RBN Logo Horz.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001pQYvCEAW ) [Id] => 00P3b00001pQYvCEAW [Title] => RBN Logo Horz.jpg ) ) ) ) [16] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGN2AAO ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b00001qHYZvAAO ) [Name] => 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/00P3b00001pQaDYEA0 ) [Id] => 00P3b00001pQaDYEA0 [Title] => Coalition for Renewable Natural Gas.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001pQaDYEA0 ) [Id] => 00P3b00001pQaDYEA0 [Title] => Coalition for Renewable Natural Gas.jpg ) ) ) ) [17] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGLuAAO ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b00001yeUcVAAU ) [Name] => San Antonio Pipeliners Association (SAPA) [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => San Antonio Pipeliners Association (SAPA) [Sponsor_Website__c] => https://sapipeliners.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/00P3b00001pQa6mEAC ) [Id] => 00P3b00001pQa6mEAC [Title] => San Antonio Pipeliners Association.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001pQa6mEAC ) [Id] => 00P3b00001pQa6mEAC [Title] => San Antonio Pipeliners Association.jpg ) ) ) ) [18] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGKrAAO ) [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/00P3b00001pQa02EAC ) [Id] => 00P3b00001pQa02EAC [Title] => Logo-STEER_spot.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001pQa02EAC ) [Id] => 00P3b00001pQa02EAC [Title] => Logo-STEER_spot.jpg ) ) ) ) [19] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGJyAAO ) [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/00P3b00001pQZyFEAW ) [Id] => 00P3b00001pQZyFEAW [Title] => TXOGA-2015.color.tag.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001pQZyFEAW ) [Id] => 00P3b00001pQZyFEAW [Title] => TXOGA-2015.color.tag.jpg ) ) ) ) [20] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGLLAA4 ) [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/00P3b00001pQa1KEAS ) [Id] => 00P3b00001pQa1KEAS [Title] => WGC2022 logo_horizontal.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001pQa1KEAS ) [Id] => 00P3b00001pQa1KEAS [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), (SELECT Id, Title FROM CombinedAttachments) FROM Sponsor__c WHERE Event__r.Id IN ('a0D3b000014mrc9EAA') 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/a063b00002gkAABAA2 ) [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/00P3b00001jcNG3EAM ) [Id] => 00P3b00001jcNG3EAM [Title] => CLNG 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/00P3b00001jcNFyEAM ) [Id] => 00P3b00001jcNFyEAM [Title] => CLNG - NGSA Email Correspondence.pdf ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001jcNG3EAM ) [Id] => 00P3b00001jcNG3EAM [Title] => CLNG Logo.jpg ) ) ) ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002ZwZbqAAF ) [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/00P3b00001ifye8EAA ) [Id] => 00P3b00001ifye8EAA [Title] => Gas POWER_white.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ifye8EAA ) [Id] => 00P3b00001ifye8EAA [Title] => Gas POWER_white.jpg ) ) ) ) [2] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002cAmvzAAC ) [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/00P3b00001loQkkEAE ) [Id] => 00P3b00001loQkkEAE [Title] => Midstream Calendar.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/00P3b00001loQkaEAE ) [Id] => 00P3b00001loQkaEAE [Title] => Midstream Calendar Email Correspondence.pdf ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001loQkkEAE ) [Id] => 00P3b00001loQkkEAE [Title] => Midstream Calendar.jpg ) ) ) ) [3] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002ZwZaJAAV ) [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/00P3b00001nXSCgEAO ) [Id] => 00P3b00001nXSCgEAO [Title] => NEW Rounded NGI 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/00P3b00001jcRDUEA2 ) [Id] => 00P3b00001jcRDUEA2 [Title] => NGI_Logo_Square_High_Res.jpg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001jcRGTEA2 ) [Id] => 00P3b00001jcRGTEA2 [Title] => NGI Email Correspondence.pdf ) [2] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001nXSCgEAO ) [Id] => 00P3b00001nXSCgEAO [Title] => NEW Rounded NGI logo.jpg ) ) ) ) [4] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002gkAALAA2 ) [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/00P3b00001jcNHEEA2 ) [Id] => 00P3b00001jcNHEEA2 [Title] => NGSA_cmyk.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/00P3b00001jcNH9EAM ) [Id] => 00P3b00001jcNH9EAM [Title] => CLNG - NGSA Email Correspondence.pdf ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001jcNHEEA2 ) [Id] => 00P3b00001jcNHEEA2 [Title] => NGSA_cmyk.jpg ) ) ) ) [5] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002ZwZasAAF ) [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/00P3b00001lnMZKEA2 ) [Id] => 00P3b00001lnMZKEA2 [Title] => JPEG Tall.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001lnMZKEA2 ) [Id] => 00P3b00001lnMZKEA2 [Title] => JPEG Tall.jpg ) ) ) ) [6] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002gkCRHAA2 ) [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/00P3b00001jd0FQEAY ) [Id] => 00P3b00001jd0FQEAY [Title] => Texas Alliance color 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/00P3b00001jd0FGEAY ) [Id] => 00P3b00001jd0FGEAY [Title] => Texas Alliance Email Correspondence.pdf ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001jd0FQEAY ) [Id] => 00P3b00001jd0FQEAY [Title] => Texas Alliance color logo.jpg ) ) ) ) [7] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002ZwZb2AAF ) [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/00P3b00001ifyVUEAY ) [Id] => 00P3b00001ifyVUEAY [Title] => WGC2022 logo_horizontal.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ifyVUEAY ) [Id] => 00P3b00001ifyVUEAY [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), (SELECT Id, Title FROM CombinedAttachments) FROM Sponsor__c WHERE Event__r.Id IN ('a0D3b000013f0UeEAI') AND Sponsorship_Type__c IN ('Media Partners','Media Sponsor-Trade') ORDER BY Sponsorship__c, Sponsor_Name__r.Name
stdClass Object ( [totalSize] => 12 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuZiWAAV ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001fgXwkIAE ) [Name] => Asociación Mexicana de Gas Natural (AMGN) [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => Asociación Mexicana de Gas Natural (AMGN) [Sponsor_Website__c] => www.amgn.org.mx [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/00P3b00001ZYdzbEAD ) [Id] => 00P3b00001ZYdzbEAD [Title] => AMGN_LOGOTIPO_COLOR.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/00P3b00001ZYdx0EAD ) [Id] => 00P3b00001ZYdx0EAD [Title] => Media Partner for US-Mex.pdf ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ZYdzbEAD ) [Id] => 00P3b00001ZYdzbEAD [Title] => AMGN_LOGOTIPO_COLOR.jpg ) ) ) ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuVvXAAV ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0013b00001qFcteAAC ) [Name] => Association Mexicana de Energia (AME) [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => Association Mexicana de Energia (AME) [Sponsor_Website__c] => www.asociacionmexicanadeenergia.com.mx [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/00P3b00001YMyAZEA1 ) [Id] => 00P3b00001YMyAZEA1 [Title] => LOGO AME.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/00P3b00001YMy7fEAD ) [Id] => 00P3b00001YMy7fEAD [Title] => Media Partner.pdf ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001YMyAZEA1 ) [Id] => 00P3b00001YMyAZEA1 [Title] => LOGO AME.jpg ) ) ) ) [2] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuZKqAAN ) [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/00P3b00001ZYRQeEAP ) [Id] => 00P3b00001ZYRQeEAP [Title] => CLNG Logo.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ZYRQeEAP ) [Id] => 00P3b00001ZYRQeEAP [Title] => CLNG Logo.jpg ) ) ) ) [3] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuVldAAF ) [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/00P3b00001YMrj5EAD ) [Id] => 00P3b00001YMrj5EAD [Title] => FMN-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/00P3b00001YMrj5EAD ) [Id] => 00P3b00001YMrj5EAD [Title] => FMN-Logo.jpg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001YMrqBEAT ) [Id] => 00P3b00001YMrqBEAT [Title] => FMN Email Correspondence.pdf ) ) ) ) [4] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuYaaAAF ) [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/00P3b00001ZXrs0EAD ) [Id] => 00P3b00001ZXrs0EAD [Title] => Gas POWER_white.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ZXrs0EAD ) [Id] => 00P3b00001ZXrs0EAD [Title] => Gas POWER_white.jpg ) ) ) ) [5] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuWTxAAN ) [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/DMG Events [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/00P3b00001YNM3AEAX ) [Id] => 00P3b00001YNM3AEAX [Title] => GasTech.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/00P3b00001YNLoiEAH ) [Id] => 00P3b00001YNLoiEAH [Title] => Media Partner confirm.pdf ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001YNM3AEAX ) [Id] => 00P3b00001YNM3AEAX [Title] => GasTech.jpg ) ) ) ) [6] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002Luo4bAAB ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001jfW5oIAE ) [Name] => International Society for Mexico Energy [Website] => www.ISMexicoEnergy.org [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => International Society for Mexico Energy [Sponsor_Website__c] => www.ismexicoenergy.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/00P3b00001asUieEAE ) [Id] => 00P3b00001asUieEAE [Title] => ISME_Logo_2_lines_404445885.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/00P3b00001asUieEAE ) [Id] => 00P3b00001asUieEAE [Title] => ISME_Logo_2_lines_404445885.jpg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001asVaxEAE ) [Id] => 00P3b00001asVaxEAE [Title] => doc00868720200429114325.pdf ) ) ) ) [7] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuceTAAR ) [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/00P3b00001ZaHCsEAN ) [Id] => 00P3b00001ZaHCsEAN [Title] => NEW Rounded NGI 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/00P3b00001ZaGi9EAF ) [Id] => 00P3b00001ZaGi9EAF [Title] => Media Trade Confirm notes.pdf ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ZaHCsEAN ) [Id] => 00P3b00001ZaHCsEAN [Title] => NEW Rounded NGI logo.jpg ) ) ) ) [8] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuZKlAAN ) [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/00P3b00001ZYRS0EAP ) [Id] => 00P3b00001ZYRS0EAP [Title] => NGSA_cmyk.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ZYRS0EAP ) [Id] => 00P3b00001ZYRS0EAP [Title] => NGSA_cmyk.jpg ) ) ) ) [9] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuYZrAAN ) [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/00P3b00001ZXrvtEAD ) [Id] => 00P3b00001ZXrvtEAD [Title] => POWER logo.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ZXrvtEAD ) [Id] => 00P3b00001ZXrvtEAD [Title] => POWER logo.jpg ) ) ) ) [10] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LubDAAAZ ) [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/00P3b00001ZZeJPEA1 ) [Id] => 00P3b00001ZZeJPEA1 [Title] => WGC 2021 Horizontal 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/00P3b00001ZZeGhEAL ) [Id] => 00P3b00001ZZeGhEAL [Title] => WGC 2021 Media Partnership_LDC Gas Forums.pdf ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ZZeJPEA1 ) [Id] => 00P3b00001ZZeJPEA1 [Title] => WGC 2021 Horizontal Logo.jpg ) ) ) ) [11] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002Luak6AAB ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0018000000SGTAGAA5 ) [Name] => World Oil [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => World Oil [Sponsor_Website__c] => www.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/00P3b00001ZZO26EAH ) [Id] => 00P3b00001ZZO26EAH [Title] => wo_logo_jpg_300res.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/00P3b00001ZZNXuEAP ) [Id] => 00P3b00001ZZNXuEAP [Title] => World Oil media trade.pdf ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ZZO26EAH ) [Id] => 00P3b00001ZZO26EAH [Title] => wo_logo_jpg_300res.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), (SELECT Id, Title FROM CombinedAttachments) FROM Sponsor__c WHERE Event__r.Id IN ('a0DC000000zkNxJMAU') 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/a06C000002IN7uRIAT ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001WDCecIAH ) [Name] => AEM Bilateral Energy Committee [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => AEM Bilateral Energy Committee [Sponsor_Website__c] => www.aem-sanantonio.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/00P3b00001VifxFEAR ) [Id] => 00P3b00001VifxFEAR [Title] => AEM-logo3.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/00P3b00001VifxFEAR ) [Id] => 00P3b00001VifxFEAR [Title] => AEM-logo3.jpg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001RRS4UMAX ) [Id] => 00PC000001RRS4UMAX [Title] => AEM FW 2019 Media Partnership with US-Mexico Natural Gas Forum.msg ) [2] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001RRSiAMAX ) [Id] => 00PC000001RRSiAMAX [Title] => AEM.jpg ) ) ) ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002IN7uWIAT ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001fgXwkIAE ) [Name] => Asociación Mexicana de Gas Natural (AMGN) [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => Asociación Mexicana de Gas Natural (AMGN) [Sponsor_Website__c] => www.amgn.org.mx [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/00PC000001RRSg9MAH ) [Id] => 00PC000001RRSg9MAH [Title] => AMGN jpeg.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/00PC000001RRS95MAH ) [Id] => 00PC000001RRS95MAH [Title] => FW US-Mexico Forum - AMGN.msg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001RRSg9MAH ) [Id] => 00PC000001RRSg9MAH [Title] => AMGN jpeg.jpg ) [2] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001RRrwqMAD ) [Id] => 00PC000001RRrwqMAD [Title] => 2019 Association Agreement AMGN -SIGNED.pdf ) ) ) ) [2] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBoMQIA1 ) [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/00PC000001QnTotMAF ) [Id] => 00PC000001QnTotMAF [Title] => CLNG 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/00PC000001QnS21MAF ) [Id] => 00PC000001QnS21MAF [Title] => Input trades into SF.msg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001QnTmDMAV ) [Id] => 00PC000001QnTmDMAV [Title] => NGSA- CLNG Agreement - SIGNED.pdf ) [2] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001QnTotMAF ) [Id] => 00PC000001QnTotMAF [Title] => CLNG Logo.jpg ) ) ) ) [3] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002IN73UIAT ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001nFxpPIAS ) [Name] => Cluster Energia Coahuila [Website] => www.clusterenergia.org [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => Cluster Energia Coahuila [Sponsor_Website__c] => www.clusterenergia.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/00PC000001R89NbMAJ ) [Id] => 00PC000001R89NbMAJ [Title] => Logo-cluster horizontal.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/00PC000001R889qMAB ) [Id] => 00PC000001R889qMAB [Title] => Cluster Energia-Collaboration proposal.msg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001R89NbMAJ ) [Id] => 00PC000001R89NbMAJ [Title] => Logo-cluster horizontal.jpg ) ) ) ) [4] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002IN63nIAD ) [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/00PC000001R7k5XMAR ) [Id] => 00PC000001R7k5XMAR [Title] => FMN Logo Horz.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/00PC000001R5qnhMAB ) [Id] => 00PC000001R5qnhMAB [Title] => FW 2019 Media Partnership Trade with Fuels Market News.msg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001R7k5XMAR ) [Id] => 00PC000001R7k5XMAR [Title] => FMN Logo Horz.jpg ) ) ) ) [5] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002IN74SIAT ) [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/00PC000001R8B1xMAF ) [Id] => 00PC000001R8B1xMAF [Title] => Gas POWER_white.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/00PC000001R8AphMAF ) [Id] => 00PC000001R8AphMAF [Title] => GasPower.msg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001R8B1xMAF ) [Id] => 00PC000001R8B1xMAF [Title] => Gas POWER_white.jpg ) ) ) ) [6] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuAucAAF ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001SH8DGIA1 ) [Name] => Global Speak Translations [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => Global Speak Translations [Sponsor_Website__c] => www.globalspeaktranslations.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/00P3b00001ViF7GEAV ) [Id] => 00P3b00001ViF7GEAV [Title] => o.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001ViF7GEAV ) [Id] => 00P3b00001ViF7GEAV [Title] => o.jpg ) ) ) ) [7] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002Lu9LdAAJ ) [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/00P3b00001VhR5hEAF ) [Id] => 00P3b00001VhR5hEAF [Title] => ICIS Logo updated.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/00P3b00001VhR5hEAF ) [Id] => 00P3b00001VhR5hEAF [Title] => ICIS Logo updated.jpg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001VjassEAB ) [Id] => 00P3b00001VjassEAB [Title] => Partnership confirmation.pdf ) ) ) ) [8] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002IN64WIAT ) [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/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/00PC000001R7k6aMAB ) [Id] => 00PC000001R7k6aMAB [Title] => NAPE_logo+tagBLACK.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/00PC000001R5s13MAB ) [Id] => 00PC000001R5s13MAB [Title] => AAPL NAPE.msg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001R7k6aMAB ) [Id] => 00PC000001R7k6aMAB [Title] => NAPE_logo+tagBLACK.jpg ) ) ) ) [9] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b000025Qg6WAAS ) [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/mexicogaspriceindex [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/00P3b00001U5saeEAB ) [Id] => 00P3b00001U5saeEAB [Title] => NGI NEW-Rounded-jpeg.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/00P3b00001U5saeEAB ) [Id] => 00P3b00001U5saeEAB [Title] => NGI NEW-Rounded-jpeg.jpg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001U5u6rEAB ) [Id] => 00P3b00001U5u6rEAB [Title] => NGI- Rockies and West-Chicago- New Orleans-San Antonio.pdf ) ) ) ) [10] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBoLmIAL ) [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/00PC000001QnTo4MAF ) [Id] => 00PC000001QnTo4MAF [Title] => NGSA_cmyk.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/00PC000001QnR3sMAF ) [Id] => 00PC000001QnR3sMAF [Title] => Input trades into SF.msg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001QnTnpMAF ) [Id] => 00PC000001QnTnpMAF [Title] => NGSA- CLNG Agreement - SIGNED.pdf ) [2] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001QnTo4MAF ) [Id] => 00PC000001QnTo4MAF [Title] => NGSA_cmyk.jpg ) ) ) ) [11] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002IN71TIAT ) [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/00PC000001R89OAMAZ ) [Id] => 00PC000001R89OAMAZ [Title] => POWER 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/00PC000001R87GFMAZ ) [Id] => 00PC000001R87GFMAZ [Title] => POWER MAG. Media Trades.msg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001R89OAMAZ ) [Id] => 00PC000001R89OAMAZ [Title] => POWER logo.jpg ) ) ) ) [12] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002IN655IAD ) [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/00PC000001R7k7JMAR ) [Id] => 00PC000001R7k7JMAR [Title] => RBN Logo Horz.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/00PC000001R5sHSMAZ ) [Id] => 00PC000001R5sHSMAZ [Title] => RBN Energy.msg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001R7k7JMAR ) [Id] => 00PC000001R7k7JMAR [Title] => RBN Logo Horz.jpg ) ) ) ) [13] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002LuCfIAAV ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0018000000SGTAGAA5 ) [Name] => World Oil [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Sponsor-Trade [Priority__c] => [Sponsorship__c] => World Oil [Sponsor_Website__c] => www.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/00P3b00001VjA00EAF ) [Id] => 00P3b00001VjA00EAF [Title] => wo_logo_jpg_300res.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00P3b00001VjA00EAF ) [Id] => 00P3b00001VjA00EAF [Title] => wo_logo_jpg_300res.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), (SELECT Id, Title FROM CombinedAttachments) FROM Sponsor__c WHERE Event__r.Id IN ('a0DC000000wThISMA0') AND Sponsorship_Type__c IN ('Media Partners','Media Sponsor-Trade') ORDER BY Sponsorship__c, Sponsor_Name__r.Name
stdClass Object ( [totalSize] => 13 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C0000023Bl9DIAS ) [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] => AAPL/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/00PC000001Dre2IMAR ) [Id] => 00PC000001Dre2IMAR [Title] => NAPE_logo+tagBlack.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001Dre2IMAR ) [Id] => 00PC000001Dre2IMAR [Title] => NAPE_logo+tagBlack.jpg ) ) ) ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C0000023BlBOIA0 ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001WDCecIAH ) [Name] => AEM Bilateral Energy Committee [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => AEM Bilateral Energy Committee [Sponsor_Website__c] => www.aem-usa.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/00PC000001Dre5lMAB ) [Id] => 00PC000001Dre5lMAB [Title] => AEM.png ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001Dre5lMAB ) [Id] => 00PC000001Dre5lMAB [Title] => AEM.png ) ) ) ) [2] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C0000023BmiyIAC ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001fgXwkIAE ) [Name] => Asociación Mexicana de Gas Natural (AMGN) [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => Asociación Mexicana de Gas Natural (AMGN) [Sponsor_Website__c] => www.amgn.org.mx [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/00PC000001EApIiMAL ) [Id] => 00PC000001EApIiMAL [Title] => AMGN jpeg.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001EApIiMAL ) [Id] => 00PC000001EApIiMAL [Title] => AMGN jpeg.jpg ) ) ) ) [3] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C0000023Brr0IAC ) [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] => www.fuelsmarketnews.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/00PC000001EaEgxMAF ) [Id] => 00PC000001EaEgxMAF [Title] => FMN Logo Horz.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/00PC000001EaEIBMA3 ) [Id] => 00PC000001EaEIBMA3 [Title] => Fuels Market News-media partner.msg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001EaEgxMAF ) [Id] => 00PC000001EaEgxMAF [Title] => FMN Logo Horz.jpg ) ) ) ) [4] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBG7kIAH ) [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/00PC000001L00iwMAB ) [Id] => 00PC000001L00iwMAB [Title] => Gas POWER_white.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001L00iwMAB ) [Id] => 00PC000001L00iwMAB [Title] => Gas POWER_white.jpg ) ) ) ) [5] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C0000025Om39IAC ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001SH8DGIA1 ) [Name] => Global Speak Translations [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => Global Speak Translations [Sponsor_Website__c] => www.globalspeaktranslations.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/00PC000001HdbcWMAR ) [Id] => 00PC000001HdbcWMAR [Title] => o.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001HdbcWMAR ) [Id] => 00PC000001HdbcWMAR [Title] => o.jpg ) ) ) ) [6] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C0000025P2A1IAK ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001jfW5oIAE ) [Name] => International Society for Mexico Energy [Website] => www.ISMexicoEnergy.org [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => International Society for Mexico Energy [Sponsor_Website__c] => www.ismexicoenergy.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/00PC000001NTyfDMAT ) [Id] => 00PC000001NTyfDMAT [Title] => logo_ISME.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/00PC000001KDnSfMAL ) [Id] => 00PC000001KDnSfMAL [Title] => Add Media Partner to SF.msg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001NTyfDMAT ) [Id] => 00PC000001NTyfDMAT [Title] => logo_ISME.jpg ) ) ) ) [7] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C0000023BlAuIAK ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001a0dCUIAY ) [Name] => Modern Markets Intelligence Inc. dba MMI Inc. [Website] => www.mminews.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => Modern Markets Intelligence Inc. dba MMI Inc. [Sponsor_Website__c] => www.mminews.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/00PC000001DreBoMAJ ) [Id] => 00PC000001DreBoMAJ [Title] => PMT_Logos_2017_hires_v-300x220.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001DreBoMAJ ) [Id] => 00PC000001DreBoMAJ [Title] => PMT_Logos_2017_hires_v-300x220.jpg ) ) ) ) [8] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBL97IAH ) [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] => https://www.naturalgasintel.com/MexicoGasPriceIndex [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/00PC000001LQbpCMAT ) [Id] => 00PC000001LQbpCMAT [Title] => NEW Rounded NGI 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/00PC000001LQaYRMA1 ) [Id] => 00PC000001LQaYRMA1 [Title] => FW DEAL .msg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001LQbpCMAT ) [Id] => 00PC000001LQbpCMAT [Title] => NEW Rounded NGI logo.jpg ) ) ) ) [9] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBG7QIAX ) [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 Partners [Priority__c] => [Sponsorship__c] => POWER Magazine [Sponsor_Website__c] => www.accessintel.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/00PC000001Kzz6nMAB ) [Id] => 00PC000001Kzz6nMAB [Title] => POWER logo.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001Kzz6nMAB ) [Id] => 00PC000001Kzz6nMAB [Title] => POWER logo.jpg ) ) ) ) [10] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C0000025OqtDIAS ) [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 [Sponsor_Website__c] => www.rbnenergy.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/00PC000001Igw46MAB ) [Id] => 00PC000001Igw46MAB [Title] => RBN Logo Horz.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001Igw46MAB ) [Id] => 00PC000001Igw46MAB [Title] => RBN Logo Horz.jpg ) ) ) ) [11] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBRFwIAP ) [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 Partners [Priority__c] => [Sponsorship__c] => South Texas Energy & Economic Roundtable [Sponsor_Website__c] => 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/00PC000001Mwk5eMAB ) [Id] => 00PC000001Mwk5eMAB [Title] => Logo-STEER_spot.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/00PC000001MbjClMAJ ) [Id] => 00PC000001MbjClMAJ [Title] => Steer-media partner.msg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001Mwk5eMAB ) [Id] => 00PC000001Mwk5eMAB [Title] => Logo-STEER_spot.jpg ) ) ) ) [12] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBFZZIA5 ) [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 Partners [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/00PC000001KqPO9MAN ) [Id] => 00PC000001KqPO9MAN [Title] => TAEP color logo.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001KqPO9MAN ) [Id] => 00PC000001KqPO9MAN [Title] => TAEP color 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), (SELECT Id, Title FROM CombinedAttachments) FROM Sponsor__c WHERE Event__r.Id IN ('a0DC000000rlRdzMAE') AND Sponsorship_Type__c IN ('Media Partners','Media Sponsor-Trade') ORDER BY Sponsorship__c, Sponsor_Name__r.Name
stdClass Object ( [totalSize] => 7 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000001pVp2QIAS ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001WDCecIAH ) [Name] => AEM Bilateral Energy Committee [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => AEM Bilateral Energy Committee [Sponsor_Website__c] => www.aem-usa.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/00PC0000016iqqsMAA ) [Id] => 00PC0000016iqqsMAA [Title] => AEM.png ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 2 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC0000016iq7cMAA ) [Id] => 00PC0000016iq7cMAA [Title] => AEM and GlobalSpeak Media Sponsor Confirmation.msg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC0000016iqqsMAA ) [Id] => 00PC0000016iqqsMAA [Title] => AEM.png ) ) ) ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000001pU2DTIA0 ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001a0dEcIAI ) [Name] => CWC Group Limited [Website] => http://www.thecwcgroup.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => CWC Group Limited [Sponsor_Website__c] => http://www.amgn.org.mx/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/00PC000001EApMpMAL ) [Id] => 00PC000001EApMpMAL [Title] => AMGN jpeg.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/00PC0000010bO7uMAE ) [Id] => 00PC0000010bO7uMAE [Title] => 2018_WGC_Logo_HORIZ_Shadow Overprint.jpg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC000001EApMpMAL ) [Id] => 00PC000001EApMpMAL [Title] => AMGN jpeg.jpg ) ) ) ) [2] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000001pVp2uIAC ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001SH8DGIA1 ) [Name] => Global Speak Translations [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => Global Speak Translations [Sponsor_Website__c] => www.globalspeaktranslations.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/00PC0000016iqsZMAQ ) [Id] => 00PC0000016iqsZMAQ [Title] => o.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/00PC0000016iqGJMAY ) [Id] => 00PC0000016iqGJMAY [Title] => AEM and GlobalSpeak Media Sponsor Confirmation.msg ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC0000016iqsZMAQ ) [Id] => 00PC0000016iqsZMAQ [Title] => o.jpg ) ) ) ) [3] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000001pUHCiIAO ) [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/00PC0000011dYdvMAE ) [Id] => 00PC0000011dYdvMAE [Title] => ICIS_Logo.png ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 2 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC0000011dYBSMA2 ) [Id] => 00PC0000011dYBSMA2 [Title] => ICIS -Trade Media Partnership.pdf ) [1] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC0000011dYdvMAE ) [Id] => 00PC0000011dYdvMAE [Title] => ICIS_Logo.png ) ) ) ) [4] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000001pU2DEIA0 ) [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] => https://ipa1.realmagnet.land/mgpi-beta-subscriber-collection-lp [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/00PC0000015XL2rMAG ) [Id] => 00PC0000015XL2rMAG [Title] => MXGPI-Sponsor-Graphic-250x100-v2.png ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC0000015XL2rMAG ) [Id] => 00PC0000015XL2rMAG [Title] => MXGPI-Sponsor-Graphic-250x100-v2.png ) ) ) ) [5] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000001pU2CuIAK ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/0018000000RkWuNAAV ) [Name] => Oildom Publishing Company [Website] => [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => OIldom Publishing Company [Sponsor_Website__c] => https://pgjonline.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/00PC0000010bNjzMAE ) [Id] => 00PC0000010bNjzMAE [Title] => PGJ_-red-full-logo-w-tag_res-ind5-300x109.png ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC0000010bNjzMAE ) [Id] => 00PC0000010bNjzMAE [Title] => PGJ_-red-full-logo-w-tag_res-ind5-300x109.png ) ) ) ) [6] => stdClass Object ( [attributes] => stdClass Object ( [type] => Sponsor__c [url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000001pU2CfIAK ) [Sponsor_Name__r] => stdClass Object ( [attributes] => stdClass Object ( [type] => Account [url] => /services/data/v41.0/sobjects/Account/001C000001a0cJIIAY ) [Name] => Shale Magazine [Website] => www.shalemag.com [Company_Description__c] => ) [Sponsorship_Type__c] => Media Partners [Priority__c] => [Sponsorship__c] => Shale Magazine [Sponsor_Website__c] => http://shalemag.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/00PC0000010bNTNMA2 ) [Id] => 00PC0000010bNTNMA2 [Title] => SHALE_LOGO_tagline_cmyk_tm.jpg ) ) ) [CombinedAttachments] => stdClass Object ( [totalSize] => 1 [done] => 1 [records] => Array ( [0] => stdClass Object ( [attributes] => stdClass Object ( [type] => CombinedAttachment [url] => /services/data/v41.0/sobjects/CombinedAttachment/00PC0000010bNTNMA2 ) [Id] => 00PC0000010bNTNMA2 [Title] => SHALE_LOGO_tagline_cmyk_tm.jpg ) ) ) ) ) )
Special Thanks to our Media & Association Partners below, who have helped us spread the word about the 2023 US-Mexico Natural Gas Forum!