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,3327,11101,365,374,6076,11792,4684,11791,4293,1768,11078,5535,4614,11903,6785,11608,11750,6373,11961,8560,6381,271,539,2729,7304,2729,9438,7903,9300,9480,3647,1215,8306,9425,4598,8874,4598,8241,8244,8706,9182,9349,8337,7928,6768,9417,8245,9898,8922,7,9017,9432,9632,9296,10056,9296,9096,1165,222,3883,10292,810,10259,810,6359,9864,10337,6272,10337,10072,9959,3358,6348,10640,8144,4301,10738,10667,10976,7833,9777,10814,11037,11130,11121,10951,272,10937,10954,9880,11323,6354,10007,2530,104,374,8490,11496,9277,2117,11272,11439,11690,11721,10533,1385,1402,10269,10836,8830,10362,10432,1765,9555,11559,1771,10821,653,11811,10481,10722,9096,9687,6183,10228,9694,3884,3926,3884,3926,3895,3882,11564,3997,11301,11249,10323,11269,11299,11961,11301,11051) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC