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,6564,6570,6571,6576,834,734,1057,2398,2672,3035,5362,1350,1906,6069,1907,971,2329,4005,405,1163,5460,1532,6574,396,1718,6566,6565,6735,6576,6572,2360,1856,6166,567,6562,223,501,5322,6576,5956,6583,2635,6565,6678,6576,6569,6564,6574,8033,7094,7998,7096,7100,7082,3830,5148,7252,186,1662,7840,7840,7879,7878,7160,8095,8095,6740,7238,7238,8094,8220,7649,1537,1537,8109,8903,6726,6971,8816,8230,2374,9030,9321,6562,6570,6735,6669,6883,6902,6571,6901,6567,6990,6993,446,947,3189,6659,4598,1533,4087,4731,2451,4519,3803,4872,4645,3872,5331,223,5251,4690,1181,1121,4125,6669,4931,5576,1351,743,4598,3048,4599,470,645,4008,6564,6565,6572,6575,1461,1593,6562,3797,4165,1092,744,3645,7063,6998,467,7119,7095,4164,1600,6521,4423,7089,7093,4964,6527,1474,7121,6522,1098,6504,6735,7115,6576,7115,6902,7125,7029,6503,6901,7047,6523,6996,7223,7235,7001,7029,1460,2456,7233,6675,3418,7013,652,2917,2696,7112,2956,1425,7249,7276,341,3447,943,1869,7231,3760,2446,3454,7234,2456,2454,3610,1893,1765,944,7034,2151,1829,7089,2974,6588,7272,7271,6168,7272,6350,7271,7273,3417,7296,2334,6530,2671,7280,2653,5371,6365,7241,6676,7258,6993,2876,7057,7106,397,4021,6678,6726,6518,6512,6371,726,6528,6530,6529,6531,7691,7689,4305,860,7692,650,7686,7699,7681,4224,6530,313,810,7753,272,7275,5066,7844,3784,7661,7670,7602,7662,7108,7084,7265,7268,7170,7168,7599,1771,1767,1207,1769,1765,1768,6669,4860,446,501,4178,5996,7548,5371,7840,7878,7879,7635,4834,7787,3850,2009,5421,1453,850,6563,3913,8526,6726,8903,8816,8814,9030,223,463,9085,8094,8095,8488,9052,223,6740,7238,8220,9379,9321,1738,6809,9422,9198,8241,7374,186,7681,1215,3760,231,6942,1869,2446,3454,3787,1738,501,1461,1228,836,3657,6570,802,1055,1160,1568,943,772,743,1441,1277,1727,1915,7864,7858,6852,2592,6827,1110,6845,7856,7758,3590,7221,3844,5623,5765,2654,3303,7034,1577,1822,2685,463,7232,3181,6853,219,5509,8488,1416,2864,3844,3418,360,8094,944,1522,2653,243,341,2469,1575,2334,3482,2956,7803,3788,1313,2571,4219,3989,2723,5148,2671,3843,3304,319,470,3417,1829,3584,7779,4722,5552,4021,986,3351,3778,6643,5735,7784,6849,5170,6570,8616,5070,2454,2706,1893,6573,2456,6562,652,8707,6574,6571,6567,6998,8684,7224,650,7031,7229,7232,7221,6675,7227,3540,6676,5088,6564,444,7063,6563,6575,6565,6576,6883,6574,6735,7228,6678,6882,7013,7690,3415,1856,6996,7757,7687,6999,6997,7688,8726,6992,7689,8147,6990,7223,7231,6994,7681,8148,7001,7059,7235,7225,6736,7057,7692,8993,6885,7684,7685,6669,7052,7234,6902,7682,7683,7226,7699,7233,7691,8919,7237,9003,6007,1834,8994,2151,6676,9002,9068,6860,8997,8996,8814) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC