Просмотр поста

а все, отбой, это я тормоз, забыл группировку добавить

SELECT books.*,
         GROUP_CONCAT(DISTINCT `book_genre_key`.`id_genre`
        ORDER BY `book_genre_key`.`id_genre` DESC SEPARATOR ',') AS genres, 
        `book_wish`.`book_id`, `book_wish`.`user_id`
        FROM `books` 
        RIGHT JOIN `book_wish` ON `books`.`id` = `book_wish`.`book_id`
        LEFT JOIN `book_genre_key` ON `books`.`id` = `book_genre_key`.`id_book`
        WHERE `book_wish`.`user_id` = ".app::user()->id()."
         GROUP BY `books`.`id`  ORDER BY `books`.`id` DESC LIMIT 50;