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,446,2869,5882,5915,6168,6162,933,6172,6712,6710,3850,1461,6365,6588,6365,6540,1453,1351,6605,4109,3521,4834,5887,6899,1563,3522,6544,6813,6396,2035,6364,501,470,1098,6572,4510,744,6562,467,1474,2571,4796,1568,2331,2033,423,645,5454,2457,6574,6571,6576,4126,4019,5089,5112,261,5623,1487,6644,6767,322,466,6766,511,360,215,1160,1441,5143,2912,3590,6539,6544,444,652,955,1561,1834,6040,1371,1070,6660,2876,5719,6030,3302,1439,6866,2520,5371,2261,6869,1769,6840,6869,6628,6754,857,1516,1245,1616,2696,6804,4426,7020,7092,7082,7095,7121,7097,4490,958,7085,7093,6813,1165,6118,608,1699,2294,3519,6172,2590,6565,396,36,1532,1127,6882,2419,6569,975,6669,6736,6566,455,6563,6675,3368,5576,2869,1351,6883,601,6676,6993,6994,7001,739,6675,6779,6998,6996,6999,6842,6947,6795,6562,6544,6564,7003,6990,7063,6574,186,6676,6678,6571,6997,7059,6986,1521,7228,1856,650,7229,6992,7232,3029,7231,7225,7227,455,1057,7003,7234,1532,1131,7230,2187,7057,7224,6669,7223,3850,7233,7226,7237,7231,734,1181,1890,2192,810,6359,726,7299,2398,6512,6538,4362,7230,6940,6790,6797,6537,7681,6536,4796,7692,7699,7233,7229,567,6573,7681,7684,7685,6735,7013,7184,7234,7687,7634,4109,2889,361,567,6540,7691,8094,6539,7635,4834,8142,7047,6212,1266,8244,8515,6270,8171,6780,6076,6901,8698,8100,8690,7835,374,8683,8554,8560,5924,372,7047,8706,8305,6076,7003,6539,6521,6719,6761,864,5691,6527,1165,6522,6518,6538,6520,6218,4282,397,6985,6719,1767,1704,4298,1685,7576,1084,979,6656,3442,2951,6800,4121,6376,6768,4296,858,397,3875,4286,4289,1967,3863,4121,857,6985,5297,1411,735,8245,6521,6527,397,7201,7599,8243,6261,6512,8314,8318,8317,6359,8334,8320,3875,8582,4931,8249,8490,7365,3510,7751,8729,8694,8692,2779,7300,2828,5635,2783,2826,2827,8597,2815,4804,7180,7184,2803,2805,2806,2808,6222,8654,8655,8816,8696,6521,3828,6381,344,8531,681,6376,2876,8355,8353,9343,8874,9129,6444,6409,8698,2218,1266,6276,9041,8324,7721,810,2208,3337,6540,8882,382,1084,3327,9949,10037,10034,7721,10032,10263,7204,2169,7697,1704,7693,7840,10696,3327,8490,8507,10698,10579,6925,8156,1084,7721,7966,10983,6988,6922,582,6929,6925,11406,11407,10324,11677,10742,11427,9143,9408,7610,535,547,11054,8596,545,9430,550,979,1765,548,9143,9437,542,3889,8325,3894,524,10727,7987,8249,527,3896,3888,541,3887,529,7986,536,3883,8272,525,9502,8987,539,6493,8989,528,10556,9147,9146,543,537,531,11080,10822,6042,11077,11075,11076,11079,11078,11077,10957,9231,9144,11458,8665,6390,10502,6474,6475,6473,6471,6470,6453,6469,6465,6461,6462,6464,6466,6467,6463,6468,6460,6454,6457,6458,6459,6456,6455,6470,6471,6469,11493,6468,6467,6466,6465,6464,6473,6474,11019,11432,6461,6462,8586,7546,8682,9084,9407,9920,7870,10238,10565,9084,11218,8585,6039,6036,6034,6023,6038,8584,6041,6040,6544,6444,6540,6539,2224,2221,694,2211,9517,9518,9521,8618,9520,681,695,2208) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC