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,6102,4923,6117,539,6857,6408,1242,4227,7388,7483,947,6740,7238,1591,6264,6131,714,7209,1624,7219,4362,2677,6261,5251,7922,7539,3704,6658,6004,7576,7872,8292,6003,6104,6691,3368,6740,7304,6586,4349,4762,7975,3351,24,2419,7019,223,7759,1653,6890,2117,6650,6861,1773,8010,1586,1774,3913,30,1774,7238,1774,7761,743,7872,743,1127,2118,3609,1127,7126,3609,4860,7126,2192,7547,7896,5327,2265,8809,6710,3429,3159,2265,7576,5536,6695,5536,6613,5536,6579,5435,5536,8220,1772,9000,1298,6861,6282,9030,7977,7615,1159,3376,3327,8900,5188,7830,36,8284,9081,6858,7929,6832,9346,9346,6171,8103,8193,7640,2554,8193,6809,9811,6591,7138,6809,444,8827,9338,4320,7718,6713,8628,261,8628,5046,10342,8358,6981,8305,8195,8521,10056,7839,8140,7839,7304,8140,7614,3698,8915,7156,8915,11331,8617,1416,9604,6775,9803,8620,9476,1250,8620,9476,11491,6980,8927,9648,10734,10892,11703,8620,4056,11670,1265,675,7143,1453,7833,7903,7304,5477,2389,7238,6845,8005,8220,6315,1402,5688,1536,7992,1327,8489,3644,9300,8948,7593,906,7869,1349,5235,5810,1173,2417,7219,4607,7451,5907,5907,7815,7815,7815,8860,8860,8860,8860,8860,8860,4100,4513,6595,1872,6102,566,7138,2590,1812,5544,7833,4131,2658,4983,7156,6635,2261,7016,8031,4220,2393,617,8442,7250,7250,7840,2761,7064,675,1487,3392,3803,5094,7069,8902,8900,8514,4872,9036,4349,7998,7654,8175,4510,3715,9220,9214,7985,2393,9278,9279,9049,6154,9258,9258,7563,7563,9406,9377,9444,9444,9527,9363,5545,7655,7655,7655,6774,6774,9614,6686,9730,9258,9800,9656,4800,4405,4701,9078,7303,7026,4995,576,4639,4406,5995,4349,7840,7775,8547,4405,223,3913,3878,3878,6953,3646,8306,7022,1215,9479,5763,8388,450,450,450,10121,9378,9378,9378,9378,9378,6548,10228,8686,10228,10228,450,10296,1953,10309,4923,7977,6775,6714,10248,10698,10438,2157,10631,3913,10676,10578,2356,4716,587,9231,7048,3337,2035,11322,11322,3327,8964,6197,9534,8003,6332,8278,10727,10563,10559,9231,10646,10812,9892,10044,10426,10487,6212,7843,10417,10489,7844,7845,3890,10545,10389,7196,384,10381,6443,10520,8579,10040,6517,6216,8242,10925,7704,10923,10729,10560,10199,10558,10557,10200,3894,1764,10823,8882,11080,4302,8274,8250,11091,4512,2555,8696,1086,4316,5003,10318,2039,4774,9386,2998,10486,6535,9493,11153,7299,10045,6143,10935,9903,10828,4827,5208,4645,9418,6986,10513,11106,10820,11198,11246,11067,11219,11230,10483,10924,11068,11071,8827,11069,11254,11296,11270,10921,11238,10931,11109,11306,6648,10930,6423,10642,4299,9591,11048,9888,2605,10923,10922,8002,10644,10561,7762,4293,11156,4287,11317,8596,7676,10201,11320,10645,11321,11158,6521,10562,10647,10643,7987,3070,6354,11008,9535,6689,3892,3071,3073,2643,10937,11324,11152,9147,11432,11467,11479,4146,10426,228,4199,7910,11089,4639,10434,2253,10720,5435,9863,9244,10297,10060,10987,11163,10830,501,9405,10314,11342,9846,11424,10687,5314,7828,9715,10707,4979,6740,6977,11214,5435,10987,587,10682,11039,8563,10670,9863,1044,11365,11257,8139,2056,2069,3327,9791,10687,10817,3702,11399,11215,11400,11298,8191,1296,10731,6367,9946,7048,11410,4769,7374,11497,1358,1359,11880,1983,9830,6952,6433,4985,51,2567,10063,892,6801,10060,10060,10060,10060,130,10240,10227,10649,10940,11215,4079,4079) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC