図書目録
図書目録
MYSQLでエラーが発生しました.
SELECT b.bookid, b.title, b.subtitle, b.revision, b.seriese, b.seriese_num, b.price, b.author, b.translator, b.isbn13, b.isbn10, b.date, b.type, r.date release_date, c.cate_code, c.lcls_code, c.mcls_code, c.scls_code, cm.category, cm.l_class, cm.m_class, cm.s_class, cm.s_class FROM book_category_master c INNER JOIN book_master b USING(bookid) INNER JOIN book_adv a USING(bookid) INNER JOIN release_info r USING(bookid) INNER JOIN stock_status_list_all s USING(bookid) INNER JOIN category_master cm ON c.scls_code = cm.scls_code WHERE c.cate_code = '47' AND (r.item = '発売日' OR r.item = '既刊') AND r.status > 0 AND a.catalogue != 0 AND s.status <= '32' ORDER BY c.cate_code, c.lcls_code, c.mcls_code, c.scls_code, bookid DESC LIMIT -20, 20;
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 10