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)
						FROM Sponsor__c 
						WHERE Event__r.Id IN ('a0DC000000rlRdzMAE') AND Sponsorship_Type__c IN ('Media Partners')
						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/v29.0/sobjects/Sponsor__c/a06C000001pVp2QIAS
                        )

                    [Sponsor_Name__r] => stdClass Object
                        (
                            [attributes] => stdClass Object
                                (
                                    [type] => Account
                                    [url] => /services/data/v29.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/v29.0/sobjects/NoteAndAttachment/00PC0000016iqqsMAA
                                                )

                                            [Id] => 00PC0000016iqqsMAA
                                            [Title] => AEM.png
                                        )

                                )

                        )

                )

            [1] => stdClass Object
                (
                    [attributes] => stdClass Object
                        (
                            [type] => Sponsor__c
                            [url] => /services/data/v29.0/sobjects/Sponsor__c/a06C000001pU2DTIA0
                        )

                    [Sponsor_Name__r] => stdClass Object
                        (
                            [attributes] => stdClass Object
                                (
                                    [type] => Account
                                    [url] => /services/data/v29.0/sobjects/Account/001C000001a0dEcIAI
                                )

                            [Name] => CWC Group Limited
                            [Website] => 
                            [Company_Description__c] => 
                        )

                    [Sponsorship_Type__c] => Media Partners
                    [Priority__c] => 
                    [Sponsorship__c] => CWC Group Limited
                    [Sponsor_Website__c] => http://wgc2018.com/?src=LDCGasForums
                    [Sponsor_Contact__c] => 
                    [Sponsor_Email__c] => 
                    [Sponsor_Phone__c] => 
                    [Sponsor_Address__c] => 
                    [Company_Description__c] => 
                    [NotesAndAttachments] => stdClass Object
                        (
                            [totalSize] => 1
                            [done] => 1
                            [records] => Array
                                (
                                    [0] => stdClass Object
                                        (
                                            [attributes] => stdClass Object
                                                (
                                                    [type] => NoteAndAttachment
                                                    [url] => /services/data/v29.0/sobjects/NoteAndAttachment/00PC0000010bO7uMAE
                                                )

                                            [Id] => 00PC0000010bO7uMAE
                                            [Title] => 2018_WGC_Logo_HORIZ_Shadow Overprint.jpg
                                        )

                                )

                        )

                )

            [2] => stdClass Object
                (
                    [attributes] => stdClass Object
                        (
                            [type] => Sponsor__c
                            [url] => /services/data/v29.0/sobjects/Sponsor__c/a06C000001pVp2uIAC
                        )

                    [Sponsor_Name__r] => stdClass Object
                        (
                            [attributes] => stdClass Object
                                (
                                    [type] => Account
                                    [url] => /services/data/v29.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/v29.0/sobjects/NoteAndAttachment/00PC0000016iqsZMAQ
                                                )

                                            [Id] => 00PC0000016iqsZMAQ
                                            [Title] => o.jpg
                                        )

                                )

                        )

                )

            [3] => stdClass Object
                (
                    [attributes] => stdClass Object
                        (
                            [type] => Sponsor__c
                            [url] => /services/data/v29.0/sobjects/Sponsor__c/a06C000001pUHCiIAO
                        )

                    [Sponsor_Name__r] => stdClass Object
                        (
                            [attributes] => stdClass Object
                                (
                                    [type] => Account
                                    [url] => /services/data/v29.0/sobjects/Account/0018000000dRwzDAAS
                                )

                            [Name] => ICIS
                            [Website] => 
                            [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/v29.0/sobjects/NoteAndAttachment/00PC0000011dYdvMAE
                                                )

                                            [Id] => 00PC0000011dYdvMAE
                                            [Title] => ICIS_Logo.png
                                        )

                                )

                        )

                )

            [4] => stdClass Object
                (
                    [attributes] => stdClass Object
                        (
                            [type] => Sponsor__c
                            [url] => /services/data/v29.0/sobjects/Sponsor__c/a06C000001pU2DEIA0
                        )

                    [Sponsor_Name__r] => stdClass Object
                        (
                            [attributes] => stdClass Object
                                (
                                    [type] => Account
                                    [url] => /services/data/v29.0/sobjects/Account/001C000001HXYOXIA5
                                )

                            [Name] => Natural Gas Intelligence
                            [Website] => 
                            [Company_Description__c] => 
                        )

                    [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/v29.0/sobjects/NoteAndAttachment/00PC0000015XL2rMAG
                                                )

                                            [Id] => 00PC0000015XL2rMAG
                                            [Title] => MXGPI-Sponsor-Graphic-250x100-v2.png
                                        )

                                )

                        )

                )

            [5] => stdClass Object
                (
                    [attributes] => stdClass Object
                        (
                            [type] => Sponsor__c
                            [url] => /services/data/v29.0/sobjects/Sponsor__c/a06C000001pU2CuIAK
                        )

                    [Sponsor_Name__r] => stdClass Object
                        (
                            [attributes] => stdClass Object
                                (
                                    [type] => Account
                                    [url] => /services/data/v29.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/v29.0/sobjects/NoteAndAttachment/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/v29.0/sobjects/Sponsor__c/a06C000001pU2CfIAK
                        )

                    [Sponsor_Name__r] => stdClass Object
                        (
                            [attributes] => stdClass Object
                                (
                                    [type] => Account
                                    [url] => /services/data/v29.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/v29.0/sobjects/NoteAndAttachment/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 2017 US-Mexico Natural Gas Forum!  

Media & Association Partnership Opportunities
Contact Molly Missimer if you’d like to become a Media/Association Partner of the premier events within the natural gas industry!

World Gas Conference 2018 Event Description

AEM Bilateral Energy CommitteeCWC Group LimitedGlobal Speak TranslationsICISNatural Gas IntelligenceOIldom Publishing CompanyShale Magazine