Media & Association Partners – 2023

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 ('a0D3b0000168PpOEAU') AND Sponsorship_Type__c IN ('Media Partners','Media Sponsor-Trade')
						ORDER BY Sponsorship__c, Sponsor_Name__r.Name

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 IN ('Media Partners','Media Sponsor-Trade')
						ORDER BY Sponsorship__c, Sponsor_Name__r.Name

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 ('a0D3b000014mrc4EAA') AND Sponsorship_Type__c IN ('Media Partners','Media Sponsor-Trade')
						ORDER BY Sponsorship__c, Sponsor_Name__r.Name

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 ('a0D3b000013f0UZEAY') AND Sponsorship_Type__c IN ('Media Partners','Media Sponsor-Trade')
						ORDER BY Sponsorship__c, Sponsor_Name__r.Name

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 ('a0DC000000zkO1zMAE') AND Sponsorship_Type__c IN ('Media Partners','Media Sponsor-Trade')
						ORDER BY Sponsorship__c, Sponsor_Name__r.Name