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,3888,5576,2869,3883,1351,834,3884,7019,8274,8222,7761,8271,9195,8793,7987,9925,9552,3890,8573,6526,3897,6520,766,6521,3882,7672,3893,11429,3881,3896,3887,11430,3894,7286,3891,6521,11121,9609,7244,6493,3884,7280,11650,10920,10938,3895,8268,3888,10921,11427,3893,8343,8741,10921,11425,6521,10923,10834,9905,5383,9199,9909,535,9658,11186,3892,6520,3997,653,11212,4282,7086,7285,4305,4298,11370,554,4301,9082,524,10827,6596,525,10888,526,11188,4293,1379,8581,4614,4304,11695,11690,4292,4289,527,532,528,4294,531,529,7870,11611,9386,9231,380,9892,7953,7546,8586,11722,9920,11568,10565,11493,11269,6652,10463,9892,11602,11775,11723,391,6076,1556,9178,6382,9555,11051,10097,10443,2084,1730,6656,10613,6076,11734,11792,4684,11791,4293,1768,11078,5535,4614,11903,6785,11608,6373,11961,11146,11167,10485,9483,7599,9502,11229,3889,6197,7277,11665,11985,8729) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC