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,7094,7115,7384,7111,7082,7069,7268,7100,7152,7125,7075,7087,8053,7112,7121,7115,8456,7272,7089,7119,7261,7281,7072,7112,7112,7392,7444,7092,7506,7286,7286,7286,7286,6408,1242,4227,7388,7483,3957,947,6740,7238,1591,6264,6131,714,7209,1624,7219,4362,2677,6261,5251,7922,3704,6658,6004,7576,7872,8292,6003,6104,6691,7238,546,6658,857,5742,5733,4716,4437,2041,3863,550,8220,6381,553,529,7149,8440,532,539,323,313,397,860,6386,549,8542,5853,6769,526,7704,538,528,525,7704,5853,540,551,864,544,1730,545,531,543,391,535,541,387,536,382,1271,4769,376,524,377,365,376,374,6270,384,2856,8787,368,6066,6082,385,394,6197,8858,372,6076,317,3913,317,3913,6382,6523,8165,375,6526,8496,3879,7588,8989,8530,8160,1380,3823,6854,6391,8159,8157,7300,7605,4701,8785,6144,9437,9435,8244,9438,8340,3879,8699,8874,5770,8316,9146,9414,9409,8700,8245,9436,9425,9408,9184,8883,8329,8247,9182,9415,8332,8318,8324,8326,8319,8241,9592,9183,9428,8248,9431,9894,9150,9143,9534,9190,9908,10045,6768,9300,7632,9154,6396,4501,10056,9792,9891,9155,9156,9217,10202,9156,10198,9854,9217,9502,10193,9502,10193,10197,10195,9147,8333,8335,10099,10102,9151,8330,10218,10147,10333,10322,10323,10217,9412,10102,10336,10332,10334,10101,10331,10100,10324,10140,9433,10213,4094,6787,4095,1385,7350,7350,7350,7350,7350,1887,7419,7419,7419,5898,5898,5439,7095,4503,4503,4503,7388,7388,1307,1307,9442,9189,9508,9508,9508,7541,7541,7541,7747,9995,9508,9978,10272,9659,8449,10024,8892,8468,8892,8468,10026,9189,8425,8386,8783,10890,8783,10614,9229,5988,9581,10575,9649,10357,11187,10890,11712,10890,11712,10400,11711,10400,11711,6174,6740,7238,7472,8220,4769,7840,6003,7879,7878,7592,3913,7554,7754,7755,7756,8509,446,7927,7445,2041,9359,6316,8567,3702,3913,7421,3823,6276,1973,8823,8525,8823,8525,8823,8525,8823,8525,8823,8525,8823,8525,8823,8525,8859,1084,427,1084,427,1084,427,7385,7385,7385,7385,7385,7385,7385,7385,1591,9524,1591,9524,1358,3863,9524,8563,7912,9862,7472,7986,10272,10489,10488,6545,6425,6424,10486,6421,8638,10882,4224,4224,10667,8716,3979,11514,7655,7388) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC