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,4178,222,446,4860,1398,4796,2776,5799,5070,808,734,6192,1461,6117,5236,2915,947,3392,3465,3059,228,233,4029,2473,1371,975,5995,5362,3014,1520,5286,766,6249,2632,501,2594,3989,2932,2706,4767,6556,4769,6250,4045,458,459,28,4950,5081,6188,5995,6315,1537,5763,24,223,6103,6415,6383,435,4659,6412,6348,2294,5596,6414,5576,1351,6752,4230,3247,6947,1207,7023,7089,7068,834,6858,6171,7238,7209,5743,4146,4652,3159,3437,5996,466,1741,1572,3457,7022,3554,3754,4597,7032,566,6856,6984,7304,6110,2328,6940,7143,1536,7837,2118,7659,7834,7835,2594,1741,1210,7833,8523,665,1349,1016,7836,7840,7879,7878,8306,1215,8514,6010,5609,8358,8927,2737,8389,8915,5371,8681,8698,9041,8817,4131,8869,8884,8442,4901,4544,7823,1257,2677,4519,8901,4355,5020,1998,4185,3963,5386,5400,5322,5215,1230,5917,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,6979,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,2932,6783,3241,6586,1173,1038,6716,6584,6408,6407,4227,6817,1793,5981,6100,5331,5371,7012,2869,1351,5576,1433,1498,5215,3701,6294,993,550,1771,524,3702,2522,6980,675,6843,538,546,6042,528,3913,7123,537,5576,1296,6004,528,526,7250,7085,7086,1664,6306,2006,7977,5897,6740,553,7238,544,8220,7654,587,8102,182,7903,1807,7110,7932,8077,8544,8470,8615,8306,8528,8047,7268,7080,7660,6792,5629,5175,2246,1196,4599,3189,6858,6947,5266,739,7138,6708,5636,1487,504,834,2841,6732,5215,1196,405,360,573,529,546,547,7138,545,7883,2933,608,2294,3080,1347,6074,5994,6176,6644,6962,6110,6383,6175,5887,5887,2183,1521,3715,4936,4938,319,6644,3542,3625,834,5552,4131,2390,808,6588,358,6189,5915,6122,2677,319,1425,3860,463,6168,6172,344,2183,2876,3217,3264,3557,3828,6075,661,7033,1318,1407,7117,7117,524,6371,1210,6539,6742,4131,6529,6751,6744,6527,6528,6743,6152,6635,7354,391,6742,5691,501,7138,3368,6740,7304,3957,6586,4349,4762,7975,3351,24,2419,7019,223,7759,1653,6890,2117,6650,6861,1773,8010,1774,3913,30,1774,7238,1774,7761,743,7872,743,1127,2118,3609,1127,7126,3609,4860,7126,2192,7547,7896,5327,2265,8809,6710,3429,3159,2265,7576,5536,6695,5536,6613,5536,6579,5435,5536,8220,1772,9000,1298,6861,6282,3957,9030,7977,7615,1159,3376,3327,8900,5188,7830,36,8284,9081,6858,7929,6832,9346,9346,6171,8103,8193,7640,2554,8193,6809,9811,6591,7138,6809,444,8827,9338,4320,7718,6713,8628,261,8628,5046,10342,8358,6981,8305,8195,8521,10056,7839,8140,7839,7304,8140,7614,3698,8915,7156,8915,11331,8617,1416,9604,6775,9803,8620,9476,1250,8620,9476,11491,6980,8927,9648,10734,10892,11703,8620,4056,11670,6011,8261,1516,1272,8187,2986,7994,6113,8110,7970,8091,7124,6955,8608,8547,2520,8358,7607,7239,6119,8305,6979,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,7238,6740,7903,1609,6623,8225,4598,969,7143,6172,5371,6714,6971,788,1085,8759,8611,1084,1085,1086,8763,5495,842,8757,7841,5914,3913,226,217,6806,3169,6195,6003,2079,6715,4248,7905,2643,6618,1609,3402,1604,2555,6619,4918,226,1662,8389,8434,9422,8449,445,7961,6592,9547,8019,7912,6879,6000,9042,8178,7897,7846,1563,7846,9759,9889,4338,7921,9879,9754,2122,4154,7271,2849,947,7262,7262,6176,7271,7271,7268,7674,7261,7261,8763,9828,9828,5134,7829,4520,8793,9117,9195,7634,9129,609,4648,9000,7546,6660,7734,8146,9541,9155,8528,8966,739,3850,5331,1433,3368,320,5764,3715,3542,6792,1559,6117,5373,6635,4131,5331,6559,6782,4185,2294,5349,5542,5142,3625,5717,3368,6713,1038,1299,512,2160,5215,511,1521,6315,5020,6639,1347,3037,6693,6595,6548,3080,5339,2933,6858,922,608,6154,24,6700,5247,223,5885,6367,3026,3904,5875,36,5837,6584,30,239,6674,748,1536,1576,736,585,104,510,6713,6560,1253,6792,504,754,3474,6862,3863,2387,768,1067,1113,1347,1872,6793,1523,7138,4028,1526,1569,2381,4194,321,2660,2419,7005,2639,1055,5331,4126,511,4061,6188,2299,1647,5764,3413,1727,5614,5817,4362,6845,955,7358,6809,6104,4923,1568,741,3419,1823,3561,3933,2976,3701,6699,3936,967,5236,2590,7839,4553,7012,1134,7025,7883,784,1920,7759,3117,7780,3134,7840,3129,7876,7760,7712,7859,7879,7821,7858,7855,6981,6315,4624,7865,7856,7719,5543,6734,2882,6697,7920,7896,6679,4258,4460,6986,5545,4566,7126,252,1268,4969,7354,2244,7919,8089,3100,4128,8000,7156,4901,6684,4082,6337,6314,4730,1073,5047,1439,1127,1298,7550,8543,6131,4886,7840,6740,7238,8220,8215,8225,7827,5739,7559,6117,6365,7981,7138,8900,1311,6945,3195,6478,4432,8888,8902,6136,2018,360,1698,8901,3542,7605,8146,1521,156,9036,969,9200,9279,36,9116,739,2387,6792,6713,9329,9244,9372,9322,9374,2944,3542,9273,7580,7138,1349,9258,1215,8306,6337,1521,6942,8925,7038,8681,9018,9051,8698,9050,8687,9109,4023,1432,8031,1257,9406,7005,6663,6664,4652,8514,8795,8805,9363,9454,8910,9402,9391,9333,9421,9335,8978,9346,9366,9308,9197,8934,9248,7839,2514,8817,5180,9041,2841,2246,4679,4504,609,7354,8254,1005,9249,8935,9471,3549,5334,8794,7910,8547,8955,4765,6780,4194,5215,1576,2117,8915,752,2387,8193,8019,254,5516,4538,6684,6642,5121,9459,2709,4405,2669,428,9600,2123,5602,2118,1762,9604,9606,5379,1681,1572,1498,6874,9627,5640,3613,4099,6867,4056,3457,3964,228,8629,1080,9038,3023,9638,2743,162,9455,1121,9634,7581,1119,9335,5046,9653,9657,6663,9635,9383,9677,9665,9345,8324,6569,8618,5088,380,6968,6962,3898,7631,8788,6076,9217,9590,9119,8972,9785,4684,8356,9555,9781,2522,9947,9001,8311,9880,9851,9838,9231,8917,5995,5148,1137,3941,4048,180,6842,5286,6595,8500,4131,7354,3921,5088,3976,1461,6792,6707,9808,9464,7875,9661,6632,177,1325,156,4860,5541,8306,6703,9552,3493,4513,4947,4670,10046,10112,6683,4240,4100,4088,4950,145,5005,4740,8819,9983,8846,8829,8890,9258,9925,4355,4566,4337,6679,6710,3904,9910,6986,10229,4023,5331,1954,7005,3026,6863,3744,2894,8615,10227,6684,5542,6694,7156,10523,10063,8031,9373,4233,4767,585,2054,4045,11304,3213,6632,104,10472,11302,4875,11619,4455,5995,5179,3059,4739,4234,8793,2632,10212,4596,9453,11644,4741,11455,10375,1490,9993,9052,4178,640,10128,8745,10473,4773,1917,9614,9977,3595,609,10212,4788,4785,9533,4791,4784,2451,1210,10526,9300,10056,4639,10836,10742,10038,10758,10034,10037,2246) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC