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 This ColorField remix event looks really interesting. I thought you might like to hear about it:


#getEventDetails.eTitle#
#getEventDetails.pName#
#dates#

#getEventDetails.eDescription#