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,10720,10649,10412,6769,10839,207,8517,6133,9762,10985,8926,10991,9405,10072,10220,4401,9028,6609,6603,3327,5988,9667,10436,9976,10365,8559,272,6715,9857,6197,9633,9632,10232,5435,10698,9857,9667,10731,4435,313,4769,8710,9946,5435,10717,10717,9983,9983,6602,2951,7642,10302,7642,7646,2261,7646,2261,4432,10938,4432,10938,9879,10526,2261,8514,2261,8514,3863,10211,11263,916,11247,11115,11116,8854,7806,4979,11218,10976,9006,11214,10438,11713,11262,10945,11472,9820,8740,10506,9873,9874,11803,11804,7122,10511,10629,11794,7931,7659,9875,7971,8240,10768,8712,11263,9547,446,3646,10518,6602,11264,2005,6631,10670,11264,11292,10687,8732,7048,4178,10818,11028,6367,10649,10892,1777,6793,4362,9386,11253,10212,9320,10505,9865,11219,11195,10248,9871,6240,11169,11217,10687,11379,9420,5269,10002,10893,4716,10282,11349,435,5269,10826,11024,10649,10478,11053,11101,5770,11612,11261,2069) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC