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,1257,4765,1257,4765,5334,4405,3913,3549,3236,2635,5576,6740,2530,6792,510,1349,2389,4338,2766,2944,972,1245,6354,6849,6858,7238,2137,320,1095,2253,6644,1070,6732,5142,5707,6730,5837,7304,1268,4983,4128,3701,6693,6857,6315,252,2253,4099,2244,5657,4401,6962,6364,7303,3046,1000,6190,3244,322,7239,5582,2467,7146,223,5582,7598,7600,1073,5602,464,6633,1029,7631,4079,4432,5678,6671,4349,3595,446,1766,4178,5995,1967,2869,446,5996,4701,8436,8142,1185,2261,1537,6986,6629,8498,8498,3287,6740,7390,446,4178,8514,6163,961,961,698,5454,5582,4362,7004,2986,7304,5371,3428,6740,7238,8220,6190,1095,5995,5995,2029,2029,6891,7592,609,9049,6549,4395,7829,4520,8793,9117,9195,7634,9129,609,1586,4648,9000,7546,6660,7734,8146,9541,9155,8528,8966,4898,7878,7238,223,8436,8220,8171,7094,7713,7647,7647,5454,5454,6740,8063,7160,7548,3511,7716,8577,8610,7655,9300,2263,9354,7903,3913,3913,4739,8780,8780,8290,8290,7833,7910,7910,4796,3712,3712,4094,3389,8435,8435,1988,1988,2384,2384,6740,6740,4230,4230,7261,10228,9830,9674,9674,10482,9389,1142,1142,9387,10738,6548,8741,9975,10666,10907,6548,7261,7286,8229,8371,6971,9377,3029,1349,9810,6642,9545,9835,3549,2164,9929,8539,10240,10002,8765,107,9614,4765,9647,9798,10002,10089,3549,461,10113,2164,9921,7919,1371,10294,10261,6119,9296,10293,186,223,666,7632,10667,10950,10702,10360,10724,1080,7775,322,8305,8780,4535,10451,11130,11394,6898,10821,8820,10974,675,9297,10608,46,2658,11518,1765,9518,1771,8341,9428,8963,2454,7840,9951,9897,9831,9900,5986,9146,9147,9150,4512,9792,5297,810,9523,9892,4639,2976,9049,9463,10292,8169,1371,6646,7592,7554,7754,3287,7754,5070,7756,7927,8509,4510,8162,2033,4234,3241,9805,3327,1769,10938,11219,1768,6613,10985,11123,10002,10212,9830,9359,11069,5484,11497,10339,1993,9866,9977,6740,1589,222,10940,7238,10844,10296,8306,223,7143,2749,11349,6821,7837,8780,10734,2253,10460,10132,9418,4785,3287,11228,2294,1210,923,947,11678,3493,9946,5988,10687,10481,10677,11400,11497,10304,6367,10678,906,4401,906,9603,10676,11403,8970,4144,4923,10940,6733,11263,11432,10703,11799,11637,10717,10522,721,10682,6642,11399,11024) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC