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,6658,1358,8,6984,6786,7070,6962,5572,6414,2992,7162,7217,6970,2085,6658,524,6595,7238,546,6658,857,5742,5733,4716,4437,3863,550,8220,6381,553,7539,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,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,7879,567,6621,6843,5784,1526,6658,8358,1371,7840,8690,7962,7953,1153,3913,4405,3863,6445,3105,6667,5435,1993,3865,1357,6775,1327,7143,7143,1738,3582,6642,7837,7837,6103,6103,5799,4860,5995,5995,8109,3647,3647,2029,2029,7995,4395,4395,7037,7239,867,867,867,1645,2006,1215,6971,6971,8230,8143,2729,2729,2729,3913,2992,9306,9976,9976,9976,9976,9976,5923,7499,4742,7272,7368,7501,7122,8406,8406,7105,7304,5897,7388,10572,10572,10211,10211,1779,7654,7155,7083,7083,8793,8544,8193,6381,7307,7124,323,7270,6004,6740,7238,8220,6715,7976,7076,8738,6569,182,8541,8922,6843,3647,2331,6700,659,9338,9612,186,6371,6804,501,4234,7304,3989,1462,3247,4860,2594,6740,7932,4796,7238,3830,1167,8220,7602,947,1126,6010,6971,4395,6710,5371,4512,3913,8241,8334,8337,8336,7022,8248,6751,7910,8019,8323,9430,2171,987,987,1604,6727,1462,6820,993,4918,6578,226,520,7966,3863,1981,1296,1296,1462,1981,5769,7849,1988,1324,6583,6561,8115,8115,9169,9169,5484,6004,7979,6174,6740,7238,7472,8220,4769,7840,6003,7879,7878,7592,3913,7554,7754,7755,7756,8509,7539,446,7927,7445,9359,6316,1981,1981,1981) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC