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,7152,7087,7116,7505,7437,7385,7292,7247,7101,7387,7241,7472,7251,7422,7422,7384,7499,3863,6658,6969,1302,1302,7460,1776,1993,8966,8481,8481,8833,9667,9667,6548,6548,9529,9148,9259,7288,7288,7288,7288,7288,3327,8739,10670,11101,6700,7387,7421,7385,7491,7459,7470,7437,7565,7565,7387,7387,7501,7548,8223,6772,6593,1746,5912,7640,7505,7437,7437,1992,7497,1981,1981,3881,7985,6493,3893,8272,3884,8274,3890,3883,535,3894,3897,3892,9493,1767,1769,1768,7299,2520,1766,9892,8232,9534,6512,6511,6509,6510,6508,3885,3070,7753,7753,7753,7752,9502,9502,4788,5821,1764,6809,4046,3830,7285,6115,7388,4362,4362,7427,1215,4046,5912,3702,3850,8027,8222,778,6855,6855,7388,7388,4050,7388,3162,1073,1073,7485,7485,7484,7484,7484,7484,7484,7484,7484,7484,7484,7484,7069,7976,7286,7992,7081,6642,6642,4209,8063,8807,8827,4778,8867,8867,7614,8910,8948,1198,6718,2913,7830,6693,9308,9229,9366,8257,7383,3014,8733,8185,8477,2705,9725,5331,2253,961,9799,9813,6349,6349,7835,8306,7587) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC