Форум пользователей MySQL

/****  Запрос выборки  ****/
SELECT book.id as id, book.title as title, book.price as price, book.desc as `desc`, group_concat(DISTINCT auth.author) as authots, group_concat(DISTINCT ganre.ganre) as ganres FROM `books` as book 
left join `author_to_book` as auth_to ON book.id = auth_to.id_bta
left join `author` as auth ON auth_to.id_atb = auth.id_author
left join `ganre_to_book` as ganre_to ON book.id = ganre_to.id_btg
left join `ganre` as ganre ON ganre_to.id_gtb = ganre.id_ganre
where book.id IN (SELECT book.id FROM `books` as book
left join `author_to_book` as auth_to ON book.id = auth_to.id_bta
left join `author` as auth ON auth_to.id_atb = auth.id_author
left join `ganre_to_book` as ganre_to ON book.id = ganre_to.id_btg
left join `ganre` as ganre ON ganre_to.id_gtb = ganre.id_ganre
where ganre.ganre like '%$sGanre%' and auth like '%$sAuth%' and book.title like '%sTitle%' and `book`.`desc` like '$sDesc'
group by book.title) group by book.title
/****  !Запрос выборки  ****/

Собственно входные данные вот (where ganre.ganre like '%$sGanre%' and auth like '%$sAuth%' and book.title like '%sTitle%' and `book`.`desc` like '$sDesc')

вот что у меня получилось

CREATE PROCEDURE `getBook`(sTitle VARCHAR(255),sGanre VARCHAR(255),sAuth VARCHAR(255),sDesc VARCHAR(255),
OUT oId INT,OUT  oTitle VARCHAR(255),OUT  oPrice DECIMAL,OUT  oGanres VARCHAR(1000),OUT  oAuthots VARCHAR(1000),OUT  oDesc TEXT)
BEGIN
    SELECT book.id INTO oId, book.title INTO oTitle, book.price INTO oPrice, book.desc INTO oDesc, group_concat(DISTINCT auth.author) INTO oAuthots, group_concat(DISTINCT ganre.ganre) INTO oGanres FROM `books` as book 
    left join `author_to_book` as auth_to ON book.id = auth_to.id_bta
    left join `author` as auth ON auth_to.id_atb = auth.id_author
    left join `ganre_to_book` as ganre_to ON book.id = ganre_to.id_btg
    left join `ganre` as ganre ON ganre_to.id_gtb = ganre.id_ganre
    where book.id IN (SELECT book.id FROM `books` as book
    left join `author_to_book` as auth_to ON book.id = auth_to.id_bta
    left join `author` as auth ON auth_to.id_atb = auth.id_author
    left join `ganre_to_book` as ganre_to ON book.id = ganre_to.id_btg
    left join `ganre` as ganre ON ganre_to.id_gtb = ganre.id_ganre
    where ganre.ganre like sGanre and auth like sAuth and book.title like sTitle and `book`.`desc` like sDesc
    group by book.title) group by book.title;
END;

естессно не работает, выдает  #1327 - Undeclared variable: book

базку прикрепил.

---

Прикрепленные файлы:
book_store2.sql, Размер: 2,869 байт, Скачано: 9,437