Media & Association Partners

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),
						(SELECT Id, Title 
							FROM CombinedAttachments)
						FROM Sponsor__c 
						WHERE Event__r.Id IN ('a0D3b0000168PpTEAU') 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),
						(SELECT Id, Title 
							FROM CombinedAttachments)
						FROM Sponsor__c 
						WHERE Event__r.Id IN ('a0D3b000015otCpEAI') 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),
						(SELECT Id, Title 
							FROM CombinedAttachments)
						FROM Sponsor__c 
						WHERE Event__r.Id IN ('a0D3b000014mrc9EAA') 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),
						(SELECT Id, Title 
							FROM CombinedAttachments)
						FROM Sponsor__c 
						WHERE Event__r.Id IN ('a0D3b000013f0UeEAI') 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),
						(SELECT Id, Title 
							FROM CombinedAttachments)
						FROM Sponsor__c 
						WHERE Event__r.Id IN ('a0DC000000zkNxJMAU') 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),
						(SELECT Id, Title 
							FROM CombinedAttachments)
						FROM Sponsor__c 
						WHERE Event__r.Id IN ('a0DC000000wThISMA0') 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),
						(SELECT Id, Title 
							FROM CombinedAttachments)
						FROM Sponsor__c 
						WHERE Event__r.Id IN ('a0DC000000rlRdzMAE') AND Sponsorship_Type__c IN ('Media Partners','Media Sponsor-Trade')
						ORDER BY Sponsorship__c, Sponsor_Name__r.Name