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,834,6365,1453,6831,7087,7287,7068,7108,7971,7072,7247,7946,7946,7107,7294,3036,8044,8049,7906,7282,7282,8086,7279,8081,7662,7269,7939,7074,4983,8220,7940,8371,8371,8086,7077,8571,8206,8206,7111,7107,7076,7072,7096,7294,7642,8083,7086,7118,7280,7967,7270,7270,7125,7262,7675,7262,7675,7106,8240,7266,8208,7152,7125,7642,7895,7091,7906,7111,7967,7123,1153,8080,7266,1084,4936,8712,7068,7895,5908,6767,6181,6181,6181,6181,6181,6621,6621,6621,6621,6621,7304,6967,6376,7143,7023,3380,539,7904,7270,6349,4079,7249,7247,8400,8201,8198,8199,8201,377,6066,8576,8568,2635,2635,553,544,1462,1462,7680,6763,3449,5718,5718,6381,9189,8082,8443,8253,9312,7278,9300,9864,8995,7266,10056,9573,7585,7585,9304,9560,9560,9577,9577,8542,8542,8542,10265,8168,6925,8986,10026,8782,10572,10272,4080,9148,9561,10836,9076,8451,9949,381) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC