SELECT DISTINCT af.id, af.name, af.u_name as f_u_name, af.year, ap.name as the_person, ap.id as the_person_id, ap.u_name as the_person_u_name FROM agatti_films af LEFT JOIN agatti_people ap ON ap.id = af.co_director0 WHERE af.active = 1