SELECT e.*, p.pPaid, p.pName, CASE LEFT(pName,4) WHEN 'The ' THEN STUFF(pName, 1, 4, '') ELSE pName END nameWithoutThe FROM colorfield_events e, colorfield_part p WHERE e.colorfield_part_id = p.colorfield_part_id ORDER BY e.eRunDate, e.eEndDate, nameWithoutThe, e.eTitle

	Ongoing Exhibitions Ongoing #qGetEvents.eTitle# #qGetEvents.pName# Exhibit April #dates# #qGetEvents.eTitle# #qGetEvents.pName# #eventType# May #dates# #qGetEvents.eTitle# #qGetEvents.pName# #eventType# June #dates# #qGetEvents.eTitle# #qGetEvents.pName# #eventType# July #dates# #qGetEvents.eTitle# #qGetEvents.pName# #eventType#