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# style="color:##5e00a6;"style="color:##1f8acd;">#eventType# May #dates# #qGetEvents.eTitle# #qGetEvents.pName# style="color:##5e00a6;"style="color:##1f8acd;">#eventType# June #dates# #qGetEvents.eTitle# #qGetEvents.pName# style="color:##5e00a6;"style="color:##1f8acd;">#eventType# July #dates# #qGetEvents.eTitle# #qGetEvents.pName# style="color:##5e00a6;"style="color:##1f8acd;">#eventType# ^ Back to Top