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,7920,8193,3904,739,7759,7839,4950,254,4411,4258,4209,5542,4234,6104,5339,5286,1253,7857,501,233,5331,5286,2976,3830,8183,231,6858,2294,338,1461,8183,4355,7304,3080,1347,4460,5545,2933,231,1520,1461,5516,640,254,1119,6632,3080,3613,1681,6248,7126,4796,1119,1762,7883,6245,8548,6248,6255,8502,3976,1699,5543,6249,5732,7839,419,6250,9372,1485,8819,6249,1954,9300,3860,6255,4234,8142,5995,4362,3860,4406,9321,4406,9321,2635,7953,2706,6259,1894,8222,7641,4325,3029,6618,3744,5484,1609,322,8434,8628,5669,7635,5693,4349,5854,2033,6252,4109,5799,1954,6248,1954,6248,766,734,5401,2049,4598,5063,3358,5065,5052,5053,6252,6255,1815,5854,5870,1278,1816,6068,1894,6248,2019,1895,2247,6251,2245,2330,2509,2678,2680,2681,2703,90,419,1506,5669,5726,5856,5368,5445,5428,6250,5565,4451,5799,5070,3989,3743,3516,2923,2033,8798,3830,7618,6095,7617,6249,4204,3829,5157,3516,6254,2918,2923,3743,4340,1650,5865,5693,5468,5242,5573,501,2594,926,6245,9052,2033,1650,6243,501,5179,8893,1439,7268,2776,5143,5764,2160,6981,4061,501,2706,8031,1038,7919,2976,466,4901,5247,1207,4730,5837,3803,3037,5543,2381,4766,4624,6809,6845,6104,2882,5251,739,3368,2590,2419,8146,36,1298,3396,7036,4648,6861,8514,7839,5739,1127,8910,8687,4460,6862,7896,4665,8010,5997,7981,946,7920,2294,3080,5339,5545,4258,1347,1253,6945,661,254,6136,6314,7025,5215,4886,4950,4969,6397,9366,180,6595,2933,8629,9402,9079,9554,9639,9725,9290,9807,748,9811,7760,9925,9945,9769,9448,9459,9677,9730,9680,9768,9764,9421,9930,9933,9045,9910,10003,9038,9779,9675,9749,7883,8999,10212,7839,10668,90,7632,10685,6243,6250,7617,7618,8502,5066,6872,6898,5247,7719,7023,7206,7816,7815,8714,10894,9824,9933,10061,10821,10840,1699,11021,11122,11028,11106,11089,11126,11123,11020,5693,5854,6095,6248,6252,11426,11442,11443,11107,10679,5988,11455,11458,11460,11457,11461,11436,11136,11314,11645,11423,11774,11775,10935,11816,11135,10784) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC