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,217,6383,7985,7005,217,2117,4405,3358,8816,7960,1050,7641,9350,9263,9204,9058,1558,8230,7081,7898,8439,7646,7773,1369,6584,6402,6069,1272,9376,9405,6715,8389,1885,5995,801,156,3236,7869,5795,3525,4913,5639,6311,9788,9497,9857,9951,4156,2453,9959,9778,9543,9637,9543,9637,9868,6010,9868,6010,9868,6010,5269,754,5269,754,3878,6173,2749,2783,2799,5454,7816,8714,2913,8485,2253,5564,6890,9103,2490,6622,2946,9390,6001,9391,5839,7872,3074,314,6831,4800,6174,7206,3358,9258,391,452,10454,5827,10337,10741,10761,10649,5839,4923,9031,10226,11010,7639,9029,8947,2522,4259,2467,1591,6788,7605,9342,5407,9061,3878,9674,9547,9320,6103,9757,609,10008,9959,9933,6781,4598,10061,10170,10211,6579,10655,1345,10537,10702,10718,8394,10356,1664,1664,6650,9300,3702,3702,7816,5362,5515,8745,9419,2998,169,10897,8744,8150,10892,9420,9602,10873,9916,9913,5467,9258,5371,8290,7587,7604,8154,7165,6181,9375,7206,10970,1667,850,10510,7283,1257,7175,11133,6650,8882,11052,6794,6769,11102,10892,10291,6459,5913,6042,9367,9368,10522,6621,4473,9028,10671,10829,10546,9738,2856,7080,9816,7584,10185,9405,8939,8574,9710,9258,10023,11222,11101,11286,3913,7088,8771,6806,8419,11315,11291,11331,10188,11351,8520,11300,11345,10767,8822,9083,11344,9669,7273,9305,6076,9670,9671,10839,8092,11347,11409,11449,9671,9954,10672,7046,9955,984,10686,10761,10220,10675,10767,2085,10869,10947,5922,3346) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC