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,6151,1327,458,6616,3549,6103,464,3428,5334,3997,5882,6798,6840,6763,1663,6157,2998,3449,3069,6427,3389,3898,452,222,4913,6600,6855,6388,2507,4765,3254,3169,6151,2684,6905,6129,464,4659,6181,2164,735,393,6894,379,6146,2737,1049,397,7195,7199,8656,9088,6523,3327,8387,6545,8305,6604,8592,6616,6719,6700,9151,9190,3879,8097,6521,7400,9502,9647,9502,2780,2785,6489,1245,860,6546,2696,2917,4426,6600,566,4490,1210,466,4752,4788,6719,3564,6539,863,541,6985,313,6200,6199,4121,4029,6201,6198,1533,550,801,1207,4788,28,8316,8313,8338,8333,8328,8341,8342,8317,8339,8325,8314,8324,8340,8335,1245,3883,3892,3889,3890,1770,1767,4301,4286,7180,7184,7698,6223,4219,6902,8252,8873,8340,8649,8872,6390,323,8665,324,8787,8785,375,8788,388,8786,6270,382,391,394,9111,9114,365,8858,3719,382,365,1645,547,7849,3865,4931,6798,531,551,510,3071,7676,1324,2374,1732,8003,532,546,374,1664,6719,7437,858,857,397,1537,5910,376,382,379,6743,6144,4614,6751,388,6082,380,4302,379,391,376,377,382,385,390,3090,6742,3728,5371,381,386,6076,385,377,394,386,8168,387,376,8165,6750,393,384,375,388,6270,6066,372,379,390,3893,7199,6082,368,3879,7238,409,6749,3036,365,8168,1557,392,389,8788,8785,8786,4639,8882,223,7923,4395,8878,2989,8787,6103,6746,7871,367,2117,8877,6493,3428,8881,7239,8982,5770,8983,6204,7175,8358,6785,6144,6538,8856,6386,4714,386,8789,8880,8858,8855,9192,378,7300,8651,3889,3896,3883,3885,4302,7214,3888,979,810,1165,8824,8857,8358,6359,5386,5297,9149,7599,7808,1266,1411,1685,4289,6527,6521,4293,6218,3891,3890,4294,3895,6532,3892,7693,3894,3882,8271,3897,8272,3893,3881,3884,3888,3883,8274,8273,8981,8982,546,554,6537,8980,6381,3885,8879,2701,6377,9698,9713,9709,9708,9710,9711,1766,9718,9435,8241,8246,9593,9592,8310,9684,8598,8249,9427,8243,9425,8339,8242,8597,8245,8247,8248,8318,8317,9428,8319,9435,8319,9424,8320,9436,9426,8328,9591,4286,6199,9891,4298,4304,6928,6932,6934,6938,6936,6935,6604,9088,7195,7199,7198,7162,7191,8825,1730,6596,5961,4292,9067,4259,2084,8168,8387,8582,8352,6967,6966,4614,6970,7966,6965,6415,6968,1557,6272,6385,14,6450,3380,8831,3247,5882,8490,4501,7816,6396,6656,6383,6076,7904,8232,1663,8821,9631,1616,3358,7632,9767,6787,8542,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,6426,10486,7055,10389,10426,10428,10381,10957,10222,10264,10421,9176,9177,9190,10167,10384,10420,10423,10425,8987,6417,6517,11249,368,8693,8692,8694,6359,8656,7703,6271,726,9734,7199,11081,379,6520,11429,8655,11393,8585,11181,8696,367,11085,11238,6744,8855,6270,10167,11390,11080,11181,7704,8982,10613,10169,8655,375,11460) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC