this

MySQL returned error




Error Description :
Error No : 1064
Description : 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 ' is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,act' at line 1

SQL Query
SELECT COUNT(`book`.id) AS CNT FROM `book` WHERE id!=0 AND book.id<>0 and book.active='yes' and city_id!='' and book.id in(0,11756,11805,11806,11777,10410,10411,7368,10449,10965,11332,8202,10406,11629,11628,11767,11653,11634,11884,11839,11553,9508,10811,9821,10891,10768,11844,10399,10400,10401,11794,11630,11893,11864,11778,11793,7632,11459,11460,8740,8459,8424,8474,8568,11516,9875,10575,8211,9609,9610,11626,11034,8415,8743,11035,7661,7662,10302,11862,11840,9053,11674,8460,9398,7079,8462,10577,10675,10272,10275,10575,10629,10630,10906,9743,9508,9562,8034,10007,7077,9261,9564,9581,11059,10689,7108,9580,10855,8087,10854,7153,10965,10887,10881,8046,10888,8086,11034,7279,10890,10506,11211,11035,10507,9443,10508,7261,8364,8644,8961,10404,10449,8057,8368,8443,8050,7289,11276,11061,10509,10274,8472,11331,11411,11278,11065,10511,10889,8767,8207,9738,11367,11536,9057,8414,8474,7150,7666,11210,11674,11668,9148,10941,10943,10947,10942,10623,10944,10624,9821,9956,8450,10945,8468,8646,8428,8415,11630,9997,11262,10946,11760,10625,11712,9095,11211,9957,10573,8929,9744,11335,11841,11839,11840) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC