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,5996,637,1402,1998,6620,2658,2682,6780,5907,5371,3860,240,409,698,1029,1248,1410,6103,6135,4553,176,5175,5252,6122,5331,6780,28,566,4769,7112,4234,993,5947,8213,8213,1461,1461,7840,3428,3428,1350,1350,9367,9367,4178,7903,3885,7143,7143,538,546,529,543,533,544,7833,547,520,7976,541,528,6042,531,532,536,573,6646,7966,6610,550,7815,4607,4906,524,553,4716,540,1726,6394,8081,8080,7270,546,525,9132,9132,548,8917,8447,7576,7576,7576,10169,3702,834,3029,6715,5995,1492,6631,3029,4834,4437,7635,7953,1296,2635,4438,7995,7840,5782,6844,1357,3863,5380,5567,5769,7641,4769,3823,2041,7879,567,6843,5784,1526,6658,8358,1371,7840,8690,7962,7953,1153,3913,4405,6965,6966,6110,6969,6968,7805,6970,3029,4944,6383,8349,8523,8352,8357,8354,8523,8356,6969,6609,6815,4146,1052,8839,4460,9017,6808,5719,9851,9620,6743,6377,653,7286,7286,8575,7196,7285,7162,7099,8656,8828,7191,8141,4774,4720,7105,5995,5995,7913,8220,6740,6740,8547,2627,2627,7239,4860,1010,8636,5927,8576,6774,8771,6774,4639,4639,4639,2288,3598,6175,5371,5956,6700,9340,6971,6691,6691,104,104,6477,8622,8371,6561,6561,8379,8379,8428,9482,9482,4683,4683,6977,6977,6693,9338,9338,9338,9338,10211,10211,10211,10496,10496,10292,9797,9340,9998,10078,6658,6658,9543,9543,8206,1662,8168,7286,9299,9195,5421,840,8685,6726,4769,8668,8793,8668,8793,7910,7205,7761,8222,7761,8222,7130,3989,7130,3989,7130,3989,8780,8816,1993,6367,8520,6548,6715,924,8388,5717,2399,4769,104,1142,240,8970,6700,6631,9215,840,6006,9229,5484,1591,6264,2644,7144,8821,5052,6774,5371,217,9390,8833,9281,3327,5770,2253,8515,7838,2029,9468,9027,9322,2117,1371,6131,9162,9513,2006,7861,4435,9538,2005,2085,1052,4395,7923,7976,1242,2989,9480,7992,6642,9524,9479,6103,6004,906,9603,3428,9629,317,754,9306,6691,4079,8685,8815,8814,8826,7576,9704,3598,156,1153,9678,8659,9559,9546,9760,1912,3236,6905,4913,7599,9390,9480,4154,9754,6102,2342,8508,2467,6176,9763,9770,9783,120,6977,9782,6602,9014,7640,9344,4563,6652,9762,6623,8352,9812,2843,9830,8685,6841,8292,8544,9006,9879,9865,9866,207,9872,9918,4216,5419,9926,6819,4320,4900,5908,6767,6181,6181,6181,6181,6181,7090,7090,7090,7090,7587,7604,8154,7165,6181,9375,7206,10970,1667,850,10510,7283,1257,7175,11133,6650,8882,11052,6794,6769,11102,10892,10291,6459,5913,6042,9367,9368,10522,4473,9028,10671,10829,10546,9738,2856,7080,9816,7584,10185,9405,8939,8574,9710,9258,10023,11222,11101,11286,3913,7088,8771,6806,8419,11315,8689,11291,11331,10188,11351,8520,11300,11345,10767,8822,9083,11344,9669,7273,9305,6076,9670,9671,10839,8092,11347,11409,11449,9671,9954,10672,7046,9955,984,10686,10761,10220,10675,10767,2085,10869,10947,5922,3346,2470,393,10250,2627,11399,10250,10669,9858,8970,5454,11082,1116,8648) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC