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,7292,7247,7561,7101,7387,7241,7472,7251,7422,7422,7387,7421,7491,7459,7470,7437,7565,7565,7387,7387,7561,7501,7548,8223,7086,7080,7119,3874,2179,1324,7108,7292,7292,7096,8050,7104,8061,7298,7642,8060,7297,1366,7106,1366,7107,7122,6740,7238,8220,7124,8431,7607,7094,8470,7108,7077,7293,8443,7250,7655,7288,8033,7574,8444,9300,8469,8768,8395,7932,4801,7971,7674,7105,7082,8472,8740,8424,8568,8445,10056,7262,7485,8423,8063,1215,8401,8477,8423,8866,7480,7451,6561,7607,7388,7437,7334,8496,7159,7501,7484,9024,9024,9024,8650,7120,7078,1511,7456,7421,7563,7421,7506,7493,7560,7496,8865,6042,6740,4798,526,3849,3849,3849,7286,7286,528,541,8763,8763,553,531,540,543,1029,524,2776,2776,4510,4510,4788,7383,7383,7219,7491,7537,1499,659,659,6714,6714,7501,7501,7422,7422,7422,7472,8211,9132,6348,8269,7656,9053,7660,7658,7091,9813,7077,8044,7661,8721,7662,7287,2627,2627,8859,8859,8859,8859,9049,6276,1973,8823,8525,8823,8525,8823,8525,8823,8525,8823,8525,8823,8525,8823,8525,8859,7539,1084,427,1084,427,1084,427,1591,9524,1591,9524,1358,3863,9524,8563,7912,9862,9022,1366,7445,7089,7111,7674,3860,6644,7112,8040,8082,7069,7069,8407,8407,1666,1265,8268,8268,7661,7501,7501,323,9856,10077,9897,2520,9794,9797,993,8563,7304,7304,9300,9019,10272,10272,10272,10077,10077,7086,8735,8055,3029,8368,7096,8473,9160,7071,9187,8056,3890,7258,7089,7939,10670,4305,7048,9925,8527,7563,10886,6239,10539,3863,3863,7368,3327,2349,10010,11053,11053,5435,10339,10916,3863,10631,7456,10687,10687,11023,10687,3327,10844,9863,10687,9863,11380,10579,10211,9021,10940,2447,10940,2447,10526,9300,4985,1993,6740,11380,8220,10278,4639,10056,10228,11264,9865,10940,8358,6367,11690,11366,223,9946,11662,3913,1765,6809,10687,10687,11263,2871,11263,2871,6731,10932,9888,9850,11227,10681,11227,10681,11286,4800,11286,10682,11286,10682,9865,8358,11438,2913,8292,11261,10987,10731,7159,11497,2913,8257,3327,7398,11434,11442,9830,11308) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC