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,3521,6010,2576,5995,6103,1351,1537,834,5995,3860,2992,1250,397,5998,6312,5988,947,1126,2995,1589,450,2164,2164,2911,4355,4510,6188,5609,3850,4536,2873,2871,4329,6692,6354,3070,3073,5576,2869,5997,6800,1439,510,1770,1765,1771,2780,6505,6539,693,6533,6532,6261,681,6539,223,6544,2894,840,2576,3029,186,176,6714,6710,5887,6383,7019,446,446,4349,3714,5995,3913,1084,5322,576,6364,4701,2989,5380,6528,4535,5609,4842,1724,3860,6855,1398,2951,2071,228,5995,6167,455,734,463,3585,319,663,6660,3850,4218,3184,3217,6364,5070,772,5765,5623,6599,3844,360,3521,3522,743,3520,6644,2033,5956,3519,3302,447,5839,4057,6947,1416,2390,1371,6641,601,2170,3557,567,6645,2628,7023,3264,1345,2602,944,2911,1257,780,6731,1257,4046,4536,7304,2873,4986,3465,7238,915,7761,4535,3428,7239,1371,7761,4079,7602,6642,4178,6006,4178,6527,6220,6522,3085,6152,5386,979,6359,810,1704,2605,2374,5691,7694,7697,7695,1411,3515,6372,6371,6220,3442,5691,1685,1165,1704,7693,6359,1616,3385,7696,4121,6519,2911,6445,3864,3823,6445,4500,7147,8220,8080,7110,7783,5602,8909,8055,7674,8087,7261,5961,8628,8836,8213,8375,7023,7775,1893,8776,8378,8371,8545,5995,6140,2473,1325,7241,6381,524,7363,6383,6175,7651,3550,501,8142,8097,8115,6362,6110,8305,8305,8019,8019,6157,240,961,961,961,961,8223,8223,7863,1402,7900,6780,8706,8706,6310,8967,8514,8514,7911,1052,1126,6118,1371,8290,8151,5334,435,5251,7658,8628,8628,3888,5576,2869,3883,1351,834,3884,7019,8274,8222,7761,8271,9195,8793,7987,9925,9552,3890,8573,6526,3897,6520,766,6521,3882,7672,3893,11429,3881,3896,3887,11430,3894,7286,11750,3891,6521,11121,9609,7244,6493,3884,7280,11650,10920,10938,3895,8268,3888,10921,11427,3893,8343,8741,10921,11425,6521,10923,10834,9905,5383,9199,9909,535,9658,11186,3892,6520,3997,653,11212,4282,7086,7285,4305,4298,11370,554,4301,9082,524,10827,6596,525,10888,526,11188,4293,8581,4614,4304,11695,11690,4292,4289,527,532,528,4294,531,529) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC