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,5148,4234,4121,4121,6571,5719,2706,735,1257,6152,6151,3359,4305,6596,261,314,3702,5996,7915,3334,7722,7938,1811,1831,567,8250,7992,1783,8316,3883,8411,8732,2520,4296,8892,546,9152,8683,8475,8627,9037,7666,9300,7174,8648,8948,7967,7123,6174,1172,8867,7563,8865,8865,8865,8865,8865,8865,8865,8865,7879,6354,7918,7878,4501,3115,446,3071,1108,7636,6967,6961,7753,7998,7999,8349,6984,6962,6967,7304,9030,4302,6742,7473,1988,6242,4317,6174,6814,7964,8686,9351,3337,3823,1462,8732,2417,1250,7473,10932,10916,9601,6953,8780,4923,3327,11216,4769,10874,10731,11379,10579,6715,5647,9685,9693,840,2913,9692,9713,2749,2783,2799,5454,7816,8714,2913,8485,2253,5564,6890,9103,2490,6622,2946,8689,9390,6001,9391,5839,7872,314,6831,4800,6174,7206,3358,9258,391,452,10454,5827,10337,10741,10761,10649,5839,4923,9031,10226,11010,8113,3702,4769,5770,1270,314,8497,3913,10304,7639,6610,8437,9116,8915,8887,6820,10666,10705,10669,10721,10670,10301,4325,4412,6622,9045,9299,9600,9926,10145,9804,10550,10370,1982,9342,2328,4346,1324,3389,9386,10505) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC