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,6629,8498,8498,5134,5134,5134,6740,7390,446,4178,8514,6163,961,961,4254,5743,4598,1311,4854,240,3213,3647,4022,2915,3306,1196,258,2660,6845,4028,6104,4087,5222,2700,2046,3501,6824,797,6560,955,1561,7009,3534,6979,4985,7212,1349,1474,4779,1381,3564,6337,6342,4834,7790,4230,1126,7846,1164,6261,4659,721,3392,1142,5093,2736,7861,1366,6732,2451,7023,5997,7780,7981,3979,1886,7821,1327,7712,6850,1047,867,2384,7005,1113,2590,6875,1134,8224,8206,8358,1970,8706,2677,8706,5314,2677,7354,5314,4901,7354,8306,4652,1016,8805,7829,8961,5790,6314,3425,2749,8551,2749,7982,8933,8963,8795,8934,4598,9116,7906,7038,9061,8442,836,8915,8829,8923,6679,8935,9215,9275,9212,9377,6713,9600,8804,9653,3159,8894,9213,9834,9278,5379,5544,9649,9800,8827,7830,9836,10003,9730,9831,9983,9900,10039,10349,8172,9603,10399,10289,9964,9959,10395,10396,10307,10246,10765,10306,7804,8144,9832,5210,9922,10368,10016,11402,10907,11385,2849,2085,9406,10543,11310,10674,10881,11116,9542,11551,10466,972,11606,8620,11658,11670,310,11266,10000,9647,11436,11443,11446,9046,1953,11371,9741,10512,9299,11187,11834,10847,11604,11388,10190,9800,11691,9308,6104,6845,10871,217,1766,2727,6656,3402,4834,5551,2685,986,231,1730,6145,6146,4614,6311,1398,5756,3189,6214,6497,6489,5093,6223,6496,1234,946,6212,5947,3302,2776,6261,3479,6214,1741,2677,6221,6501,6212,8000,6496,1245,2696,8023,7638,8233,7304,3904,8485,8220,1645,8628,8306,8783,8933,8361,9030,9153,9152,7117,446,7117,4079,4796,7548,9600,8933,7155,7107,9750,7917,446,9849,9206,7985,9264,10039,8648,7080,10265,10556,8910,11291,8062,1988,11236,11812,1173,11497,10591,11497,8995,9838,11690,11736,9647,11656,11770,11714,11905,11782,3549,5334,11213,9039,6785,10579,11439,9897,7849,3169,6648,2998,1462,587,6690,6900,6779,6979,2389,6900,7139,6981,7142,7127,7141,5996,1537,7148,7268,7084,7124,5407,2776,4637,455,6267,3608,6437,317,7268,6969,2389,4460,538,8744,8354,4294,8585,9030,9042,8314,7985,665,2522,8206,526,2957,6738,5467,1098,4765,3094,4490,4164,4519,3564,4778,5328,4778,4426,3519,4616,1600,6780,6780,3549,5334,6171,933,730,6216,6222,6501,5093,3532,3784,6523,2725,4029,2300,1823,1533,7078,2457,7748,3085,5386,7172,608,1645,5552,4796,7572,2992,2337,8522,8224,8557,7670,7670,8649,7631,7546,8937,3071,8910,6715,8937,9300,8709,6809,9890,10146,8048,8053,8245,10047,9900,5692,8714,10491,10543,10590,4860,10674,8910,10573,10659,7125,8514,10893,11802,11497,3863,10988,9985,10687,11289,2506,11904,9485,10935,6797,10535,4985,9959,3159,5020,5817,7920,6785,8305,1349,6901,7037,6848,5903,9258,7919,3216,1834,1830,1110,986,4131,780,772,6679,6001,5764,6971,743,9063,5011,7143,4617,9837,9541,9471,5142,7856,7758,9924,9928,30,9929,9937,4109,8142,9831,8813,9783,7221,6397,5328,1313,9963,5544,4164,1707,1237,9916,9769,9222,6599,10088,10090,8912,10087,9990,7893,3346,9941,10001,3787,3657,2446,10165,836,10350,9607,10148,10132,10315,10342,10134,10526,6691,6986,4019,9614,9372,10543,9406,8910,9937,8836,9003,10012,10685,10955,10988,9554,10734,10548,11020,11018,9950,11042,8795,4652,217,11027,10512,11127,10938,8222,8793,9552,9925,11219,11285,11202,11288,1698,9922,11353,10246,11230,10568,11495,10974,11397,11235,30,11655,10660,11217,11646,7064,11598,11455,11644,11100,1603,93,7592,7554,7754,7754,5070,7756,7927,8509,4510,8162,2033,4234,3241,5134,9805,3327,1769,10938,11219,1768,6613,10985,11123,10002,10212,9830,9359,11069,5484,11497,10339,1993,9866,4520,10301,5995,8306,1257,180,5799,4739,9900,10212,9116,10002,9600,4861,9220,2261,10737,10526,11324,2632,2033,3493,9052,9418,5134,4785,11228,2294,1210,923,947,11678,3493,11816,2025,10892,7581,6117,11517,435,10780,11324,3744,228,2677,6691,2677,5088,3904,4082,6696,1347,3080,6774,5817,2294,6633,6858,6863,6693,1299,4724,6793,6821,3612,6809,2262,739,608,6845,6104,6006,3115,4432,4566,320,3701,3719,7592,4652,1699,1349,4778,2451,1073,2841,7839,4460,6732,6209,4258,7946,7081,7265,7268,7971,8058,7069,4029,7154,8211,8044,8058,7244,8288,8429,8361,8078,7080,8403,8209,7294,8713,8400,3066,8469,6650,8207,8402,8468,5947,8839,8772,186,8195,8284,8876,5936,8281,7913,931,7884,801,659,3647,5545,971,9249,5961,9141,6069,7718,8468,8408,1163,9560,9743,5956,9458,9480,2329,1906,9028,8460,5460,9875,4710,9874,9648,9876,9877,9878,8445,9648,8446,10275,10270,9132,9133,9619,9620,9621,9622,10575,10078,9748,9793,9746,9747,10292,7671,10947,10948,9609,9611,9608,10687,7262,9610,7241,7672,9878,11062,10965,10943,10906,10881,11187,10506,11045,11096,11059,10941,10891,10026,11262,10879,8573,10888,11018,11370,11275,9205,11277,9794,9756,7077,9675,11332,11337,8397,10676,11369,11469,11539,11542,10678,11266,4227,4226,10703,10449,10854,11410,11553,11614,11675,9877,11627,8740,8568,8424,10332,11252,11695,10325,11319,11696,9624,7172,9232,3559,7165,7170,7163,7171,7169,7164,7174,7173,7168,3115,11255,8228,8577,9554,4463,7166,7167,7677,4473,4470,8662,4464,4486,7070,2823,6443,1741,4645,9892,8712,11527,9509,8946,6688,9867,9383,11836,11516,10427,10963,11674,3359,11889,2780,2786,2781,2778,10789,10930,10931,10232,10926,10927,10928,11067,11068,11878,5134,10543,11697,11981,8945,11576,11574,11694,11723,11355,6768,11877,9625,9626,11575,6506,11354,6533,6532,6535,6505,11355,6538) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC