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,1645,525,550,601,933,1589,2390,1070,3264,5848,3557,3828,808,3302,5305,5552,2876,4218,529,3610,3392,4454,3048,3803,1928,1927,6950,6122,5915,6350,713,5256,3754,663,1200,1313,358,6169,6162,2576,6588,6590,1000,1453,725,6159,4735,3216,6645,6168,510,1250,6160,4512,2997,2873,2170,4038,2723,2934,1444,2573,6772,3850,6660,1038,6766,2025,4061,1766,3037,5286,5995,1215,4100,3860,6167,924,6740,7238,5927,6190,511,7213,6979,801,958,6270,372,6004,7872,6349,7828,464,2897,7912,1151,408,3647,7861,5965,7994,223,6593,7599,7605,4395,6364,4320,7982,4535,8626,5959,8947,7874,8969,2253,9014,5763,8281,8991,5952,7128,7148,8836,6891,7146,7773,8108,1766,1768,2932,1351,5996,3860,6366,7840,6189,7570,7762,3913,6726,8109,2889,7635,8142,5551,4986,8390,7635,7020,8297,7840,8109,3029,7879,1770,1765,8815,8730,8183,9030,7203,5995,1210,3850,7918,7238,6365,6350,6660,4936,7878,6982,7795,7787,1200,7718,5915,2183,6983,3892,7592,7837,7546,7143,1603,947,8095,7992,6589,933,3519,7869,7995,8096,7938,6172,6159,8223,7240,6605,8093,8271,8226,8611,8555,3046,6135,8220,6766,1200,7882,6766,1029,7238,6740,6001,8220,3644,3702,2029,7871,2006,6366,2615,3754,7878,8481,2063,5884,8231,1453,8390,7917,7992,217,7928,6810,6770,3515,3889,8111,3882,4769,4724,3895,3888,5927,6971,1462,8436,7012,3884,6450,8390,368,8003,5922,3896,6797,3967,6004,6983,4297,4299,4302,9028,1265,6578,8355,7205,3581,9049,7160,8661,8490,8917,8885,6490,6209,7912,9502,7576,5371,6190,358,6833,6162,2635,52,6312,801,6843,3966,6794,6588,464,6644,6366,6135,6130,6168,6155,6177,6177,5881,2658,7238,7238,3262,2520,3550,6740,6349,7238,7238,8220,4597,6813,7775,3395,714,714,6766,7783,7783,2029,8143,4801,4801,217,8109,2889,4986,8147,6971,6068,8390,7681,8816,4422,8129,567,8851,6726,5551,8147,6631,6631,6631,1296,6583,6583,8139,4834,7840,6678,7878,6971,8434,51,8761,9030,5947,5947,9546,463,3197,2156,8554,5962,7872,6810,8292,9394,9504,9525,4338,7023,7632,7815,9647,6172,9379,9732,8389,1307,7966,18,9046,2384,2889,41,9897,9758,8110,9864,9814,8995,8714,9754,9532,9468,9467,9506,7222,10174,10085,123,10173,10143,10035,2171,10040,8434,10054,9972,8112) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC