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,10098,6388,9144,9468,368,365,386,6076,8880,379,6270,387,376,10431,10332,11694,11898,11467,9184,8596,526,531,542,524,1557,6385,8820,8007,549,6380,11301,11269,11247,11254,11022,735,11650,11317,11318,10922,7083,550,547,11665,11791,11427,6527,10176,11051,11194,11244,11601,5383,3070,6354,10925,10923,810,10827,540,532,8788,394,8786,8858,6270,375,390,6076,548,6066,537,541,8880,8878,7693,11467,11611,8784,8787,391,6836,11081,11079,11080,11878,11877,11602,4282,11296,11075,11876,11077,392,538,11903,11078,6076,10921,11173,11174,9523,11183,11667,10643,11936,11935,11939,9483,4299,4305,11980,9610,11825,7610,5691,7311,7697,7695,7694,7868,3442,7696,11695,1704,11694,3515,11696,11697,11576,11574,7608,5297,10522,7844,7870,11611,9386,9231,380,9892,7953,7546,8586,11750,11722,9920,10565,11493,11269,6652,10463,9892,11602,11775,9762,653,10604,4805,8292,7042,11085,778,10336,3511,11216,10107,2145) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC