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,808,6769,6809,6710,1345,6644,6645,550,3184,5996,3131,6381,3561,3580,3554,4140,736,1523,7574,1349,1311,6120,6157,6175,6767,726,7962,7304,4916,4985,6818,4923,8361,8199,8762,4302,5733,8434,9037,8629,8049,9134,9055,7903,3595,1038,4766,748,4635,5247,5247,5764,2160,958,3037,5215,6809,6845,4355,7138,5629,3558,1402,7143,3549,4765,5334,6124,6986,6780,5542,4566,5455,7759,7907,8031,7597,6891,4185,8019,8151,8193,8305,7910,4985,1121,8261,7760,8547,8550,8306,6138,4923,1307,1307,1307,1307,1307,2643,8137,6738,8250,8250,8250,5995,520,5098,4503,8108,7916,4920,4920,4920,4349,7953,7953,7953,6606,6740,7849,5782,358,6658,7962,7953,9300,8354,6715,6312,8519,6312,8519,6832,6984,5371,1726,5371,1726,5371,1726,7976,8128,4716,8128,4716,8303,1777,8303,1777,7067,8303,7067,8303,7067,8303,6394,9350,7916,6127,8497,10211,10304,4716,8129,6740,6740,6740,2998,3402,10316,4923,10318,8970,7849,2039,9737,7966,9976,9972,9524,8686,2635,9791) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC