select `animelist`.`anime_genres`.`id` AS `id`,`animelist`.`anime`.`title` AS `title`,group_concat(' ',`animelist`.`genre`.`name` separator ',') AS `genres` from ((`animelist`.`anime_genres` left join `animelist`.`anime` on(`animelist`.`anime`.`id` = `animelist`.`anime_genres`.`anime_id`)) left join `animelist`.`genre` on(`animelist`.`genre`.`id` = `animelist`.`anime_genres`.`genre_id`)) group by `animelist`.`anime_genres`.`anime_id`