Event Partners
Contact Anastasia Bisson at 530-363-3506 or abisson@accessintel.com to secure a sponsorship for CLEAN PACIFIC 2018
Beverage Station Sponsors
Web Banner Sponsor
Workshop Sponsor
Networking Break Sponsors
Keynote Coffee Sponsor
Registration Desk Sponsors
Industry Sponsor
Badge Sponsor
Water Bottle Sponsor
Track Sponsors
Cell Phone Charging Station Sponsor
Lanyard Sponsor
Media Partners
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 ('a0DC000000sX4u0MAC') AND Sponsorship_Type__c IN ('Media Partners')
ORDER BY 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/a06C0000023BYblIAG
)
[Name] => A-4899
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000dhTcZAAU
)
[Name] => Chamber of Shipping of B.C.
[Website] => https://www.cosbc.ca
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Media Partners
[Priority__c] =>
[Sponsorship__c] =>
[Sponsor_Website__c] => https://bcshippingnews.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/00PC000001D2xMCMAZ
)
[Id] => 00PC000001D2xMCMAZ
[Title] => BCSN-Final-CMYK-2014-FINAL-Hi.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/00PC000001D2xMCMAZ
)
[Id] => 00PC000001D2xMCMAZ
[Title] => BCSN-Final-CMYK-2014-FINAL-Hi.jpg
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
[1] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C0000023BpAdIAK
)
[Name] => A-5004
[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://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/00PC000001EBkGAMA1
)
[Id] => 00PC000001EBkGAMA1
[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/00PC000001EBkGAMA1
)
[Id] => 00PC000001EBkGAMA1
[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/a06C0000023BLgBIAW
)
[Name] => A-4869
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/0018000000iF1zMAAS
)
[Name] => ISCO Industries
[Website] => www.spillcontrol.org
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Media Partners
[Priority__c] =>
[Sponsorship__c] =>
[Sponsor_Website__c] => https://www.spilcontrol.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/00PC000001C5odfMAB
)
[Id] => 00PC000001C5odfMAB
[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/00PC000001C5odfMAB
)
[Id] => 00PC000001C5odfMAB
[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/a06C0000023AxI8IAK
)
[Name] => A-4841
[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/00PC000001B1C2DMAV
)
[Id] => 00PC000001B1C2DMAV
[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/00PC000001B1C2DMAV
)
[Id] => 00PC000001B1C2DMAV
[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/a06C0000023BcarIAC
)
[Name] => A-4912
[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] => www.pacmar.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/00PC000001DQIjWMAX
)
[Id] => 00PC000001DQIjWMAX
[Title] => pmm_logo_tagline.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/00PC000001DQIjWMAX
)
[Id] => 00PC000001DQIjWMAX
[Title] => pmm_logo_tagline.jpg
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
[5] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C0000023BZX1IAO
)
[Name] => A-4901
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/001C000001JfG0wIAF
)
[Name] => Rimbach Publishing Co./Pollution Equipment News
[Website] => www.rimbach.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Media Partners
[Priority__c] =>
[Sponsorship__c] =>
[Sponsor_Website__c] => https://www.pollutionequipmentnews.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/00PC000001D3UjLMAV
)
[Id] => 00PC000001D3UjLMAV
[Title] => PENlogo.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/00PC000001D3UjLMAV
)
[Id] => 00PC000001D3UjLMAV
[Title] => PENlogo.jpg
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
[6] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C0000023BZGUIA4
)
[Name] => A-4900
[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://www.sea-technology.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/00PC000001D3JYVMA3
)
[Id] => 00PC000001D3JYVMA3
[Title] => media_Sea Technology.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/00PC000001D3JYVMA3
)
[Id] => 00PC000001D3JYVMA3
[Title] => media_Sea Technology.jpg
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
[7] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C0000023BlDKIA0
)
[Name] => A-4988
[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] =>
[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/00PC000001DregpMAB
)
[Id] => 00PC000001DregpMAB
[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/00PC000001DregpMAB
)
[Id] => 00PC000001DregpMAB
[Title] => oil-and-gas-online_logo (vert).jpg
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
[8] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C0000023BlDPIA0
)
[Name] => A-4989
[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] =>
[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/00PC000001DrekNMAR
)
[Id] => 00PC000001DrekNMAR
[Title] => 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/00PC000001DrekNMAR
)
[Id] => 00PC000001DrekNMAR
[Title] => pollution_online.jpg
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
[9] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C0000023BlDeIAK
)
[Name] => A-4990
[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] =>
[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/00PC000001DrenvMAB
)
[Id] => 00PC000001DrenvMAB
[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/00PC000001DrenvMAB
)
[Id] => 00PC000001DrenvMAB
[Title] => media_hydrocarbon_online.jpg
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
[10] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C0000025OicLIAS
)
[Name] => A-5060
[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/00PC000001GsD1VMAV
)
[Id] => 00PC000001GsD1VMAV
[Title] => WorkBoat_4c.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/00PC000001GsD1VMAV
)
[Id] => 00PC000001GsD1VMAV
[Title] => WorkBoat_4c.jpg
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
[11] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C0000023BKP5IAO
)
[Name] => A-4863
[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] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => NoteAndAttachment
[url] => /services/data/v41.0/sobjects/NoteAndAttachment/00PC000001C6cTkMAJ
)
[Id] => 00PC000001C6cTkMAJ
[Title] => ECO-BW.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/00PC000001C6cTkMAJ
)
[Id] => 00PC000001C6cTkMAJ
[Title] => ECO-BW.png
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
[12] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C0000023BKOvIAO
)
[Name] => A-4862
[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] => Ocean News & Technology
[Sponsor_Website__c] => https://www.oceannews.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/00PC000001C4sQ6MAJ
)
[Id] => 00PC000001C4sQ6MAJ
[Title] => ONT_Logo_2017_new_blue.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/00PC000001C4sQ6MAJ
)
[Id] => 00PC000001C4sQ6MAJ
[Title] => ONT_Logo_2017_new_blue.png
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
[13] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C0000023BVQcIAO
)
[Name] => A-4889
[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] => Professional Mariner
[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/00PC000001D18ZXMAZ
)
[Id] => 00PC000001D18ZXMAZ
[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/00PC000001D18ZXMAZ
)
[Id] => 00PC000001D18ZXMAZ
[Title] => Professional Mariner (navigator).jpg
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
)
)
Contact Carey Buchholtz at 713-343-1878 or cbuchholtz@accessintel.com to become a media partner
Association Partners
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 ('a0DC000000sX4u0MAC') 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/a06C0000023BedYIAS
)
[Name] => A-4914
[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/00PC000001DRUuVMAX
)
[Id] => 00PC000001DRUuVMAX
[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/00PC000001DRUuVMAX
)
[Id] => 00PC000001DRUuVMAX
[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/a06C0000023BmdPIAS
)
[Name] => A-4997
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/001C000000pKh35IAC
)
[Name] => Clean Rivers Cooperative
[Website] => www.cleanriverscooperative.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Association Partners
[Priority__c] =>
[Sponsorship__c] =>
[Sponsor_Website__c] => https://www.cleanriverscooperative.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/00PC000001E9aV2MAJ
)
[Id] => 00PC000001E9aV2MAJ
[Title] => 2015 Clean Rivers Logo no border.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/00PC000001E9aV2MAJ
)
[Id] => 00PC000001E9aV2MAJ
[Title] => 2015 Clean Rivers Logo no border.jpg
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
[2] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C0000023BlClIAK
)
[Name] => A-4986
[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] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => NoteAndAttachment
[url] => /services/data/v41.0/sobjects/NoteAndAttachment/00PC000001E9aOpMAJ
)
[Id] => 00PC000001E9aOpMAJ
[Title] => InternationalBirdRescue.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/00PC000001E9aOpMAJ
)
[Id] => 00PC000001E9aOpMAJ
[Title] => InternationalBirdRescue.jpg
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
[3] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C0000023BmdZIAS
)
[Name] => A-4998
[Sponsor_Name__r] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Account
[url] => /services/data/v41.0/sobjects/Account/001C000000wFlT5IAK
)
[Name] => Maritime Fire & Safety Association
[Website] => https://www.mfsa.com
[Company_Description__c] =>
)
[Sponsorship_Type__c] => Association Partners
[Priority__c] =>
[Sponsorship__c] =>
[Sponsor_Website__c] => https://www.mfsa.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/00PC000001E9aJQMAZ
)
[Id] => 00PC000001E9aJQMAZ
[Title] => Merchants Exchange 129336 P1 Vector Logo Outlined PROOF.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/00PC000001E9aJQMAZ
)
[Id] => 00PC000001E9aJQMAZ
[Title] => Merchants Exchange 129336 P1 Vector Logo Outlined PROOF.jpg
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
[4] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C0000023BaTGIA0
)
[Name] => A-4907
[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://www.namepa.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/v41.0/sobjects/NoteAndAttachment/00PC000001D45v6MAB
)
[Id] => 00PC000001D45v6MAB
[Title] => NAMEPA 10 Year Logo - High Res.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/00PC000001D45v6MAB
)
[Id] => 00PC000001D45v6MAB
[Title] => NAMEPA 10 Year Logo - High Res.png
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
[5] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => Sponsor__c
[url] => /services/data/v41.0/sobjects/Sponsor__c/a06C0000025OkGlIAK
)
[Name] => A-5068
[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] => stdClass Object
(
[totalSize] => 1
[done] => 1
[records] => Array
(
[0] => stdClass Object
(
[attributes] => stdClass Object
(
[type] => NoteAndAttachment
[url] => /services/data/v41.0/sobjects/NoteAndAttachment/00PC000001HAhCgMAL
)
[Id] => 00PC000001HAhCgMAL
[Title] => scaa logo - color.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/00PC000001HAhCgMAL
)
[Id] => 00PC000001HAhCgMAL
[Title] => scaa logo - color.jpg
[FileType] =>
[FileExtension] =>
[ContentSize] => 0
[RecordType] => Attachment
)
)
)
)
)
)
Contact Carey Buchholtz at 713-343-1878 or cbuchholtz@accessintel.com to become an association partner
Association Partners
Quick Info
Location
Oregon Convention Center
Portland, Oregon
Hall B
Date
June 19-21, 2018
