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,857,858,3926,10417,10579,7680,10491,10676,10681,10402,10730,10436,10731,10874,3889,7986,7987,7680,6753,10384,10382,7680,6752,6760,6759,6916,6926,10417,6754,10381,6920,7055,858,860,10488,8156,6759,6762,10649,10417,10487,10488,10813,6754,860,10431,10390,10388,6761,6760,10382,10387,10386,857,6913,7162,6840,6926,6925,9735,10445,6381,6391,6914,6763,6915,9165,8693,8156,8267,7200,7199,7196,7198,7194,10996,10797,7195,6917,6988,6922,8267,10599,10600,10598,9087,10505,11077,10445,11078,11079,6935,11080,10603,11075,6916,6933,6936,11077,3277,6928,6929,6934,7190,7191,7192,6937,6918,6385,673,9178,10597,10593,6421,6423,6920,7042,6424,6425,11103,6426,10486,7055,10389,10426,10428,10381,10957,10222,10264,10421,9176,9177,9190,10167,10384,10420,10425,8987,6491,6417,6517,9692,9854,7680,863,6920,10812,6919,11091,6916,6918,6753,6760,6913,8882,10813,857,6762,11101,6761,10390,10387,10389,8983,8982,6914,10489,10167,368,11559,11099,10388,6988,1990,10386,8633,10387,6925,11325,10390,860,10483,8,4401,10477,8267,6926,6759,8156,11080,9998,10457,10601,6917,5508,860,858,863,6919,6920,857,6913,6918,6753,10384,6919,6917,10384,6753,10387) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC