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,867,6001,1954,1345,4178,240,458,2889,1085,4985,4900,2766,6788,5907,972,4109,5252,2989,2324,464,1402,3712,5782,8060,7576,1086,6817,220,6975,1308,1511,8110,2169,2157,5959,4769,7657,2643,7123,5024,6139,850,226,6972,7846,2384,5142,6845,8793,5995,4535,6713,3625,7873,7131,867,186,6103,2749,8290,2171,7576,6807,8839,2594,8900,7920,5719,8089,1215,840,9616,2555,990,7576,4769,2998,9603,8543,2328,8995,6117,1167,2261,9386,9936,10203,10204,916,10186,4216,4979,2474,6740,7238,8220,7833,6587,4395,9030,7143,1988,1988,1988,8948,5770,1662,9616,8832,9189,9437,9217,9438,9349,8706,7928,7928,7928,7928,7928,9838,9864,10259,8922,2023,7602,1349,6223,8627,1887,2787,7365,2384,8389,7168,7503,6443,7551,1029,6212,9387,6488,2820,8560,2786,8496,24,7754,3076,7755,7756,7927,7751,2384,7973,7972,10304,7639,6610,8437,9116,8915,8887,6820,10666,10705,10669,10721,10670,10301,4325,4412,6622,9045,9299,9600,9926,10145,9804,10550,10370,3074,9342,2328,4346,1324,3389,9386,10505) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC