Event Sponsors
Contact Anastasia Bisson at 530-363-3506 or abisson@accessintel.com to secure a sponsorship for CLEAN PACIFIC 2019
Corporate Sponsors
Industry Sponsor
Water Demo Sponsor
Lunch Sponsor
Keynote Sponsorship
Lanyard Sponsor
Cell Phone Charging Station Sponsor
Reception Sponsor
Track Sponsors
Beverage Station Sponsor
Networking Break Sponsor
Bag Insert Sponsor
Half-Day Workshop Sponsor
Badge Recycling Sponsor
Media Sponsors
SELECT
Name,
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, FileType, FileExtension, ContentSize, RecordType
FROM CombinedAttachments
WHERE Title LIKE '%jp%g' OR Title LIKE '%gif' OR Title LIKE '%png' OR FileType IN ('JPG', 'GIF', 'PNG')
ORDER BY CreatedDate DESC LIMIT 1)
FROM Sponsor__c
WHERE Event__r.Id IN ('a0DC000000zjccAMAQ') AND Sponsorship_Type__c IN ('Media Partners')
ORDER BY Sponsorship_Type__c, Sponsorship__c, Sponsor_Name__r.NamestdClass Object
(
[totalSize] => 14
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBhUhIAL
)
[Name] => A-5204
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/001C000001N4tIoIAJ
)
[Name] => BC Shipping News
[Website] =>
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Media Partners
[Priority__c] =>
[Sponsorship__c] =>
[Sponsor_Website__c] => https://www.bcshippingnews.com/
[Sponsor_Contact__c] =>
[Sponsor_Email__c] =>
[Sponsor_Phone__c] =>
[Sponsor_Address__c] =>
[Company_Description__c] =>
[NotesAndAttachments] =>
[CombinedAttachments] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/069C0000006G4rGIAS
)
[Id] => 069C0000006G4rGIAS
[Title] => BCSN-2019-FINAL-RGB-WEB
[FileType] => JPG
[FileExtension] => jpg
[ContentSize] => 77333
[RecordType] => File
)
)
)
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBWmOIAX
)
[Name] => A-5187
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000P8mP7AAJ
)
[Name] => Cleanupoil.com
[Website] => www.cleanupoil.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Media Partners
[Priority__c] =>
[Sponsorship__c] =>
[Sponsor_Website__c] => https://www.cleanupoil.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/00PC000001NozE5MAJ
)
[Id] => 00PC000001NozE5MAJ
[Title] => Cleanupoil 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/00PC000001NozE5MAJ
)
[Id] => 00PC000001NozE5MAJ
[Title] => Cleanupoil logo.jpg
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
[2] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBWmYIAX
)
[Name] => A-5189
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000P8mPZAAZ
)
[Name] => International Spill Control Organization
[Website] =>
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Media Partners
[Priority__c] =>
[Sponsorship__c] =>
[Sponsor_Website__c] => https://www.spillcontrol.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/00PC000001NozQmMAJ
)
[Id] => 00PC000001NozQmMAJ
[Title] => Media_ISCO.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/00PC000001NozQmMAJ
)
[Id] => 00PC000001NozQmMAJ
[Title] => Media_ISCO.jpg
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
[3] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBWmdIAH
)
[Name] => A-5190
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000iF2CyAAK
)
[Name] => Marine Log
[Website] =>
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Media Partners
[Priority__c] =>
[Sponsorship__c] =>
[Sponsor_Website__c] => https://www.marinelog.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/00PC000001NozSYMAZ
)
[Id] => 00PC000001NozSYMAZ
[Title] => marine log.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/00PC000001NozSYMAZ
)
[Id] => 00PC000001NozSYMAZ
[Title] => marine log.jpg
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
[4] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002IN6kuIAD
)
[Name] => A-5265
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/001C000001WDCnqIAH
)
[Name] => Marine News
[Website] =>
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Media Partners
[Priority__c] =>
[Sponsorship__c] =>
[Sponsor_Website__c] => https://magazines.marinelink.com/Magazines/MarineNews
[Sponsor_Contact__c] =>
[Sponsor_Email__c] =>
[Sponsor_Phone__c] =>
[Sponsor_Address__c] =>
[Company_Description__c] =>
[NotesAndAttachments] =>
[CombinedAttachments] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/069C0000006G9YJIA0
)
[Id] => 069C0000006G9YJIA0
[Title] => MN_Logo_Large1350x450
[FileType] => JPG
[FileExtension] => jpg
[ContentSize] => 191097
[RecordType] => File
)
)
)
)
[5] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBWmTIAX
)
[Name] => A-5188
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000ivS36AAE
)
[Name] => Navigator Publishing
[Website] => www.professionalmariner.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Media Partners
[Priority__c] =>
[Sponsorship__c] =>
[Sponsor_Website__c] => https://www.professionalmariner.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/00PC000001NozK3MAJ
)
[Id] => 00PC000001NozK3MAJ
[Title] => Professional Mariner (navigator).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/00PC000001NozK3MAJ
)
[Id] => 00PC000001NozK3MAJ
[Title] => Professional Mariner (navigator).jpg
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
[6] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002IN8UXIA1
)
[Name] => A-5300
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/001C000001gabJaIAI
)
[Name] => Pacific Maritime Magazine
[Website] =>
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Media Partners
[Priority__c] =>
[Sponsorship__c] =>
[Sponsor_Website__c] => https://www.pacmar.com/
[Sponsor_Contact__c] =>
[Sponsor_Email__c] =>
[Sponsor_Phone__c] =>
[Sponsor_Address__c] =>
[Company_Description__c] =>
[NotesAndAttachments] =>
[CombinedAttachments] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/069C0000006HEbKIAW
)
[Id] => 069C0000006HEbKIAW
[Title] => pmm_logo_tagline
[FileType] => JPG
[FileExtension] => jpg
[ContentSize] => 139687
[RecordType] => File
)
)
)
)
[7] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBiGyIAL
)
[Name] => A-5212
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000SGSq8AAH
)
[Name] => Sea Technology Magazine
[Website] => www.sea-technology.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Media Partners
[Priority__c] =>
[Sponsorship__c] =>
[Sponsor_Website__c] => https://sea-technology.com/
[Sponsor_Contact__c] =>
[Sponsor_Email__c] =>
[Sponsor_Phone__c] =>
[Sponsor_Address__c] =>
[Company_Description__c] =>
[NotesAndAttachments] =>
[CombinedAttachments] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/069C00000063CrcIAE
)
[Id] => 069C00000063CrcIAE
[Title] => media_Sea Technology
[FileType] => JPG
[FileExtension] => jpg
[ContentSize] => 464706
[RecordType] => File
)
)
)
)
[8] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBWmnIAH
)
[Name] => A-5191
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000PSIiWAAX
)
[Name] => WorkBoat Magazine
[Website] => www.workboat.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Media Partners
[Priority__c] =>
[Sponsorship__c] =>
[Sponsor_Website__c] => https://www.workboat.com/magazine/
[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/00PC000001NozSnMAJ
)
[Id] => 00PC000001NozSnMAJ
[Title] => WorkBoat_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/00PC000001NozSnMAJ
)
[Id] => 00PC000001NozSnMAJ
[Title] => WorkBoat_logo.jpg
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
[9] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBdCCIA1
)
[Name] => A-5194
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000ld3fUAAQ
)
[Name] => World Oils
[Website] =>
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Media Partners
[Priority__c] =>
[Sponsorship__c] =>
[Sponsor_Website__c] => https://www.worldoils.com/
[Sponsor_Contact__c] =>
[Sponsor_Email__c] =>
[Sponsor_Phone__c] =>
[Sponsor_Address__c] =>
[Company_Description__c] =>
[NotesAndAttachments] =>
[CombinedAttachments] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/069C0000005oMMuIAM
)
[Id] => 069C0000005oMMuIAM
[Title] => wo_logo_jpg_300res
[FileType] => JPG
[FileExtension] => jpg
[ContentSize] => 112267
[RecordType] => File
)
)
)
)
[10] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBhUXIA1
)
[Name] => A-5203
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000SGSEVAA5
)
[Name] => TSC Publishing
[Website] => www.tscpublishing.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Media Partners
[Priority__c] =>
[Sponsorship__c] => ECO Magazine
[Sponsor_Website__c] => https://www.ecomagazine.com/
[Sponsor_Contact__c] =>
[Sponsor_Email__c] =>
[Sponsor_Phone__c] =>
[Sponsor_Address__c] =>
[Company_Description__c] =>
[NotesAndAttachments] =>
[CombinedAttachments] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/069C00000062cRTIAY
)
[Id] => 069C00000062cRTIAY
[Title] => ECO-BW
[FileType] => PNG
[FileExtension] => png
[ContentSize] => 261219
[RecordType] => File
)
)
)
)
[11] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBWmEIAX
)
[Name] => A-5185
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000iF9oqAAC
)
[Name] => Vert Markets
[Website] =>
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Media Partners
[Priority__c] =>
[Sponsorship__c] => Hydrocarbon Online
[Sponsor_Website__c] => https://www.hydrocarbononline.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/00PC000001Noz6LMAR
)
[Id] => 00PC000001Noz6LMAR
[Title] => media_hydrocarbon_online.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/00PC000001Noz6LMAR
)
[Id] => 00PC000001Noz6LMAR
[Title] => media_hydrocarbon_online.jpg
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
[12] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBWmJIAX
)
[Name] => A-5186
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000iF9oqAAC
)
[Name] => Vert Markets
[Website] =>
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Media Partners
[Priority__c] =>
[Sponsorship__c] => Oil and Gas Online
[Sponsor_Website__c] => https://www.oilandgasonline.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/00PC000001Noz7sMAB
)
[Id] => 00PC000001Noz7sMAB
[Title] => oil-and-gas-online_logo (vert).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/00PC000001Noz7sMAB
)
[Id] => 00PC000001Noz7sMAB
[Title] => oil-and-gas-online_logo (vert).jpg
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
[13] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBWm4IAH
)
[Name] => A-5184
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000iF9oqAAC
)
[Name] => Vert Markets
[Website] =>
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Media Partners
[Priority__c] =>
[Sponsorship__c] => Pollution Online
[Sponsor_Website__c] => https://www.pollutiononline.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/00PC000001Noz4KMAR
)
[Id] => 00PC000001Noz4KMAR
[Title] => media_pollution-online.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/00PC000001Noz4KMAR
)
[Id] => 00PC000001Noz4KMAR
[Title] => media_pollution-online.jpg
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
)
)
Contact Carey Buchholtz at 713-343-1878 or cbuchholtz@accessintel.com to become a media partner
Association Sponsors
SELECT
Name,
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, FileType, FileExtension, ContentSize, RecordType
FROM CombinedAttachments
WHERE Title LIKE '%jp%g' OR Title LIKE '%gif' OR Title LIKE '%png' OR FileType IN ('JPG', 'GIF', 'PNG')
ORDER BY CreatedDate DESC LIMIT 1)
FROM Sponsor__c
WHERE Event__r.Id IN ('a0DC000000zjccAMAQ') AND Sponsorship_Type__c IN ('Association Partners')
ORDER BY Sponsorship_Type__c, Sponsorship__c, Sponsor_Name__r.NamestdClass Object
(
[totalSize] => 6
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBWlzIAH
)
[Name] => A-5183
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000dhTdmAAE
)
[Name] => American Salvage Association
[Website] => www.americansalvage.org
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Association Partners
[Priority__c] =>
[Sponsorship__c] =>
[Sponsor_Website__c] => https://www.americansalvage.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/00PC000001NoyzjMAB
)
[Id] => 00PC000001NoyzjMAB
[Title] => ASA-2014-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/00PC000001NoyzjMAB
)
[Id] => 00PC000001NoyzjMAB
[Title] => ASA-2014-Logo.jpg
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBhMwIAL
)
[Name] => A-5202
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/001C000001iukOWIAY
)
[Name] => Apicom
[Website] =>
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Association Partners
[Priority__c] =>
[Sponsorship__c] =>
[Sponsor_Website__c] => https://www.apicom.org/
[Sponsor_Contact__c] =>
[Sponsor_Email__c] =>
[Sponsor_Phone__c] =>
[Sponsor_Address__c] =>
[Company_Description__c] =>
[NotesAndAttachments] =>
[CombinedAttachments] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/069C00000062X9ZIAU
)
[Id] => 069C00000062X9ZIAU
[Title] => APICOM_Logo2
[FileType] => JPG
[FileExtension] => jpg
[ContentSize] => 372388
[RecordType] => File
)
)
)
)
[2] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002Jdd9kAAB
)
[Name] => A-5379
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000PSIh1AAH
)
[Name] => International Bird Rescue
[Website] => www.bird-rescue.org
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Association Partners
[Priority__c] =>
[Sponsorship__c] =>
[Sponsor_Website__c] => https://www.bird-rescue.org/
[Sponsor_Contact__c] =>
[Sponsor_Email__c] =>
[Sponsor_Phone__c] =>
[Sponsor_Address__c] =>
[Company_Description__c] =>
[NotesAndAttachments] =>
[CombinedAttachments] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/0693b000004DuNhAAK
)
[Id] => 0693b000004DuNhAAK
[Title] => InternationalBirdRescue
[FileType] => JPG
[FileExtension] => jpg
[ContentSize] => 980858
[RecordType] => File
)
)
)
)
[3] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002IN6hHIAT
)
[Name] => A-5263
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000fAN10AAG
)
[Name] => North American Marine Environmental Protection
[Website] => www.morganmarketcomm.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Association Partners
[Priority__c] =>
[Sponsorship__c] =>
[Sponsor_Website__c] => https://namepa.net/
[Sponsor_Contact__c] =>
[Sponsor_Email__c] =>
[Sponsor_Phone__c] =>
[Sponsor_Address__c] =>
[Company_Description__c] =>
[NotesAndAttachments] =>
[CombinedAttachments] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/069C0000006G6bPIAS
)
[Id] => 069C0000006G6bPIAS
[Title] => NAMEPA 10+ logo
[FileType] => JPG
[FileExtension] => jpg
[ContentSize] => 328705
[RecordType] => File
)
)
)
)
[4] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C000002BBbyDIAT
)
[Name] => A-5193
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/001C0000012dvD6IAI
)
[Name] => SCAA
[Website] => www.scaa-spill.org
[Company_Description__c] => The Spill Control Association of America was organized in 1973 to actively promote the interests of all groups within the spill response community. Our organization represents spill response contractors, manufacturers, distributors, consultants, instructors, government & training institutions and corporations working in the industry.
)
[Sponsorship_Type__c] => Association Partners
[Priority__c] =>
[Sponsorship__c] =>
[Sponsor_Website__c] => https://www.scaa-spill.org/
[Sponsor_Contact__c] =>
[Sponsor_Email__c] =>
[Sponsor_Phone__c] =>
[Sponsor_Address__c] =>
[Company_Description__c] =>
[NotesAndAttachments] =>
[CombinedAttachments] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/069C0000005nPnWIAU
)
[Id] => 069C0000005nPnWIAU
[Title] => SCAA LOGO-FINAL
[FileType] => JPG
[FileExtension] => jpg
[ContentSize] => 607539
[RecordType] => File
)
)
)
)
[5] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a063b00002JdfISAAZ
)
[Name] => A-5395
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/001C000001IBvSIIA1
)
[Name] => The Canadian Emergency Response Contractors’ Alliance (CERCA)
[Website] => https://WWW.CERCA-ACEIU.CA
[Company_Description__c] => The Canadian Emergency Response Contractors’ Alliance (CERCA) is an industry association comprised of stakeholders from all facets of the Canadian dangerous goods emergency response industry. The mission of CERCA is to foster the establishment of a sound emergency response network in Canada.
The Task Force was comprised of members from: Chemisty Industry Association of Canada – CIAC (formerly known as CCPA), Transport Canada, railway carriers such as Canadian Pacific Railway and Canadian National Railway, as well as many emergency response contractors across Canada. Other organizations that joined the Task Force include: Canadian Fertilizer Institute, Canadian Trucking Alliance, and Canadian Association of Chemical Distributors, and the Railway Association of Canada.
)
[Sponsorship_Type__c] => Association Partners
[Priority__c] =>
[Sponsorship__c] =>
[Sponsor_Website__c] => https://www.cerca-aceiu.ca/
[Sponsor_Contact__c] =>
[Sponsor_Email__c] =>
[Sponsor_Phone__c] =>
[Sponsor_Address__c] =>
[Company_Description__c] =>
[NotesAndAttachments] =>
[CombinedAttachments] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => CombinedAttachment
[url] => /services/data/v41.0/sobjects/CombinedAttachment/0693b000006qSrWAAU
)
[Id] => 0693b000006qSrWAAU
[Title] => CERCA-logo
[FileType] => JPG
[FileExtension] => jpg
[ContentSize] => 100444
[RecordType] => File
)
)
)
)
)
)
Contact Carey Buchholtz at 713-343-1878 or cbuchholtz@accessintel.com to become an association partner
Quick Info
Location
Hyatt Regency Vancouver
Convention Level (Level 3)
Vancouver, British Columbia
Register to Attend
How to Exhibit
How to Sponsor
Registration and Pricing
