SELECT e.*, p.pName, p.pURL, v.*
FROM colorfield_events e, colorfield_part p, colorfield_venues v
WHERE e.colorfield_event_id=#url.eventid# and e.colorfield_part_id = p.colorfield_part_id and e.colorfield_venue_id = v.colorfield_venue_id
Colorfield remix
