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,778,1787,4774,6774,6000,6693,2399,7008,6235,6115,7943,8430,8370,8391,7675,8047,8067,8034,7106,8461,7250,7113,7112,7096,7084,7106,8055,9225,7675,7278,821,3989,3989,5681,5681,7976,8128,4716,8128,4716,8303,8303,7067,8303,7067,8303,7067,8303,6394,9350,8024,7916,6127,8497,10211,10304,5996,526,2056,391,7270,3860,4199,3896,1458,7300,6768,7300,6962,7286,4544,4860,7899,545,550,548,539,4684,3554,3554,1398,7175,7032,1662,549,6477,525,2706,778,551,864,1366,8356,8530,546,8880,979,6394,6842,8212,7472,9030,578,547,2847,3337,7178,8438,4500,4500,9076,9778,9494,9494,9791,9745,9858,8575,8575,6648,9488,9879,6583,6583,8434,8434,9547,9547,10638,6579,8063,8833,10731,8428,9853,9785,6400,10695,4500,1783,9266,1947,6603,1973,1787,10296,6368,6603,1807,8732,7048,4178,10818,11028,6367,10649,10892,6793,4362,9386,11253,10212,9320,10505,9865,11219,11195,10248,9871,6240,11169,11217,10687,11379,9420,10831,5269,10002,10893,4716,10282,11349,1785,1787) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC