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,6130,3702,7832,3029,7906,2753,7160,6588,6157,6177,4140,5908,7144,7088,8041,6740,6641,2029,7276,8384,582,6633,8082,6118,6349,7238,1516,7941,5582,7101,8049,6780,5884,7911,9139,7589,8305,6141,7634,7929,9611,9610,8947,8628,9235,9031,5908,6138,5576,5331,4566,6639,5286,7138,4652,6845,6714,7219,1029,3413,417,6373,6750,979,388,6656,4079,6371,6372,6740,6512,8241,7751,8245,1029,8337,6538,8331,3889,6493,8323,3890,7840,7879,7878,7897,3913,6264,659,8319,6193,8323,6520,8317,8341,6372,9030,713,4299,4292,1371,5484,4297,6103,6519,6518,6103,6518,8584,8585,9552,7870,7546,1770,9300,1765,3702,8222,7303,2992,4769,4218,8305,6780,3549,2388,5334,8955,8019,5582,265,744,3850,2331,4964,4563,4164,4706,239,8995,9300,8628,8097,9647,5729,9864,9838,9897,9900,567,7634,576,7635,9381,10017,10041,10092,9617,10094,1912,2328,1029,1516,2052,10141,6831,6899,1770,2117,1771,1766,6177,4535,9389,9387,6849,4125,9193,9235,10297,4563,10148,9914,4405,5917,9986,5305,933,2261,7299,9105,4947,3522,9126,8706,8560,10259,10535,8019,111,7822,9164,9065,10781,10236,4395,10021,8182,10823,10877,10658,10974,464,10937,9164,9065,10956,4801,3261,1092,5839,9941,10922,10912,10923,7239,1349,9028,7276,8876,7900,8284,7872,7903,217,5513,4023,1741,156,7088,6664,9304,7815,7086,9308,8877,4796,8880,8477,7088,4535,9299,8889,4019,9561,8369,8460,9581,8772,8071,7674,8636,7285,8286,9910,9922,9959,10022,8184,4765,9817,9819,9818,7097,9526,2032,8169,6769,8106,9125,6872,6889,4563,7144,5052,1142,8430,5053,5056,10116,9666,9212,9991,9800,9377,10008,2122,7037,10081,10754,8092,9554,9036,7830,6805,10312,11021,9758,8915,9492,7987,1369,11129,11103,2288,10412,7285,5688,10847,11334,11338,10022,984,7666,7175,9438,365,380,376,8172,5903,11554,11630,11753,8891,9956,7086,11757,7935,11370,6632) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC