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