Workshop Sponsorships

Registration Desk Sponsors

Exhibitor Showcase Theater Sponsors

Private Reception Sponsor

Hurricane Station Sponsor

Aisle Banner Sponsor

Welcome Night Reception 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 ('a0DC000000wUOXvMAO') AND Sponsorship_Type__c IN ('Media Partners')
ORDER BY Sponsorship_Type__c, Sponsorship__c, Sponsor_Name__r.Name

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 ('a0DC000000wUOXvMAO') AND Sponsorship_Type__c IN ('Association Partners')
ORDER BY Sponsorship_Type__c, Sponsorship__c, Sponsor_Name__r.Name