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,397,863,271,233,4362,6191,967,784,3036,6234,3997,5508,6427,6474,6381,6388,233,6375,6928,6758,6911,6757,6756,6391,6753,3247,6917,6719,6763,6764,6765,6762,6761,6414,2282,6932,6754,6752,6423,6935,6759,6925,6760,6427,6757,6918,6912,2274,6910,6938,6423,6424,6926,2275,2282,6756,6191,6911,6758,6763,6756,6932,6926,2274,6757,6935,2275,6423,2605,5142,1165,3898,3875,5691,3515,6197,1108,6533,7215,2522,2458,6371,6511,6512,6503,6989,6234,6375,6519,4287,3442,8267,6743,3036,6937,6933,6931,857,6545,8984,2594,2005,9488,2005,858,6922,6934,6935,6938,6744,2276,6912,2275,7134,8725,2274,9111,9891,8881,9190,8340,8882,990,6757,6936,6758,6746,10328,10329,9149,6422,6523,6381,9386,524,10098,10961,6743,6270,6191,10381,10383,10499,10613,10173,8340,7199,10487,10729,8967,6545,6423,10549,6925,4086,8947,6774,1371,3531,5269,8613,7576,9951,4349,9394,397,2029,8938,10810,6631,10670,979,7300,2889,6365,10296,41,11019,7912,7870,10649,7631,8027,7840,11295,3327,2627,6693,7307,6918,6840,7680,10381,6146,6151,6916,9165,10432,7870,8157,10695,10136,10489,7610,7694,3515,8965,9951,6925,8156,10388,9936,6926,7055,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,6988,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,10486,7055,10389,10426,10428,10381,10957,10222,10264,10421,9176,9177,9190,10167,10384,10420,10423,10425,8987,6491,6417,6517,11091,10487,8303,11069,6925,8154,6922,8002,8267,11067,10390,11071,9088,6800,11068,8156,11182,11183,11184,4558,11181,8943,8944,6932,6354,3070,3073,3071,7881,8945,6689,6688,7753,8946,7752,8088,8627,9037,9665,10053,8946,6689,10544,10975,6768,11221,1303,6926,11355,11354,11356,11461,11357,4785,11082,9383,9867,11085,9473,10232,8203,9633,9632,8362,11357,11356,11109,6198,2779,6443,2806,6197,9669,6200,8693,4512,4316,8692,11581,8694,8656,8654,8696,8695,8200,11578,8203,8655,4645,11579,3719,11582,3115,11580,11583,3559,11354,6520,11355,8203,11356,8656,11357,8696,8306,10331,1257,10332,5995,10328,10327,8241,9624,10326,8705,10323,507,11242,9626,10330,8704,11759,10333,8174,4046,10325,4512,11677,11320,11050,10326,10637,10646,7808,11247,11252,11091,8980,8982,8981,6607,8232,10822,5065,10921,10044,10045,10500,10386,10389,10612,7891,6854,6220,10387,6419,11390,11079,7702,8342,4714,6936,979,4614,6656,7569,9909,810,11562,11493,11564,10596,10045,11394,11590,5383,8334,9669,9593,10335,9670,9671,9131,9672,11218,9673,9669,9591,9670,11302,9671,8717,8681,9473,10298,9475,10390,10383,6922,6759,11054,8156,4287,11301,10800,11414,10487,8244,8598,9428,10821,11046,11429,9415,10920,11407,1730,10332,6934,6423,10324,7546,11466,10840,9414,9407,8245,11394,10522,8246,10559,8682,11405,10487,1266,8310,6831,11266,10912,11134,10713,11221,7696,10925,11178,11179,11183,7693,11037,11146,7870,4294,7189,11015,5635,11148,4386,9909,11331,10889,10920,10475,7697,4,11255,10863,10835,10921,10923,10486,7694,2605,10828,979,9149,10545,10840,11177,11375,10075,10520,1685,10521,1266,4390,4282,1411,8696,8695,8654,8656,11175,5297,6359,10827,11249,7808,9137,5332,6995,8694,1769,1768,10522,10922,11154,8655,10027,3442,6520,810,11251,10029,11317,1685,10546,11185,11182,11181,11186,11318,11184,10924,10639,10641,10645,10646,10643,10642,9880,10644,10647,10753,8693,11458,10644,10822,9933,8694,3895,8692,8655,10645,10637,11252,11321,11176,11590,11432,6354,1766,8946,6688,10331,9794,7881,7753,7752,10053,3070,9665,8627,11584,9679,9867,10544,10975,6689,7266,10927,3073,10926,7676,10930,10931,7600,11109,8727,8088,10232,3071,11582,11578,7188,7176,7186,7178,7187,7184,8897,7181,11419,7180,6652,272,11422,11013,9037,6654,11148,10928,11016,11221,9250,8944,7183,9223,8945,8943,8011,8247,11431,7182,8585,11418,510,11149,11601,9383,6653,11723,11579,7179,7185,11019,11218,11493,11722,6271,10329,10333,8241,10332,8337,11420,11465,1303,11176,11650,10327,11427,11429,11463,10931,8727,9920,11421,7870,10323,8883,8310,10565,11147,4386,11464,10238,8333,10555,10640,9407,10216,8308,8314,11146,8244,7151,7024,8318,8248,8585,9120,11466,7663,7103,3874,10519,10641,4146,10639,8880,394,10643,10752,1266,11799,9037,8787,10637,10647,10640,11723,10646,11321,11836,10931,10463,7753,7752,8325,11624,7604,8088,7600,9665,10975,10053,8627,10544,3071,10644,8944,8943,10642,8727,9383,9587,9867,10232,9589,8945,11221,9114,9592,9410,8329,8245,8323,8242,8599,8320,8332,10153,10200,3442,8700,7696,9424,9407,8334,8682,7546,7631,9084,8874,8318,8584,8316,6496,8317,8597,8335,10217,10217,10214,8598,9114,10216,10215,10336,10101,8584,10213,8586,9182,8310,8307,8314,8244,8307,8311,8308,4305,979,10521,9729,10545,8313,10334,8309,8312,8336,10335,10607,10522,3070,6354,11069,8154,11071,8002,11067,9720,10868,10526,7752,7753,6688,8946,8088,10486,6854,6545,6425,6423,6421,9087,6922,10489,8267,6424,10486,11817) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC