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,1250,2093,1324,176,2374,2749,4401,1271,1497,3425,4659,6103,6701,6488,6205,324,2171,1324,6342,6163,934,52,6875,2182,4535,6348,4774,6210,4199,418,947,5331,6622,1439,3979,2027,6958,2729,5912,6972,1366,867,6806,6973,6974,737,3148,6890,6798,5822,5763,5986,6488,3425,6193,52,6240,3250,4659,2182,5314,7068,7097,2749,1016,6264,6975,5564,4683,4684,1210,6103,7154,6832,4535,324,7218,7149,2490,7823,5763,3908,7108,7081,7990,7893,2847,7880,3346,7804,4339,2027,7715,7079,6264,7270,5912,7281,7285,7154,7906,7284,7941,8283,8081,7941,7286,6103,5245,8085,6205,6138,1016,6121,2897,324,5822,359,6796,6633,8610,6904,8141,6193,8141,7584,3425,8279,4559,8560,8063,8058,8639,8445,8046,7714,8575,8653,8438,8570,4983,6642,6103,2926,4659,2331,8358,5763,5305,3302,7812,2328,8836,8835,8019,9060,8494,8493,2487,9063,7837,1266,7834,7815,7835,6354,8547,3070,7579,4405,3071,1371,1771,1766,6648,3531,3076,8627,186,8659,1461,6947,6103,7836,5763,2546,1016,3809,8583,3908,8584,4659,7870,8793,8716,7816,3536,4227,104,1906,3346,2467,8586,7189,5385,1887,4216,8825,4339,6824,7167,7580,7170,7165,1771,1765,1769,1768,8578,4931,8437,7166,8627,5371,9322,9757,8948,8947,6010,3913,3913,7833,9950,3913,9879,9614,9959,9770,9547,9752,9868,778,10080,9939,9933,8948,9991,9338,5269,6691,8823,8823,5936,10291,7639,3346,8828,9771,698,7359,10312,10273) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC