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,7155,8577,8085,7713,8782,9007,3893,543,528,538,8425,788,2023,7174,551,540,8404,532,6382,546,541,553,545,544,536,533,6493,542,531,6031,550,548,8212,8240,8529,7985,8771,547,391,2218,8832,2521,537,526,3881,3894,535,6204,6042,3889,7833,539,7816,8917,529,6788,2573,8274,8271,6650,6880,8273,8462,2521,546,2843,7815,529,542,3883,536,7075,7076,7666,4566,8839,7109,7118,8231,3908,7804,3829,9144,5732,8716,9076,7175,573,3882,7647,540,526,7935,7150,7671,9132,3883,1557,2087,9744,9138,7642,7642,9794,9950,8365,8365,8365,7649,9875,10026,9797,7082,7599,6545,6371,7082,5245,7666,5245,7100,8724,7665,389,7632,9493,9631,9632,6197,7654,9502,9633,9343,8737,4282,9438,6768,8780,9437,1537,2869,7897,3860,7953,9486,9486,5994,3830,6010,6880,4087,9156,8925,9192,9143,365,368,386,391,6076,382,5994,9191,8899,5389,9951,3890,1894,3890,1894,1895,7194,545,540,5669,542,5669,542,5445,549,5445,549,2923,9177,548,2703,5810,5368,7246,8111,9747,8368,7292,8212,7069,9933,5052,5052,8743,9400,9205,9205,5066,5066,8885,7671,4019,10272,7653,9844,8410,8071,9739,8404,130,10510,9563,8204,9539,5961,458,9399,9444,9148,8370,8651,8450,7277,9443,8637,6181,10623,9367,9056,8373,10026,2761,10029,9445,9447,9083,9719,8438,10095,3073,3071,10247,6689,4701,7647,10053,9665,10212,7753,7752,8088,1257,8627,9277,3428,9037,9679,1616,7239,6688,8944,1215,7881,9647,9867,7281,6537,446,10056,6534,6535,6506,10008,5386,9259,4765,10342,9133,8946,9132,10347,10541,9383,9370,7659,7251,8400,10615,10672,10232,8402,10228,9303,8403,9383,240,7662,10741,7080,8891,8251,51,5994,10275,10814,10552,5053,10738,10673,10910,9389,10820,10836,8208,1303,6894,10267,10976,10975,8441,10649,9609,9889,10483,7953,3908,11024,7917,11010) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC