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,5995,9125,7084,8648,5267,4349,7982,8279,5872,4985,2029,4983,10061,7640,7249,9674,2261,7970,4566,10267,1142,8046,7374,10543,8209,10121,10547,10236,10674,8087,10814,10649,10269,10228,10978,10021,10976,9094,9762,10281,8069,576,10566,10609,5913,11127,11024,1371,10768,9926,6119,11201,8290,11200,2897,11344,3908,6103,11272,11134,10404,11232,10505,7937,9083,8763,11376,8713,7670,11468,3646,11225,10707,4979,6740,6977,11214,5435,10987,587,11039,8563,10670,9863,3957,1044,11365,11257,8139,2056,2069,3327,9791,10687,10817,3702,11399,11215,11400,11298,8191,1296,10731,6367,9946,7048,11410,4769,7374,11497,1358,1359,11880,1983,9888,9850,11227,10681,11227,10681,11286,4800,7385,11286,11286,9946,5988,10687,10481,10677,11400,11497,10304,6367,10678,906,4401,906,9603,10676,11403,8970,4144,4923,10940,6733,11263,11432,10703,11799,11637,10717,10522,5134,721,6642,11399,11024,6371,6175,2467,6151,1738,4289,7741,5691,5904,6526,1462,6212,7913,6742,391,3885,4512,8700,5386,6953,2164,8388,2455,4701,8780,4769,9391,3515,1116,8247,8980,4424,6832,735,8896,2989,222,7178,6181,3036,223,8899,2389,8242,5567,7186,6444,961,6377,452,6523,9692,6652,8825,7189,9559,9631,7764,8279,8816,2778,9996,7762,7570,4437,9949,9970,9338,9792,9880,1245,7725,9763,9665,9616,1770,9950,9492,52,1765,7,9906,9951,1771,9480,9880,10219,6115,9424,3913,10102,10199,9835,5484,8432,450,10154,8257,8727,1250,9669,9782,2780,4701,10188,10110,7751,8151,4639,10155,7972,7973,9670,9892,10155,961,9671,9033,9131,8822,9672,9673,5175,576,9168,6119,9473,6003,1766,4500,5769,4349,2605,4338,979,5678,10156,151,9473,4800,9720,3081,9722,4901,10281,2467,10071,8566,8967,10655,11097,10187,10991,11025,11116,11105,11135,10974,11104,9,4424,11052,11072,10554,9959,8173,10886,11092,6181,7205,2079,6820,8507,11306,10550,1774,7048,5531,4510,11118,11260,8970,10718,2169,11045,10483,11053,11279,11482,8565,8721,2056,11099,11449,10941,1887,6,10947,11283,11253,6267,6118,10133,8946,9846,3327,7888,961,11638,11886,10477,11622,11328,9390,11908,1265,11853,3105,3081) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC