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,6561,6006,6000,1425,6658,3555,6595,5995,1591,6587,6583,6978,6962,6586,6588,7019,2145,6120,6103,6264,1558,2473,6710,7258,6445,7093,501,6713,7166,2658,6098,7871,4209,3904,6785,3604,3595,8349,8537,8342,8620,8620,8683,6583,2992,7753,8514,9104,5052,8088,4652,8413,9339,9130,9348,9563,9579,8053,9539,9366,223,6971,10212,9741,10307,3904,8739,10513,9945,10691,10690,10689,10588,9054,7675,8910,10629,11025,9198,9162,1232,11222,36,8358,223,7374,9125,5484,8780,6891,8255,6642,9340,6367,4801,9300,1349,4450,3784,4259,3531,5400,4405,2658,6855,222,6740,4259,3784,4450,8358,10627,6010,2033,10056,8535,2932,4639,9603,10836,7738,1666,3784,4450,11101,5371,3783,4259,4535,3428,7374,9340,8491,4395,2389,2399,4519,5602,7374,10649,8683,5070,10649,10764,10892,8714,2594,5484,10257,1398,2594,11402,11497,10257,11324,11315,11281,11497,8491,6174,8296,2925,7634,4834,8142,8617,1974,1993,1974,1993,7840,7879,7840,7879,6728,587,6728,587,8683,1308,8683,1308,6770,9403,7048,7847,3926,450,2627,2628,4178,8565,8831,4716,9865,4716,9865,3913,6869,3913,6869,3913,6869,576,5484,3879,3893,3883,3882,8389,8389,8389,8389,3897,3883,9342,10554,510,512,8628,10907,8628,10907,10956,8115,11215,11216) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC