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,5923,7499,4742,7272,7368,7122,8406,8406,7105,7304,5897,2041,7388,10572,10572,10211,10211,7387,7421,7385,7491,7459,7470,7437,7565,7565,7387,7387,7561,7548,8223,7219,7491,7537,1499,659,659,6714,6714,7422,7422,7422,7472,7385,7385,7385,7385,7385,8211,9132,6348,8269,7656,9053,7660,7658,7091,9813,7077,8044,7661,8721,7662,7287,1770,1767,7642,4720,2627,6809,6718,3913,4146,1662,2520,7391,7391,7493,2122,3874,8290,7077,2520,7388,7437,7334,8496,7159,7385,7484,9024,9024,9024,8650,1366,7445,7089,7111,7674,3860,6644,7112,8040,8082,7069,7069,8407,8407,1666,1265,8268,8268,7661,323,9856,7385,7385,7385,10077,9897,2520,4598,3913,5516,5732,6557,4411,5322,6255,5331,320,5988,4046,4199,4452,3201,520,4574,585,4432,3933,3440,4987,5020,6863,4233,2025,4805,6553,840,1490,6554,5647,6552,4337,5693,6880,6243,5573,2703,2397,4918,2324,6556,4209,7350,8435,2546,8463,6968,368,7985,7986,535,8832,8782,4037,6869,4798,7592,8917,8034,8240,8948,2913,7599,7521,7485,2261,3201,3888,3895,3892,3885,3891,3889,8272,3883,5609,6493,9300,8877,8274,7294,8839,9072,2737,1173,6174,6905,9437,1487,9438,6650,4121,8257,9439,9373,9459,6100,5,4708,3990,450,539,7491,7247,7241,7241,7069,7467,7467,7506,7506,7437,7420,9019,9019,9019,9024,7457,7457,7457,7457,7457,7457,8861,7491,7389,6561,6561,6561,7371,10203,4769,10296,11019,10292,6718,10992,207,10310,6406,11269,10940,11247,11118,10466,9716,10408,10490,9706,9718,11254,6603,9708,11051,11427,9690,10695,860,11263,11295,6361,11053,11467,10438,9384,10730,9936,6443,6271,11731,10721,9042,8962,11727,8685,11792,7219,365,374,7806,6586,3823,6003,10176,8389,9767,8,8168,10466,8489,9031,2506,9985,7869,1049,10742,10033,386,6270,8881,8880,10098,381,11121,384,3894,3895,3897,8607,11098,11239,8290,7986,11301,3888,7987,11022,3892,3891,3889,11295,3890,3884,11299,6261,8272,3883,4300,4292,4294,4298,4301,4305,1770,4293,1765,1767,1768,1769,1766,11319,3881,3882,11317,6520,368,11392,7431,9024,8528,1666,8496,1765,7537,11319,10758,11069,9590,8596,11407,5003,8290) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC