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,549,526,548,535,546,6042,536,545,537,542,543,531,551,533,553,532,524,525,538,3225,3226,3881,3896,3887,3883,6493,539,544,541,528,529,550,554,573,4716,6740,529,528,538,539,573,553,526,531,525,544,524,537,532,542,543,554,533,551,2324,536,9016,7251,9543,9543,6631,548,537,544,545,528,6042,538,554,532,7703,553,546,550,3803,6809,548,1741,6845,6223,546,6042,6496,5763,3094,7616,1917,7751,2729,3878,5228,5246,5328,4103,6397,3872,2451,6218,543,1764,7987,7903,7972,7973,2677,1145,8117,8140,7833,1126,5143,2776,28,1398,923,1234,3189,4872,5089,5094,1520,8222,7861,5112,1207,956,3392,6901,2915,6902,7047,6902,3048,537,539,8306,7986,6124,4144,7208,4785,5459,5430,28,947,7776,906,466,1370,1741,7029,7047,5992,7047,1318,645,423,1092,8252,532,1600,8888,4855,4855,9017,545,7047,8542,5914,6034,7829,7029,7029,9021,7592,3878,7681,7681,6552,9554,9547,9547,9007,9007,9614,9777,9254,7710,9675,9880,6222,6499,6214,6220,6218,6215,6501,6216,6498,6497,6223,6212,9965,9254,10265,532,9648,10258,10212,10212,57,28,9487,10610,10610,11089,10622,11089,10622,533,3884,3889,3890,6493,3892,3883,3893,6691,524,525,539,545,528,6042,546,544,541,538,532,535,547,553,550,549,537,551,7085,7670,7245,7101,7656,8206,7646,7666,7657,1250,4774,7265,545,548,549,550,7020,547,528,538,7290,529,7840,4639,947,7938,223,4801,542,7113,3882,3897,3885,659,374,310,389,546,3893,553,964,1242,524,6611,6611,1151,545,1167,6209,4076,8289,7572,1810,7124,6405,6408,6408,821,7083,8198,820,8199,892,892,8438,8363,7646,7646,7122,7124,7107,1500,7094,801,1265,2145,2145,915,9274,5936,8171,7666,7666,7666,1656,545,6382,6390,6527,6521,6261,7631,6212,726,510,542,528,512,6869,7770,3515,6513,526,6198,2696,6498,4614,6497,6199,6223,4289,4293,4286,4282,6197,4292,4291,532,4290,842,5903,6546,1266,1165,6359,864,3247,1685,1616,3384,5066,3380,543,8244,8249,7189,7184,6042,7180,6201,3581,6656,6652,3879,6733,6653,6223,6218,7176,1245,7179,7187,5332,714,4426,2917,5096,4490,7170,7172,510,7598,7596,7637,7636,8278,549,7188,8599,8329,8246,8328,8342,548,8597,8598,8320,8317,5635,4386,8337,6654,548,528,7071,535,7281,551,6141,7238,546,6658,857,5742,5733,4716,4437,2041,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,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,6784,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,3893,543,528,538,8425,788,2023,7174,551,8404,532,6382,546,541,553,545,544,536,533,6493,542,531,6031,550,548,8212,8240,8529,7985,8771,547,391,2218,8832,2521,537,526,3881,3894,535,6204,6042,3889,7833,539,7816,8917,529,6788,2573,8274,8271,6650,6880,8273,8462,2521,546,2843,7815,529,542,3883,536,7075,7076,7666,4566,8839,7109,7118,8231,3908,7804,3829,9144,5732,9048,8716,9076,7175,573,3882,7647,526,7935,7150,7671,9132,3883,1557,2087,9744,9138,7642,7642,9794,9950,8365,8365,8365,7649,9875,10026,9797,7082,7599,3882,529,553,545,544,6544,3891,3896,6718,546,7580,539,3883,551,3890,6750,3892,2594,7987,537,550,8272,3888,3883,3882,526,537,550,543,539,7164,8729,3897,7172,3891,8883,4302,7166,7167,7171,7165,7174,6042,6740,4798,526,3849,3849,3849,7286,7286,528,541,8763,8763,553,531,543,1029,524,2776,2776,4510,4510,7385,7385,4788,7383,7383,8289,1645,3647,2992,6817,6366,2467,7795,2117,8027,7986,6870,7987,8272,553,524,526,545,536,528,543,544,551,537,533,550,6042,541,548,573,549,538,535,546,539,547,531,529,532,542,525,3510,7143,7833,7304,7903,1461,5376,7124,3885,7143,7143,538,546,529,6621,543,533,544,7833,547,520,7976,541,528,6042,531,532,536,573,6646,7966,6610,550,7815,4607,4906,524,553,4716,1726,6394,8081,8080,7270,546,525,9132,9132,548,8917,8447,7576,7576,7576,10169,1537,2869,7897,3860,7953,9486,9486,5994,3830,4879,6010,6880,4087,9156,8925,9192,9143,365,368,386,391,6076,382,5994,9191,8899,5389,9951,9048,3890,1894,3890,1894,1895,7194,545,5669,542,5669,542,5445,549,5445,549,2923,9177,548,2703,5810,5368,375,553,535,6042,538,8832,9076,3881,3883,3891,7262,7262,4512,9679,8945,9867,9665,8679,9439,510,10053,7772,7770,10232,7771,511,512,7637,7638,7596,535,549,548,541,542,538,539,537,536,543,533,532,529,531,10544,3719,10354,3115,8559,3559,9624,8705,7751,7972,507,2018,7973,9626,8704,8174,10646,9137,8174,9625,10642,5484,10647,10840,8015,10228,7374,545,8585,542,527,533,524,541,538,532,11251,11229,10925,10920,11186,11184,11182,11231,11177,11179,11181,11252,11175,11176,10921,6518,11173,11174,11037,11183,6519,6523,11178,1704,3442,7698,7843,7844,7845,7868,11185,10924,4297,4298,4299,9631,7843,6220,3883,3896,3891,3893,6493,3885,3890,8273,3887,3894,3897,3892,3888,3884,3889,3895,8274,10922,6537,6505,4296,6506,6536,6534,6535,6532,6538,6197,3515,10923,529,541,531,545,542,539,538,537,536,532,543,528,527,526,6042,553,550,548,547,554,9665,10053,10544,10975,11221,10948,549,535,524,10947,8240,6533,6532,6042,551,11241,10194,525,547,549,550,7592,551,6042,536,537,539,510,8820,9438,9437,10354,542,541,548,543,10607,553,532,531,529,528,525,524,8247,533,11242,554,526,11137,11049,527,4486,4473,4470,7168,4464) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC