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,5516,1425,5915,446,4788,2451,5995,5371,1145,1681,1485,5719,6316,375,386,6082,377,7076,7094,7118,7072,7124,7113,7150,7109,7246,254,1572,1981,6140,2035,382,1973,1108,391,6826,6383,4316,5298,5003,958,3059,5175,7021,7016,5379,6809,7374,1645,6774,5279,7307,2342,4574,6006,7837,7834,7835,6845,2261,6104,7836,2644,4979,6880,5236,5373,6713,6368,7020,2944,2387,7238,6821,4624,7951,4901,6658,5131,4406,8222,6631,7913,7913,6138,4923,8024,2643,8137,6738,8250,8250,8250,5995,520,5098,4503,8108,7916,4920,4920,4920,4349,7953,7953,7953,6606,2594,4234,5070,4834,8047,8047,7069,6646,6984,6984,8287,6394,6940,215,4432,4094,6787,4095,1385,7350,7350,7350,7350,7350,1887,7539,7539,7539,7539,7539,7539,7539,7539,7539,7539,7419,7419,7419,5898,5898,5439,7095,4503,4503,4503,7388,7388,9442,9189,9508,9508,9508,7541,7541,7541,7747,9995,9508,9978,10272,9659,8449,10024,8892,8468,8892,8468,10026,9189,8425,8386,8783,10890,8783,10614,9229,5988,9581,10575,9649,10357,11187,10890,11712,10890,11712,10400,11711,10400,11711,3197,2156,8554,5962,7872,6810,8292,9394,9504,9525,4338,7023,7632,7815,9647,6172,9379,9732,8389,7966,18,9046,2384,2889,41,9897,9758,6725,8110,9864,9814,8995,8714,9754,9532,9468,9467,9506,7222,10174,10085,123,10173,10143,10035,2171,10040,8434,10054,9972,8112,6631,6740,1380,7241,7241,7241,6561,6561,7912,7117,7117,8832,666,7085,9049,9049,9049,9049,9908,5770,6970,7459,10402,9258,10914,10039,11028,11126,9116,9900,7219,10904,11314,11443,10305,10666,7159,5098,1974,1726,4923,9856,9488,10301,8650,8130,10316,8130,10316,226,4923,11101,11215,11101,11215,11497,10579,5435,10731,5435,10731) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC