Sponsors – 2022

SELECT 
						Sponsor_Name__r.Name, 
						Sponsor_Name__r.Website, 
						Sponsor_Name__r.Company_Description__c, 
						Sponsorship_Type__c, 
						Priority__c, 
						Sponsorship__c,
						Sponsor_Website__c,
						Sponsor_Contact__c,
						Sponsor_Email__c,
						Sponsor_Phone__c,
						Sponsor_Address__c,
						Company_Description__c,
						(SELECT Id, Title 
							FROM NotesAndAttachments 
							WHERE IsNote = FALSE AND (Title LIKE '%jpg' OR Title LIKE '%gif' OR Title LIKE '%png' OR Title LIKE '%jpeg') 
							ORDER BY CreatedDate DESC LIMIT 1)
						FROM Sponsor__c 
						WHERE Event__r.Id IN ('a0D3b000015otCuEAI') AND Sponsorship_Type__c NOT IN ('Media Partners','Media Sponsor-Trade')
						ORDER BY Sponsorship__c, Sponsor_Name__r.Name
stdClass Object
(
    [totalSize] => 10
    [done] => 1
    [records] => Array
        (
            [0] => stdClass Object
                (
                    [attributes] => stdClass Object
                        (
                            [type] => Sponsor__c
                            [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAGOjAAO
                        )

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

                            [Name] => bp
                            [Website] => www.bp.com
                            [Company_Description__c] => Gas-Natural
                        )

                    [Sponsorship_Type__c] => Sponsor with speaker
                    [Priority__c] => 
                    [Sponsorship__c] => bp
                    [Sponsor_Website__c] => https://www.bp.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/00P3b00001pQb8zEAC
                                                )

                                            [Id] => 00P3b00001pQb8zEAC
                                            [Title] => BP logo.jpeg
                                        )

                                )

                        )

                )

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

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

                            [Name] => Cleveland Advisory LLC
                            [Website] => 
                            [Company_Description__c] => 
                        )

                    [Sponsorship_Type__c] => Supporting Sponsor, Logo Display Only
                    [Priority__c] => 
                    [Sponsorship__c] => Cleveland Advisory
                    [Sponsor_Website__c] => www.clevelandadvisory.com
                    [Sponsor_Contact__c] => 
                    [Sponsor_Email__c] => 
                    [Sponsor_Phone__c] => 
                    [Sponsor_Address__c] => 
                    [Company_Description__c] => 
                    [NotesAndAttachments] => stdClass Object
                        (
                            [totalSize] => 1
                            [done] => 1
                            [records] => Array
                                (
                                    [0] => stdClass Object
                                        (
                                            [attributes] => stdClass Object
                                                (
                                                    [type] => NoteAndAttachment
                                                    [url] => /services/data/v41.0/sobjects/NoteAndAttachment/00P3b00001pQ6RSEA0
                                                )

                                            [Id] => 00P3b00001pQ6RSEA0
                                            [Title] => Cleveland Advisory logo.jpg
                                        )

                                )

                        )

                )

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

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

                            [Name] => ConocoPhillips
                            [Website] => www.conocophillips.com
                            [Company_Description__c] => End-User/Corporate Purchaser
                        )

                    [Sponsorship_Type__c] => Sponsor-Logo Display Only
                    [Priority__c] => 
                    [Sponsorship__c] => ConocoPhillips
                    [Sponsor_Website__c] => http://www.conocophillips.com
                    [Sponsor_Contact__c] => 
                    [Sponsor_Email__c] => 
                    [Sponsor_Phone__c] => 
                    [Sponsor_Address__c] => 
                    [Company_Description__c] => 
                    [NotesAndAttachments] => stdClass Object
                        (
                            [totalSize] => 1
                            [done] => 1
                            [records] => Array
                                (
                                    [0] => stdClass Object
                                        (
                                            [attributes] => stdClass Object
                                                (
                                                    [type] => NoteAndAttachment
                                                    [url] => /services/data/v41.0/sobjects/NoteAndAttachment/00P3b00001pQKwDEAW
                                                )

                                            [Id] => 00P3b00001pQKwDEAW
                                            [Title] => ConocoPhillips.jpg
                                        )

                                )

                        )

                )

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

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

                            [Name] => Enbridge
                            [Website] => www.embridge.com
                            [Company_Description__c] => Gas-Natural
                        )

                    [Sponsorship_Type__c] => Sponsor with speaker
                    [Priority__c] => 
                    [Sponsorship__c] => Enbridge
                    [Sponsor_Website__c] => https://www.enbridge.com/
                    [Sponsor_Contact__c] => 
                    [Sponsor_Email__c] => 
                    [Sponsor_Phone__c] => 
                    [Sponsor_Address__c] => 
                    [Company_Description__c] => 
                    [NotesAndAttachments] => stdClass Object
                        (
                            [totalSize] => 1
                            [done] => 1
                            [records] => Array
                                (
                                    [0] => stdClass Object
                                        (
                                            [attributes] => stdClass Object
                                                (
                                                    [type] => NoteAndAttachment
                                                    [url] => /services/data/v41.0/sobjects/NoteAndAttachment/00P3b00001pQVxjEAG
                                                )

                                            [Id] => 00P3b00001pQVxjEAG
                                            [Title] => Enbridge-Spectra Logo.jpg
                                        )

                                )

                        )

                )

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

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

                            [Name] => Enuit, LLC
                            [Website] => www.enuit.com
                            [Company_Description__c] => 
                        )

                    [Sponsorship_Type__c] => Sponsor with kiosk
                    [Priority__c] => 
                    [Sponsorship__c] => Enuit, LLC
                    [Sponsor_Website__c] => https://www.enuit.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/00P3b00001pQUITEA4
                                                )

                                            [Id] => 00P3b00001pQUITEA4
                                            [Title] => Enuit Logo.jpg
                                        )

                                )

                        )

                )

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

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

                            [Name] => Gas South
                            [Website] => www.gas-south.com
                            [Company_Description__c] => 
                        )

                    [Sponsorship_Type__c] => Sponsor with speaker
                    [Priority__c] => 
                    [Sponsorship__c] => Gas South
                    [Sponsor_Website__c] => https://www.gassouth.com/home
                    [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/00P3b00001pQ4p3EAC
                                                )

                                            [Id] => 00P3b00001pQ4p3EAC
                                            [Title] => Gas South Logo.jpg
                                        )

                                )

                        )

                )

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

                    [Sponsor_Name__r] => stdClass Object
                        (
                            [attributes] => stdClass Object
                                (
                                    [type] => Account
                                    [url] => /services/data/v41.0/sobjects/Account/0013b00001qH0wQAAS
                                )

                            [Name] => Marlin Gas Services
                            [Website] => www.chpk.com
                            [Company_Description__c] => 
                        )

                    [Sponsorship_Type__c] => Sponsor with kiosk
                    [Priority__c] => 
                    [Sponsorship__c] => Marlin Gas Services
                    [Sponsor_Website__c] => https://chpk.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/00P3b00001pQdLhEAK
                                                )

                                            [Id] => 00P3b00001pQdLhEAK
                                            [Title] => MarlinGas-Logo .jpg
                                        )

                                )

                        )

                )

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

                    [Sponsor_Name__r] => stdClass Object
                        (
                            [attributes] => stdClass Object
                                (
                                    [type] => Account
                                    [url] => /services/data/v41.0/sobjects/Account/0013b00001rFOuIAAW
                                )

                            [Name] => Sapphire Gas Solutions
                            [Website] => www.sapphiregassolutions.com
                            [Company_Description__c] => 
                        )

                    [Sponsorship_Type__c] => Sponsor with Speaker & Kiosk
                    [Priority__c] => 
                    [Sponsorship__c] => Sapphire Gas Solutions
                    [Sponsor_Website__c] => https://sapphiregassolutions.com/
                    [Sponsor_Contact__c] => 
                    [Sponsor_Email__c] => 
                    [Sponsor_Phone__c] => 
                    [Sponsor_Address__c] => 
                    [Company_Description__c] => 
                    [NotesAndAttachments] => stdClass Object
                        (
                            [totalSize] => 1
                            [done] => 1
                            [records] => Array
                                (
                                    [0] => stdClass Object
                                        (
                                            [attributes] => stdClass Object
                                                (
                                                    [type] => NoteAndAttachment
                                                    [url] => /services/data/v41.0/sobjects/NoteAndAttachment/00P3b00001pPsTEEA0
                                                )

                                            [Id] => 00P3b00001pPsTEEA0
                                            [Title] => sapphire gas solutions.jpeg
                                        )

                                )

                        )

                )

            [8] => stdClass Object
                (
                    [attributes] => stdClass Object
                        (
                            [type] => Sponsor__c
                            [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAG3ZAAW
                        )

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

                            [Name] => Williams/Sequent Energy Management
                            [Website] => www.williams.com
                            [Company_Description__c] => Gas-Natural
                        )

                    [Sponsorship_Type__c] => Sponsor-Logo Display Only
                    [Priority__c] => 
                    [Sponsorship__c] => Sequent Energy Management/Williams
                    [Sponsor_Website__c] => https://www.williams.com/sequent/
                    [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/00P3b00001pQU4mEAG
                                                )

                                            [Id] => 00P3b00001pQU4mEAG
                                            [Title] => Wiliams-Sequent Energy Management 2021.jpg
                                        )

                                )

                        )

                )

            [9] => stdClass Object
                (
                    [attributes] => stdClass Object
                        (
                            [type] => Sponsor__c
                            [url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002hAFvUAAW
                        )

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

                            [Name] => Williams/Sequent Energy Management
                            [Website] => www.williams.com
                            [Company_Description__c] => Gas-Natural
                        )

                    [Sponsorship_Type__c] => Sponsor with speaker
                    [Priority__c] => 
                    [Sponsorship__c] => Williams/Sequent Energy Management
                    [Sponsor_Website__c] => https://www.williams.com/sequent/
                    [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/00P3b00001pQSIxEAO
                                                )

                                            [Id] => 00P3b00001pQSIxEAO
                                            [Title] => Williams 2021.jpg
                                        )

                                )

                        )

                )

        )

)
bpCleveland AdvisoryConocoPhillipsEnbridgeEnuit, LLCGas SouthMarlin Gas ServicesSapphire Gas SolutionsSequent Energy Management/WilliamsWilliams/Sequent Energy Management