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,3337,6130,6140,5956,4419,4769,1271,5882,7241,3499,6718,6691,3455,5927,3898,6751,7705,7703,6715,3702,7048,6587,3337,3337,6584,6584,6367,587,587,525,525,6604,6604,6612,8583,7870,8618,6503,8586,7546,1770,673,8520,2605,9030,9030,1402,1402,9084,8947,840,8826,8730,8814,9104,3598,9060,9319,7295,2520,8815,6700,6700,8949,6631,7273,8922,8922,4598,8326,7270,7270,7374,7374,7374,6656,4121,4121,8154,7639,1746,1557,3073,6688,3071,8824,7670,6138,6138,778,778,1653,6631,1624,2005,1624,2005,1462,508,1462,508,1462,508,6391,8665,2069,7505,4769,1624,9547,1609,6623,1609,6623,1609,6623,8881,10098,8881,10098,8881,10098,7592,10056,6357,6209,6205,8833,1380,6715,6548,8281,3913,8255,9300,5995,4671,6865,6569,5769,8710,8710,8710,9340,5484,3327,7211,5788,6892,2467,2349,8137,9946,4435,9791,778,2779,1990,6656,2781,2783,2783,2783,2783,8585,9522,9518,3881,10565,3893,3895,7986,7985,7987,9084,8618,8584,10238,8244,7804,4226,10211,10172,7806,4362,721,576,7219,10707,3334,1371,11195,11216,9386,2913,6836,10884,10495,11310,9889,11305,11413,10495,3712,11101,10687,11214,324,11305,10941,10773,10889,5995,4659,10770,11367,11763,11632,11224,11794,11628,11629,11778,10890,11607,713,11926,11946,11754,11711,9865,11949,6609) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC