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,4598,3913,5516,5732,6557,4411,5322,6255,5331,320,5988,4046,4199,4452,3201,520,585,4432,3933,3440,4987,5020,6863,4233,2025,4805,6553,840,1490,6554,5647,6552,4337,5693,6880,6243,5573,2703,2397,4918,2324,6556,4209,7350,8435,2546,8463,6968,368,7985,7986,535,8832,8782,4037,6869,4798,7592,8917,8034,8240,8948,2913,7599,7521,7485,2261,3201,3888,3895,3892,3885,3891,3889,8272,3883,5609,6493,9300,8877,8274,7294,8839,9072,2737,1173,6174,6905,9437,1487,9438,6650,4121,8257,9439,9373,9459,6100,5,4708,3990,450,539,7501,7491,4316,5298,5003,958,3059,5175,7021,7016,5379,6809,7374,1645,6774,5279,7307,2342,6006,7837,7834,7835,6845,2261,6104,7836,2644,1307,4979,6880,5236,5373,6713,6368,7020,2944,2387,7238,6821,4624,7951,4901,6658,5131,4406,8222,8358,5334,665,6780,2117,3549,2628,446,4765,7840,8556,7879,7878,215,7641,5839,3850,6785,5484,6723,4570,3479,7607,4178,8,7607,8306,6569,8912,9321,217,8305,9988,220,10480,5770,10038,18,9975,10301,8011,8668,1662,4769,6727,6984,6804,10649,5858,10936,10984,10898,10736,11489,9951,6822,10966,5435,9418,10892,10984,11485,10932,6242,11285,11342,7976,11455,10141,11477,9950,11328,11101,10731,11215,10343,10278,947,1207,7641,9655,10505,9533,11289,10566,8169,11272,10687,4779,11226,6004,8109,2342,11303,9389,10909,10339,11900,11363) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC