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,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,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,6491,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,6066,391,368,387,384,384,384,8786,546,372,9534,10300,2389,9775,7568,9692,6272,9304,9710,550,9192,10725,6066,381,6536,6537,6538,10557,10199,6534,6505,385,6535,10559,6532,6506,4714,7610,6533,7311,10562,7697,6701,380,8323,368,3890,3889,3895,3883,3884,391,365,368,10161,6270,8878,8880,9483,8882,380,10846,11241,10323,11019,10750,11722,11493,11218,7631,10726,9407,7631,9084,8682,8618,9920,10238,11899,9386,8880,4769,8788,6082,378,10961,386,990,368,11006,8878,8881,392,387,8880,8882,8878,10162,380,381,384,385,390,391,386,6390,6381,10371,11295,11085,10801,11036,9588,11254,6745,10560,385,8878,9591,9802,9909,9342,8828,10060,1097,6550,9771,9931,10161,9043,10126,2897,1953,8879,9044,9993,10166,2830,6774,9093,9843,10125,10237,10282,10297,3465,8973,8613,9987,4156,9336,2164,6953,3647,7576,10269,10468,10280,10183,10537,4906,9934,8830,9557,9786,7602,9342,7917,6648,9789,2164,10098,156,9329,10735,9497,10080,8763,10320,10481,10886,9910,10532,11026,10892,11099,11102,10133,8967,10649,11078,934,11140,11097,11133,11095,7602,11233,8976,10808,1097,3282,6119,10093,675,5792,9283,11260,11166,130,11198,9235,11396,9193,11141,7148,5454,11479,10094,11352,11359,11442,7613,11447,9402,10091,11249,368,8693,8692,8694,6359,8656,7703,6271,726,9734,7199,11081,379,6520,11429,8655,11393,8585,11181,8696,11085,11238,6744,8855,6270,10167,11390,11080,11181,7704,8982,10613,10169,6491,8655,375,11460,1167,2145,376,8881,1783,9438,11639,11640,3885,7165,3897,3891,3889,3888,11209,3884,3895,11207,9437,3893,11205,6745,8981,3892,11203,11206,11204,9517,3896,6585,6544,533,783,7926,7391,7476,7459,7493,6429,860,9020,8980,6753,6752) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC