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,5897,6799,6804,3744,6727,5068,5998,6977,7149,7374,2967,4985,7155,6565,7416,7937,8094,2864,6860,1271,6365,2748,6130,1727,3892,7290,8523,4385,9095,7677,372,9300,9381,9374,9621,9890,4769,5996,834,1537,3913,5435,4437,4438,6602,4086,1153,10371,11207,11205,6354,11209,11590,11394,8682,8618,3882,8692,9147,4121,11899,7546,5784,1265,4128,1650,926,1917,1461,3595,986,6190,6609,1462,1084,4767,1681,1461,4209,754,6705,5371,6809,4566,6845,6103,4046,4049,6245,1016,6561,6249,6980,6104,5717,4050,419,6248,6252,1815,2245,6804,6766,6589,6793,4086,1526,768,6686,6588,2706,6679,2417,6635,6856,6639,6684,7138,5148,6726,7156,2342,6674,916,6314,6595,2169,6792,5371,4023,6858,7158,3080,5339,2294,1895,1119,7050,7160,2923,2703,2123,5573,608,4061,2006,752,1349,1127,1253,8543,2933,8683,6713,4460,7138,1432,5373,7354,5812,4048,5266,3080,8687,8978,8925,8548,8910,5545,4652,4566,4258,8905,8795,5817,6684,9086,9030,6635,9000,9050,5339,5020,7126,4460,1349,1347,3701,8904,2933,9196,8688,9079,5157,6117,1299,4553,6696,9353,8632,9363,1298,6632,8442,9258,8102,9406,6698,3195,9200,608,5726,5349,3542,8978,6337,9347,2118,3159,5407,3702,4450,3581,240,5895,2749,6394,5887,5437,5068,2384,7203,6366,6804,4639,4405,7897,7903,7776,5838,8093,2006,7775,2302,5371,2029,8296,5912,8390,7840,7912,6365,6843,6726,7058,4395,8109,5912,3561,3029,840,3863,5742,3334,1973,5717,2145,5733,6593,6814,3334,3338,7012,7238,3248,2069,1302,3402,3402,3402,5770,5770,5806,5806,2643,2643,6815,2555,2384,2384,6865,6865,582,9324,582,6183,2635,9865,9866,5770,5770,1153,1153,1153,1462,840,1462,840,8970,8970,8970,8113,3702,4769,5770,3074,314,8497,3913,1153,4923,9318,3913,4094) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC