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,1770,1767,7642,2627,6809,6718,3913,4146,1662,2520,7391,7391,7493,2122,3874,7501,8290,7077,2520,1768,4302,7599,7610,1165,7808,2605,4282,6359,1766,4614,3891,6493,3895,3879,1770,3883,6354,3070,7696,7168,5810,4714,7748,7748,6689,3073,8618,3892,4784,1767,1533,2677,6740,7238,8220,9300,9049,6523,6373,6373,6373,7869,8489,9031,9920,8583,4714,8584,7546,9407,9084,9084,8682,783,8618,7870,2967,7238,2992,3860,1537,7304,4405,358,2658,8141,4774,7105,5995,5995,7913,8220,6740,6740,8547,2627,2627,7239,6621,4860,7837,6210,6139,271,7928,7835,8292,8441,1886,8435,1385,1385,1385,8367,8434,8542,8542,8389,8766,8767,8767,8064,2555,3402,8761,508,842,2302,9349,9072,2331,1245,4964,6221,4178,8324,6740,2021,7238,6270,1557,1380,8220,8247,5763,7300,217,6508,8345,8490,6512,6510,6103,6199,6533,2467,6373,6768,8244,2989,7923,1303,6831,2374,735,9001,8151,6880,9243,6855,7594,510,9505,8869,9921,1052,9450,5839,9900,10228,4405,452,4800,10305,8135,2164,1557,2164,9931,11134,8435,8257,10086,8922,11352,9871,8262,11437,5997,1049,10741,11101,4362,8377,11519,6806,11670) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC