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 ('a0DC000000wThISMA0') AND Sponsorship_Type__c IN ('Media Partners')
						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/v29.0/sobjects/Sponsor__c/a06C0000023Bl9DIAS
                        )

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

                            [Name] => AAPL/NAPE
                            [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/v29.0/sobjects/NoteAndAttachment/00PC000001Dre2IMAR
                                                )

                                            [Id] => 00PC000001Dre2IMAR
                                            [Title] => NAPE_logo+tagBlack.jpg
                                        )

                                )

                        )

                )

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

                    [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/00PC000001Dre5lMAB
                                                )

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

                                )

                        )

                )

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

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

                                            [Id] => 00PC000001EApIiMAL
                                            [Title] => AMGN jpeg.jpg
                                        )

                                )

                        )

                )

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

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

                                            [Id] => 00PC000001EaEgxMAF
                                            [Title] => FMN Logo Horz.jpg
                                        )

                                )

                        )

                )

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

                    [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/00PC000001HdbcWMAR
                                                )

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

                                )

                        )

                )

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

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

                            [Name] => International Energy Credit Association
                            [Website] => 
                            [Company_Description__c] => 
                        )

                    [Sponsorship_Type__c] => Media Partners
                    [Priority__c] => 
                    [Sponsorship__c] => International Energy Credit Association
                    [Sponsor_Website__c] => www.ieca.net
                    [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/00PC000001Dre9AMAR
                                                )

                                            [Id] => 00PC000001Dre9AMAR
                                            [Title] => IECA LOGO.jpg
                                        )

                                )

                        )

                )

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

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

                                            [Id] => 00PC000001DreBoMAJ
                                            [Title] => PMT_Logos_2017_hires_v-300x220.jpg
                                        )

                                )

                        )

                )

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

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

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

                                            [Id] => 00PC000001Igw46MAB
                                            [Title] => RBN Logo Horz.jpg
                                        )

                                )

                        )

                )

        )

)

Special Thanks to our Media & Association Partners below, who have helped us spread the word about the 2018 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!

AAPL/NAPEAEM Bilateral Energy CommitteeAsociación Mexicana de Gas Natural (AMGN)FMN Media LLCGlobal Speak TranslationsInternational Energy Credit AssociationModern Markets Intelligence Inc. dba MMI Inc.RBN Energy