select `raivis`.`film`.`film_id` AS `FID`,`raivis`.`film`.`title` AS `title`,`raivis`.`film`.`description` AS `description`,`raivis`.`category`.`name` AS `category`,`raivis`.`film`.`rental_rate` AS `price`,`raivis`.`film`.`length` AS `length`,`raivis`.`film`.`rating` AS `rating`,group_concat(concat(concat(ucase(substr(`raivis`.`actor`.`first_name`,1,1)),lcase(substr(`raivis`.`actor`.`first_name`,2,octet_length(`raivis`.`actor`.`first_name`))),' ',concat(ucase(substr(`raivis`.`actor`.`last_name`,1,1)),lcase(substr(`raivis`.`actor`.`last_name`,2,octet_length(`raivis`.`actor`.`last_name`)))))) separator ', ') AS `actors` from ((((`raivis`.`film` left join `raivis`.`film_category` on(`raivis`.`film_category`.`film_id` = `raivis`.`film`.`film_id`)) left join `raivis`.`category` on(`raivis`.`category`.`category_id` = `raivis`.`film_category`.`category_id`)) left join `raivis`.`film_actor` on(`raivis`.`film`.`film_id` = `raivis`.`film_actor`.`film_id`)) left join `raivis`.`actor` on(`raivis`.`film_actor`.`actor_id` = `raivis`.`actor`.`actor_id`)) group by `raivis`.`film`.`film_id`,`raivis`.`category`.`name`