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,5897,6580,6548,6637,6638,3864,1787,1784,1775,1783,6000,3913,1786,1772,1805,1796,6977,1785,6700,5576,1351,6977,6785,4226,6700,5046,6691,6609,834,1793,5371,7214,6102,6642,714,3217,2573,6618,1609,6623,6143,6332,6371,6149,6221,5430,5756,313,2995,6215,1210,6443,1487,2917,640,4419,6636,340,267,754,6486,7131,7873,947,1663,2270,2135,3882,2446,1783,8480,8561,8559,8771,52,8910,7837,7899,7772,7150,7167,4464,3860,9309,9406,4395,6104,2117,4834,8739,9983,4029,7962,2632,7103,9833,9300,8062,7143,7869,10865,11485,8545,11271,11782,9659,916,8271,2122,6817,6693,6583,3883,7244,1774,6633,7374,5518,6138,7928,7903,6691,6693,5402,5402,9173,6386,6993,7238,8220,3465,5718,7580,6570,546,7636,3891,3892,3896,4714,3889,3893,8489,5810,2506,8993,8994,8306,8886,8995,4769,7853,56,7261,7266,7647,6569,7106,7932,7105,8406,7674,8065,8055,7070,7255,7654,7122,8201,7923,7594,7594,7421,7421,7498,7498,7498,7498,7498,7498,7012,7012,1806,1811,4671,5947,4558,4558,2736,4899,1402,6113,9129,4512,6129,6264,9802,9909,9342,8828,10060,1097,9771,9931,10161,9043,10126,2897,1953,8879,9044,9993,10166,2830,6774,9093,9843,10125,10237,10282,10297,3465,8973,8613,9987,4156,9336,2164,6953,3647,7576,10269,10468,10280,10183,10537,4906,9934,8830,9557,9786,7602,9342,7917,6648,9789,2164,10098,156,9329,10735,9497,10080,8763,10320,10481,10886,9910,10532,11026,10892,11099,11102,10133,8967,10649,11078,934,11140,11097,11133,11095,7602,11233,8976,10808,1097,3282,6119,10093,675,5792,9283,11260,11166,130,367,11198,9235,11396,9193,11141,7148,5454,11479,10094,11352,11359,11442,7613,11447,9402,10091,10056,2399,9378,5484,10132,5025,2261,10131,1458,2079,9577,7898,3105,8439,10346,10272,7898,8087,8055,10212,10060,7788,10211,10116,5913,1097,7910,5810,7869,10736,1458,10707,8541,10649,4659,10296,1308,8290,2458,5567,5402,7828,2913,7775,916,9934,10986,6700,6616,8941,8942,2122,207,8497,8497,9476,9476,6613,3070,8292,8292,6615,10281,10281,6733,6579,11364,1185,984,8973,9543,7175,6103,10466,10412,359,8358,10526,9879,9959,7773,10000,10126,10481,7953,6209,9949,9186,1308,10269,10494,9649,2447,10302,6870,9300,10873,9547,4079,2092,4092,7777,1016,3908,8144,6622,6832,7374,6903,1461,9195,5245,4144,7670,9277,8514,7775,8910,7981,659,9641,2160,4432,4079,6315,9274,5564,5314,1645,5020,4076,5093,6104,6845,9925,9405,8514,8910,9338,9406,6622,7909,30,10476,9798,9929,9930,6117,7581,10149,8543,9648,9961,9634,6857,10543,7872,2530,93,10878,4125,9543,9235,9193,446,9959,6849,9402,11041,9325,9910,10063,11122,9786,9789,10080,10412,4923,4795,10081,11220,11361,10093,9524,9557,7888,11489,11646,5193,10986,10092,10094,9096,10190) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC