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,10305,10731,10669,7258,7249,8626,8734,9247,9326,923,6981,8214,7873,9275,7981,9304,6955,5903,812,311,261,4944,9404,7065,9423,9329,7994,6364,208,9381,2976,6192,206,9013,5011,2507,5885,8151,3195,9421,7719,2882,9334,6838,7839,9243,4985,9260,9612,9069,8957,9198,9200,8187,308,9327,7893,9202,9213,9538,9202,9601,9883,6113,9544,7175,7892,7874,1537,10190,7970,5917,9390,4412,9449,9759,9080,1097,8554,6139,9283,9646,8551,10085,10124,10123,10126,10177,10183,8098,9009,10294,10302,10493,10261,9,8956,7907,7861,7299,10490,10501,4694,10612,10541,9406,8231,8963,10543,10531,8514,4795,10021,9664,665,2168,10816,10818,10819,10847,8144,9819,9919,10814,9343,10978,10954,6891,10741,11064,10976,11216,11222,11010,11025,6354,3070,3073,3071,6689,6688,9679,8943,7753,7752,8088,9037,8627,8944,9665,10053,10975,10544,8946,8727,10930,7881,8563,8945,10927,10926,10931,11082,11085,7870,8586,10930,10975,10928,9522,9515,9517,9520,9518,10379,9521,10522,11109,2643,10521,10346,10546,10463,10436,10402,10750,10612,10827,10545,11011,11041,10721,10687,8788,10810,10387,10390,11087,6854,10802,11248,10813,11121,6740,7592,11025,2253,11215,10940,10305,4424,9765,10212,11216,8257,4512,6953,3863,3913,9951,10228,10228,6715,10670,10670,5435,7592,5435,7592,3327,9863,3327,9863,11410,3913,5435,10339,10916,3863,7385,10631,7456,10687,10687,11023,10687,3327,9863,10687,9863,11380,10579,10211,9977,6740,1589,222,10940,7238,5134,10296,8306,223,7143,2749,11349,6821,7837,8780,10734,2253,11438,10830,11438,10164,11303,3210,10731,11271,11272,8485,5602,9320,8547,7576,11586,9386,11239,11266,11658,11655,10892,11437,2389,5435,2035,8191,3954,9300,11497,11497,1765,11089,7920,10874,11020,11101,9543,11326,11784,4320,7143,8250,314) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC