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 '%170211_PUHope_NFP%'
photo