<!-- mycco -->
  
SELECT eventID, eventTitle, occurence, eventDate, startTime, endTime, eventLocation, eventDetails, mapLink, 
					acceptRSVPs, rsvpDeadline, firstname, surname, preferredNumber, mobileNumber, homePhoneValue, businessNumber, faxNumber, 
					eventContact, eventContactPhone, eventContactEmail FROM events 
					LEFT JOIN event_dates ON event_dates.eventIDLookup=events.eventID
					LEFT JOIN event_recurring_details ON event_recurring_details.eventIDLookup=events.eventID 
					LEFT JOIN members ON events.eventContact=members.memberID
					LEFT JOIN member_home_phone ON member_home_phone.homePhoneID=members.homePhoneLookup 
					WHERE events.clientID=6 AND event_dates.recordKey='M9L065XV3D0D3AC6LII51Y13A5XEX634SK1T99GC83ZXWC7OSWTD4G9J3H2S1WOP'