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,511,3715,6786,5719,6393,1970,3997,6961,7238,3719,867,6967,5188,1974,1153,5996,6947,5484,7022,906,5576,3698,1973,587,5435,7384,7499,3863,6658,1302,1302,7460,7561,1776,6965,6966,6110,6968,7805,6970,3029,4944,6383,8349,8523,6621,8352,8357,8354,8523,8356,6609,6815,4146,1052,8839,4460,9017,6808,5719,9851,9620,2389,2869,1738,5515,5371,4527,1461,2869,1890,7159,2187,4061,1351,834,217,6858,7046,5179,1462,5882,5995,6364,6940,4637,6845,3428,6693,6365,7138,6396,7131,5046,7359,7005,7049,6110,6727,6766,7022,3989,7032,3100,3561,1131,179,6740,6986,7238,455,1350,4385,7210,7144,7023,7156,7141,7058,7206,3936,6710,1461,7050,6809,6104,3165,5491,2652,3523,1823,7126,6856,1742,7741,7745,7742,3043,6648,2998,1462,587,6690,6900,6779,6979,2389,6900,7139,6981,7142,7127,7141,5996,1537,7148,7268,7084,7124,5407,2776,4637,455,6267,3608,6437,317,7268,2389,4460,538,8744,8354,4294,8585,9030,9042,3287,8314,7985,665,2522,8206,6962,6968,8354,8353,8352,6966,7805,7805,6578,5402,5402,6962,6966,8352,6968,7805,8354,8354,8351,8357,6970,6970,6970,8356,8356,8352,8352,4716,4716,7576,5371,2635,8349,8349,8355,6383,8352,7805,1828,7805,6658,5956,1979,5996,8661,8616,8616,7266,7294,7253,4558,7152,7091,6962,7125,7095,7276,7707,3090,7123,7805,7665,7093,7296,7096,7671,7278,7271,7115,8048,8033,7280,7272,8412,8477,8645,8473,8709,7941,788,7291,7291,7124,8852,7083,7092,7106,8405,7103,8064,8393,8398,8466,8354,8349,7068,7666,1558,8475,1667,9201,7244,8465,7088,7093,7099,3926,8093,7109,3090,3926,6984,9574,9573,8208,8576,7666,8577,8412,8475,9148,7346,9745,9314,9076,9583,6719,8468,1990,9873,9470,9818,8644,9207,8410,9973,9956,7574,9055,9577,8574,8439,9956,9583,9583,9583,6646) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC