SELECT id type name shortname linkCover linkCoverBig origName descript

SELECT 
			f.id,
			f.type,
			f.name,
			f.shortname,
			f.linkCover,
			f.linkCoverBig,
			f.origName,
			f.description,
			f.year,
			f.second_year,
			f.budget,
			f.dateCreate,
			f.dateUpdate,
			f.trailerLink,
			f.filmweb_,
			f.duration,
			f.parentalControl,
			g.name AS genre_name,
			g.shortname AS genre_shortname,
			c.name AS country_name,
			c.shortname AS country_shortname,
			(SELECT GROUP_CONCAT(DISTINCT _p.name SEPARATOR ",") FROM catalog_films_people _fp
				LEFT JOIN catalog_people _p ON _p.id=_fp.human_id WHERE (_fp.film_id=f.id) AND (_p.type=0)) AS list_actors,
			(SELECT GROUP_CONCAT(DISTINCT _p.name SEPARATOR ",") FROM catalog_films_people _fp
				LEFT JOIN catalog_people _p ON _p.id=_fp.human_id WHERE (_fp.film_id=f.id) AND (_p.type=1)) AS list_creators,
			(SELECT GROUP_CONCAT(DISTINCT _p.name SEPARATOR ",") FROM catalog_films_people _fp
				LEFT JOIN catalog_people _p ON _p.id=_fp.human_id WHERE (_fp.film_id=f.id) AND (_p.type=2)) AS list_producers,
			(SELECT GROUP_CONCAT(DISTINCT _p.name SEPARATOR ",") FROM catalog_films_people _fp
				LEFT JOIN catalog_people _p ON _p.id=_fp.human_id WHERE (_fp.film_id=f.id) AND (_p.type=3)) AS list_writers
			FROM catalog_films f
			INNER  JOIN catalog_films_genries fg ON fg.film_id=f.id
			INNER  JOIN catalog_films_countries fc ON fc.film_id=f.id
			INNER  JOIN catalog_genries g ON g.id=fg.genre_id
			INNER  JOIN catalog_countries c ON c.id=fc.country_id WHERE (f.isActive=1)  GROUP BY f.id LIMIT 0, 18;