PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- f.title_ru,
- f.title_en,
- f.time,
- f.year,
- f.description,
- a.name_ru as actor_name_ru,
- d.name_ru as director_name_ru,
- GROUP_CONCAT(DISTINCT a.name_ru),
- GROUP_CONCAT(DISTINCT d.name_ru)
- FROM films f
- LEFT JOIN films_actors fa ON f.id = fa.id_film
- LEFT JOIN actors a ON a.id = fa.id_actor
- LEFT JOIN films_directors fd ON f.id = fd.id_film
- LEFT JOIN directors d ON d.id = fd.id_director
- GROUP BY f.id" ,$db);