thisMySQL 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,1777,1787,4774,6774,6000,6693,2399,7008,5872,6953,5912,223,3702,6547,5046,7159,6239,7301,6868,5897,6548,1268,6691,3941,2294,1776,5927,4996,4568,1774,7270,7217,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,7304,5996,3860,6430,6561,368,1785,1785,3493,3493,3493,3493,1811,7391,1461,4061,6631,7493,7437,7389,1732,7467,4996,4999,5872,6619,1571,6275,4991,4991,6586,6715,6715,6715,3555,3555,3555,3555,3555,6295,6295,6295,3105,6402,6402,6402,6548,6400,6400,6400,6400,6400,2005,6173,1313,6563,6978,7024,6189,1407,1441,6181,6546,1165,4450,3073,6654,3115,6204,7748,360,444,3041,6732,8118,4986,5635,8358,7077,8222,8738,8765,3070,1537,7835,9052,435,8439,7304,6870,8526,8526,8526,8048,10010,10377,10591,10592,10467,10587,10692,9300,8783,1215,4046,5912,3702,3850,8027,8222,6855,6855,7388,7388,7561,7561,4050,7388,3162,1073,1073,7485,7485,7484,7484,7484,7484,7484,7484,7484,7484,7484,7484,5996,526,2056,391,7270,3860,4199,3896,1458,7300,6768,7300,6962,7286,4544,4860,7899,545,550,548,539,4684,3554,3554,1398,7175,7032,1662,549,6477,525,2706,551,864,1366,8356,8530,546,8880,979,6394,6842,8212,7472,9030,578,547,2847,3337,1777,7178,8438,4500,4500,9076,9778,9494,9494,9791,9745,9858,8575,8575,6648,9488,9879,6583,6583,8434,8434,9547,9547,10638,6579,8063,8833,10731,8428,9853,9785,6400,10695,4500,1783,8781,6667,3702,3702,6843,6843,6004,6548,6004,9300,6715,8922,9296,1927,6151,8840,8214,6700,8699,6286,1782,1774,1782,1774,1782,1774,6611,7893,842,4405,1927,4706,4224,120,9970,6584,10001,28,1768,10043,10043,10043,10043,10043,6402,7104,7975,8064,7290,7290,8639,8791,8568,8568,1151,9284,9284,8292,8292,8292,7241,3499,6718,6691,3455,5927,3898,6751,7705,7703,6715,3336,3702,7048,6587,3337,3337,6584,6584,6367,587,587,525,525,6604,6604,6612,8583,7870,8618,6503,8586,7546,1770,673,8520,2605,9030,9030,1402,1402,9084,8947,840,8826,8730,8814,9104,3598,9060,9319,7295,2520,8815,6700,6700,8949,6631,7273,8922,8922,4598,8326,7270,7270,7374,7374,7374,6656,4121,4121,8154,7639,1746,1557,3073,6688,3071,8824,7670,6138,6138,1653,8948,8947,6010,3913,3913,7833,9950,3913,9879,9614,9959,9770,9547,9752,9868,10080,9939,9933,8948,9991,9338,5269,6691,8823,8823,5936,10291,7639,3346,8828,9771,7993,698,7359,10312,10273,2989,8547,7149,4659,7115,7654,8306,7252,8092,7253,2117,9701,4563,2658,6264,9538,2761,2467,7940,5912,4399,8629,7946,4566,5193,5236,4656,6986,1327,8031,4061,4405,6560,6559,10060,9751,9758,9221,9750,7106,8395,10211,10233,7254,1349,10227,10237,9257,8391,10244,10236,9132,1521,8089,9353,7017,10245,10226,10315,9935,773,8777,10359,2261,10541,10550,10587,10567,10588,10586,2079,10666,7121,10524,7716,9870,10743,10807,9831,8211,7932,10820,10239,3542,5763,3715,7895,10976,7125,11021,11025,9259,7125,10977,7087,10904,7252,9900,10749,8047,10899,223,7265,10747,11126,10765,6845,11115,8030,6104,6870,11122,8741,2294,1253,5545,5339,1347,5817,3080,4258,7883,4460,608,2933,6858,7126,10246,10869,1699,1830,8500,8668,8206,4395,7920,7839,10350,10692,6832,10690,7280,11679,9206,10659,11540,9959,11558,11785,7792,11402,11496,7778,9889,10949,10366,10585,11528,8891,10702,6,11704,8477,10027,10863,10212,8516,8892,7159,9767,9770,9770,6357,6209,6205,8833,1380,6715,6548,8281,3913,8255,9300,5995,4671,6865,6569,5769,8710,8710,8710,9340,5484,3327,7211,5788,6892,2467,2349,8137,9946,4435,3336,3336,9791,9043,9915,8828,9889,10379,10818,11102,7926,9318,9762,653,10604,4805,8292,7042,11085,10336,3511,11216,11568,10107,217,2786,7374,5236,4969,9910,10836,11121,11044,10626,9251,8560,10512,10114,11439,9984,11140,11353,5279,10578) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC