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,2041,6984,6786,7070,6962,5572,6414,2992,7162,6970,1268,6691,3941,778,2294,1776,5927,4996,4568,1774,7270,7153,7374,4432,6584,6664,7285,322,7277,3455,5020,7842,1325,3162,7834,7261,7287,7287,7287,7287,7287,7287,7287,7287,8050,6270,6954,2029,1645,8063,6718,7834,698,7836,6349,6365,217,6620,7208,8938,7493,7563,7563,9027,2520,8782,7654,8358,6980,9949,8864,6774,6715,6715,10208,10208,9,9,8299,1571,4996,1953,8830,1624,7837,1571,10891,9866,8047,5066,5056,10717,5064,5053,6738,7139,7149,6714,7215,6006,5995,7605,3337,7213,7966,6183,7218,6003,6583,6131,6402,6484,6613,7725,6599,840,6367,6004,7708,9386,7105,9359,9986,6367,7646,1785,9618,10060,7251,7089,7743,7505,7723,10039,10468,5883,8781,10548,6768,9993,365,3936,9303,9350,9049,11215,11215,11168,11168,10810,10810,8292,10940) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC