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,2627,6836,4558,8764,8434,8856,1511,8956,6294,6740,8111,7238,9692,8220,9843,8220,9843,8389,9698,8389,9698,1770,6646,6394,358,7288,8768,6962,6383,8523,1664,6110,8523,186,5965,8831,7912,6715,6832,6402,1296,3823,3865,1380,7912,6383,8356,8355,7805,1308,7918,9498,7541,7541,6367,7918,9065,26,4437,1345,7505,6897,8659,2635,9762,8005,9729,7711,9467,2384,6394,7917,1726,6174,9729,9856,9975,9975,10056,10035,7966,7966,8130,7917,9949,9830,427,18,8562,427,26,5516,7906,7572,1591,6102,3457,4769,8268,8202,8399,6264,8425,8200,5994,4362,7280,4218,7897,358,7548,2399,6819,5380,4320,4320,7597,1371,156,8223,7281,7655,458,8947,461,4900,9292,5784,6578,7204,1380,8580,8404,9584,9582,9583,9585,8255,8255,9650,2913,2253,455,6843,7114,7547,8614,1492,7664,7953,6719,387,10020,1766,6198,6222,7162,6216,7199,6391,6388,6214,2951,6220,6218,9829,9165,8156,6920,6925,6926,4304,9734,6988,10161,6742,8656,9176,9177,8816,6498,6497,6216,6499,6939,3248,7953,9176,10387,1767,1766,8330,8328,8323,1768,7569,3515,9590,9591,11047,9593,10201,10725,10920,10561,10728,9588,10139,8325,10801,10216,9429,6534,6535,9493,3073,3070,6354,7753,6689,3071,10544,10053,9665,9946,11221,10544,10975,2998,3402,10316,4923,10318,8970,7849,2039,7966,9976,9972,9524,8024,8220,7238,8659,4405,7576,7962,7953,8659,1767,1771,1767,9931,10711,9327,10780,10569,6181,5188,10741,11324,10609,10820,10617,8520,5576,11396,11457,11849,11774,11342,11765,11266,10692,9307,10267,7239,10738,11972,10212) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC