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,6928,6758,6911,6757,6756,6391,6753,3247,6917,6719,6763,6764,6765,6762,6761,6414,6932,6754,6752,6423,6935,6759,6925,6760,6427,6757,6918,6912,2274,6910,6938,6423,6424,6926,2275,6426,6756,6191,6911,6758,6763,6756,6932,6926,2274,6757,6935,2275,6423,6420,6911,3036,6967,389,6961,6966,1730,7897,1303,6951,3896,7266,8831,6197,8529,6743,8165,979,8585,8833,8833,3702,3702,7003,834,6189,7022,5947,3913,7387,3613,5070,4796,501,576,6763,7707,7119,1116,6925,2283,6764,6765,6763,6938,6753,6382,8168,6385,6418,8203,7703,3247,6754,8055,8387,8401,7674,7069,8400,9609) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC