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,6648,2998,1462,587,6690,6900,6779,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,3287,8314,7985,665,2522,8206,1699,5995,6117,3041,2705,5999,5328,6315,4131,2514,6314,4023,5180,6595,4682,6639,6674,6560,2590,6635,3368,6686,1113,6793,6792,2337,1298,252,3396,3542,3413,3055,2419,6713,4082,5373,3715,2967,6710,6857,6700,4136,1521,5596,6862,6863,3376,1992,6861,1698,2737,5812,6478,5379,6779,5142,739,6595,5739,4886,361,2046,3962,3135,1299,7016,3625,6782,5875,5349,3041,1164,4209,3534,3195,4805,3139,7025,4553,6699,6734,6697,4048,7156,5047,5246,6694,6397,3941,6337,1698,7209,7005,6986,4875,5536,1067,5222,4570,1992,6661,5885,2737,7356,7558,7559,7582,7156,7550,6711,7709,3376,7593,6665,7143,3976,7857,7815,507,7875,7821,6694,7760,7896,6697,7876,7920,7581,7777,8016,7774,2944,1432,5536,2294,6673,8089,8102,8140,8184,8215,1559,3904,2894,3195,4432,8291,5817,3775,4355,1835,4625,4740,5545,1347,3976,5081,4460,4741,6707,6478,1698,3941,8306,4739,8224,8543,8547,7025,8016,8104,7615,6858,1432,8480,5545,8175,8174,8629,3559,7016,5013,5875,8632,8687,5807,5328,8561,1347,2294,5543,504,3431,3474,7251,1521,7140,8782,8777,8809,6732,8819,4613,8812,4766,8801,8846,8813,8904,8905,8911,8208,4553,8916,4773,3244,8979,8978,8224,8104,3139,6665,4741,6699,1300,8974,7815,5906,9052,9072,9122,9017,9036,8888,9195,9196,9197,9200,9038,8704,9212,8231,2092,9220,9222,9223,9224,9255,9250,9273,9289,9291,9300,9301,9298,9242,9308,9317,8110,9278,9334,9347,9335,9337,9352,4049,4539,9363,9365,1576,3134,179,2200,772,2985,3297,265,5524,784,6622,850,4423,4504,4414,5078,6059,5400,744,6560,967,780,3136,5614,467,3645,1740,6876,3038,7613,5222,779,810,578,730,4639,645,4405,6809,6845,6104,6805,2615,4659,1603,5484,5904,7146,4774,5116,7303,1764,1460,6687,3492,5276,7144,3797,4854,4316,4964,423,5298,5003,7756,1272,510,4985,6953,1831,7882,7874,4512,2989,5400,470,5763,3358,6559,7981,7988,952,1092,3856,665,2331,7994,2913,3719,7956,3893,8135,5889,3878,4087,7287,4652,1184,3136,5995,7807,5332,7937,6732,7971,549,5965,4616,3824,8483,8484,6560,3169,5252,8257,4784,4830,8514,8573,8169,1872,8471,2024,6192,1349,7985,8305,2989,7251,3580,6255,6829,8713,1699,6102,5995,6104,4395,5339,5817,4639,6364,5906,6103,5916,5688,1016,6713,4800,4827,3542,3625,3474,5764,4784,4087,6858,6691,6782,6829,3554,5175,5965,4424,1755,1764,104,3574,6951,576,609,2849,5763,4510,4087,4046,1345,6809,2300,6731,458,6845,7358,5961,1988,3719,1993,7214,7019,3704,6795,7839,4224,7605,7890,3823,4774,7810,3908,4659,7920,2643,2658,8196,233,1511,1984,8548,7883,7216,8144,8031,8514,8089,2294,4258,222,2989,6006,7804,5252,1984,1458,1084,8999,8108,4452,1490,582,3492,1823,9028,9212,9213,9079,3712,8224,4613,4704,1300,2849,9116,4082,4136,9372,8559,2491,8358,582,5961,9258,9375,5636,207,8274,3890,3891,3893,539,542,3896,8271,3882,3892,3894,8273,3884,5567,9937,1253,2933,5545,4178,446,3889,9377,9799,9212,535,3244,6642,6891,4082,10000,6858,10228,539,10243,9438,9437,10181,10568,385,389,8858,8789,8515,2356,380,10354,8787,8005,4087,3401,3990,4613,8534,3474,9439,9214,9930,9648,10120,9680,9764,4046,4411,1490,4049,4050,1973,6738,9823,3493,6876,11027,10114,5175,11298,11020,11235,10674,6591,11339,5207,9243,11495,640,5732,2023,6023,2221,6034,8941,9405,7374,11359,984,11413,538,390,6066,540,532,528,11353,6894,5262,608,7810,10944,10942,10940,4752,10945,10946,10943,9148,11059,11509,11210,11627,11862,11212,7151,7118,11867,11335,11542,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,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,3287,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,924,6740,7238,5927,6190,511,7213,801,958,6725,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,4355,5020,1998,4185,3963,5386,5400,5322,5215,1230,5917,1586,5996,24,3913,5764,4082,5885,6117,6792,3595,2992,6831,6104,6595,236,1381,6315,3860,5371,1371,1766,5331,6559,4061,5576,6154,2294,6011,4316,3368,4185,6560,6863,7019,608,501,5215,1954,6337,1690,1325,1521,1600,1272,6595,5997,5371,6713,217,4985,7903,7761,7896,2594,2419,6862,7019,5142,5093,4659,2389,7751,233,7304,7972,1016,6010,5572,7973,6364,6103,8144,2023,6255,5763,8629,7640,3908,7607,7910,8629,8687,8629,8091,8093,5371,2467,3549,6588,7938,8185,217,7995,8182,7837,7834,7835,7836,7992,3850,1184,8019,5334,8093,6780,8305,8441,8222,3520,6712,8489,3131,8541,8555,2506,7869,4765,8019,7840,7879,7878,6971,1755,6175,6700,1462,3169,958,3646,6967,6383,2253,6366,2913,7149,5421,6642,5376,6644,2261,5046,311,7872,3428,6548,7605,1998,6130,6104,5484,6845,6809,4412,7022,2490,8178,665,7994,7982,1116,6364,7981,2761,4079,4405,8220,840,7992,2992,6766,2473,6644,217,4798,1439,1439,6642,2573,6740,7238,8220,2389,6011,8261,1516,1272,8187,2986,7994,6113,8110,7970,8091,7124,6955,8608,8547,2520,1586,8358,7607,7239,6119,8305,8306,2246,7982,6821,1050,2766,6328,1051,7599,7615,1557,2946,8541,8483,7093,8742,8914,1049,6905,2507,6740,9053,8554,8933,9107,6788,9030,458,5052,4154,6261,4639,7238,8220,9300,8761,5063,8651,1556,5165,9259,7619,9381,8628,9336,7910,9327,8290,9465,9387,8208,9450,9538,9547,2253,9331,9647,9652,8063,9754,8542,206,8403,9788,311,9789,2913,7900,220,4395,9257,8763,9889,9046,9933,9967,186,8434,9963,10026,130,7671,2487,104,609,10163,10050,8439,236,10182,10073,10177,10225,10144,10257,9824,10261,10234,10360,10519,10518,10541,10547,10714,10615,10820,10876,10910,5790,10712,10979,8206,11094,176,11010,10905,11200,9967,7250,11096,8282,7660,11371,182,5385,1299,6713,766,1299,5371,3913,8641,7982,217,2989,8547,8810,6904,2117,40,6870,8143,9547,7218,417,5822,7597,4801,4985,4405,9460,4563,6264,2467,2761,450,6205,9556,7926,6895,9926,4598,8482,9871,1327,9890,7974,2113,1662,452,8626,223,7890,5,7872,5,10060,9787,2658,8135,10267,5763,2644,124,8648,9553,4607,11025,10240,9546,10976,2032,1823,11127,217,10900,5262,8206,11256,8169,10986,10977,9557,8967,222,9046,130,10080,2200,3536,934,11621,10448,4144,7773) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC