SELECT l.imagefilename as locimagefilename, e.imagefilename as evtimagefilename,e.event_id as evtid, e.*, l.* FROM events e join locations l on e.location_id = l.location_id where e.dirname1 like '%8_29_2013-7_47_09-PM.Photos%'
photo