thisMySQL 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,4178,858,6545,6840,6763,6764,6765,3090,6144,6753,6761,6762,6759,6760,6840,6424,6752,6719,3609,6750,6742,6391,6746,6744,6749,6745,6911,6910,6914,6913,3926,6422,6758,6421,6935,6424,6425,6932,6938,6925,6926,6912,6427,6423,6763,6764,6934,6937,6926,7374,6234,7898,6963,6174,378,378,6388,6880,6880,6386,6386,6388,6760,6082,6750,6749,379,379,379,379,3222,3222,3222,3222,3222,3222,3222,3222,7067,7011,6911,3863,7060,7060,9520,9517,1779,9515,8168,6760,10310,1787,6393,9976,11023,365,8685,11079,11080,6719,387,10020,1766,6198,6222,7162,6216,7199,6391,6388,6214,2951,6220,6218,9829,9165,8156,6920,6925,6926,4304,9734,10161,6742,8656,9176,9177,8816,6498,6497,6216,6499,6939,3248,9737,7953,9176,10387,1767,1766,8330,8328,8323,1768,7569,3515,9590,9591,11047,9593,10201,10725,10920,10561,10728,9588,10139,8325,10801,10216,9429,6534,6535,9493,3073,3070,6354,7753,6689,3071,10544,10053,9665,9946,11221,10544,10975,10045,6926,860,3277,6919,7199,10371,857,9735,10432,9735,10432,1526,7190,6234,9781,10263,6914,10335,10194,9500,10334,10333,10557,7211,10551,6938,6937,6937,6760,378,6914,368,9909,6925,6922,6423,6424,6422,6425,10386,10098,10502,6144,10257,9172,6922,8445,6191,8444,6925,8156,10390,10613,9177,5386,5386,6759,6762,10649,10417,10487,10488,10813,6754,860,10431,10390,10388,6761,6760,10382,10387,10386,857,6913,7162,6840,6926,6925,9735,10445,6381,6391,6914,6763,6915,9165,8693,8156,8267,7200,7199,7196,7198,7194,10996,10797,7195,6917,6922,8267,10599,10600,10598,9087,10505,11077,10445,11078,11079,6935,11080,10603,11075,6916,6933,6936,11077,3277,6928,6929,6934,7190,7191,7192,6937,6918,6385,673,9178,10597,10593,6421,6423,6920,7042,6424,6425,11103,6426,10486,7055,10389,10426,10428,10381,10957,10222,10264,10421,9176,9177,9190,10167,10384,10420,10423,10425,8987,6491,6417,6517,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,6542,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,6922,582,6929,6925,11406,11407,10324,11677,10742,11427,11099,10388,1990,10386,8633,10387,10423,6925,11325,10390,860,10483,8,4401,10477) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC