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,4128,6130,5893,6157,5070,4659,1381,1402,6103,5542,2137,675,1016,1038,946,5331,1954,6779,2032,2677,1385,5247,6642,1439,6364,4985,3908,6986,7101,5764,4898,5142,7074,7092,7075,1461,1145,6118,7298,7019,4424,7261,7289,7239,7267,7273,7271,7285,5961,501,7158,7272,7208,7036,359,4079,7296,6740,7605,7579,7797,7245,7089,2674,7269,7906,7937,2976,7835,8093,7264,8041,8144,8057,5764,7287,8169,7266,2046,2389,2025,1461,2389,8187,5142,8052,4563,7939,7154,4624,8293,6740,8423,2381,8411,8237,7982,2261,8258,8305,4639,2658,4766,8480,8483,1298,8417,1917,7994,8079,8459,8853,8062,4395,2913,8894,8769,8426,8810,6891,8955,8306,7037,7761,3346,8763,9083,7957,8651,7659,7239,8201,8658,2882,8547,8736,7210,3261,9308,9261,7775,9160,8055,6589,7900,5455,8736,6792,8055,4131,1029,9277,4597,9561,2052,9580,9038,1453,9647,4983,9562,8477,9446,9754,4079,9834,9444,9344,9136,9313,9258,8046,9367,9544,7073,1272,10009,10027,9450,30,10025,9821,9757,665,9316,9594,9954,9530,9257,8711,10056,10123,10261,10274,10125,10297,10144,8472,8019,8052,9575,9161,10512,10535,10353,10364,10182,9999,10356,10451,9370,9091,10541,10570,10694,10693,9158,9509,7261,10767,10039,10145,9259,10582,11134,11230,8062,10476,11116,9594,11337,11371,11671,11542,11651,11654,11225,10399,11476,11538,10401,10030,11767,9999,11805,10814,10582,11802,11794,11890,11754,9259,8740,8424,6866,6542,2520,5371,2261,6869,1769,6840,6869,6628,6754,857,1516,1245,1616,2696,6804,4426,7020,7092,7082,7095,7121,4490,958,7085,7093,6813,1165,6118,358,6177,1402,1740,2006,217,2520,2573,6971,1248,6726,1398,1453,6155,501,4860,7119,4218,6176,6658,7123,6135,6190,4769,2029,3772,6104,6642,3725,2389,7158,7083,7155,7119,7110,7085,7112,7096,7266,7211,7115,7572,6140,6140,6631,2005,7086,8405,8468,8468,8211,8450,7289,7289,7096,8398,8398,8236,8404,7662,7273,7123,6209,7101,7115,4724,2023,5732,1490,946,4234,5148,2632,3241,501,5179,5799,766,640,7940,7943,7093,8064,7084,7946,1038,6981,7931,8393,8391,7941,9634,9648,7581,9347,6117,8543,9798,9930,9932,9929,6857,6857,9637,9961,10784,10476,10149,10878,7068,7265,7304,6103,7081,4639,4801,7250,6740,7238,1516,223,223,7607,7607,737,737,8211,7244,8080,2389,7023,8447,7153,7971,8358,713,713,8053,8071,7773,8208,7263,7125,7106,7276,7249,7095,7119,1302,7117,7123,7089,7101,8053,7241,8048,8047,7936,8057,8055,7102,7096,7943,7574,8041,7243,8062,8045,7245,7068,7116,7659,8368,8040,8040,8202,8202,8202,8071,8429,9158,7110,7112,7668,7672,7241,7656,8269,7675,9206,7269,7269,8471,7101,7657,8082,8053,7081,7152,7152,8735,8735,8735,8735,8735,566,550,1533,923,7238,6740,466,4788,2736,2995,3564,1370,1917,4645,4785,1145,5988,788,7121,6659,3392,2915,7245,7108,1520,3059,2261,3493,3595,7019,4947,7761,179,1461,6710,7008,2986,4234,6642,1327,721,8085,2775,2776,1886,1207,2725,8222,7019,1198,435,5251,5143,8185,8185,8434,2451,2932,233,501,4861,1425,4512,4316,5298,5298,5003,737,4037,8470,8685,7808,2605,2605,3989,6382,4038,3841,6144,7244,6149,378,979,7285,8793,8340,8246,8325,2520,947,7359,1126,8241,9030,8424,8204,8334,8568,6082,8874,7998,7999,8328,1173,8141,3169,842,217,698,9182,3389,6774,6774,9204,4240,9056,8445,7675,7087,182,7116,4301,4301,9053,6042,545,539,537,7986,7654,7125,7985,543,7999,9870,2677,9533,4784,7117,9418,9554,9676,1234,956,1210,1741,542,9378,1768,28,4029,3014,3891,3895,6493,3803,9878,9877,9874,9875,8459,8469,10171,10171,10187,8446,8445,10272,8363,8423,8891,8892,9082,10399,10451,9207,10011,10400,9224,10706,10759,9649,10702,10401,1257,9674,9401,9297,4401,9968,10938,10802,10991,6342,7852,8963,11089,8437,10667,10888,10887,11188,11402,7080,7661,11370,7655,10768,7655,8721,8737,9658,9199,8712,7933,9398,11189,1250,2093,1324,176,2374,2749,4401,1271,1497,3425,4659,6103,6701,6488,6205,324,2171,1324,6342,6163,934,52,6875,2182,4535,6348,4774,6210,4199,418,947,5331,6622,1439,3979,2027,6958,2729,5912,6972,1366,867,6806,6973,6974,737,3148,6890,6798,5822,5763,5986,6488,3425,6193,52,6240,3250,4659,2182,5314,7068,2749,1016,6264,6975,5564,4683,4684,1210,6103,7154,6832,4535,324,7218,7149,2490,7823,5763,3908,7108,7081,7990,7893,2847,7880,3346,7993,7804,4339,2027,7715,7079,6264,7270,5912,7281,7285,7154,7906,7284,7941,8283,8081,7941,7286,6103,5245,8085,6205,6138,1016,6121,2897,324,5822,359,6796,6633,8610,6904,8141,6193,8141,7584,3425,8279,4559,8560,8063,8058,8639,8445,8046,7714,8575,8653,8438,8570,7021,1402,3883,4597,7656,7657,7123,6869,7675,7658,7655,7121,7101,2522,2117,6947,6743,7286,8071,8041,7116,7287,8067,8197,3892,5602,6604,6745,7279,840,8210,8298,8040,8227,7971,7226,8391,1462,8410,8462,7745,7741,7742,8053,8047,8022,7093,7910,8580,6648,8547,397,8685,6272,5184,8391,8055,7903,6596,4282,7654,8290,6259,3029,7292,7293,7069,7152,7082,7096,7121,7076,7967,7153,7153,7083,7281,8406,8405,8409,8406,8085,8386,7666,7967,8404,466,4788,1303,3511,1215,156,1250,1498,6130,4767,5400,2029,2736,4558,1425,450,5995,3026,4791,1210,752,5729,1762,2743,5431,6490,6561,435,1398,5922,1461,4128,3936,916,5936,964,1497,3558,5251,5629,2054,5924,6986,6710,1433,1537,1917,7100,6632,104,254,1089,1215,4796,2337,501,7113,4861,7102,4762,1349,4216,5322,7280,4199,714,4220,7054,6707,4519,4401,1371,7304,5371,1145,2023,6264,7072,6104,5535,934,6365,609,4983,7938,4233,52,5430,6561,8306,3244,223,2677,4639,7238,6740,8590,8183,1439,7875,8615,7023,5373,7546,2986,5143,3014,3581,5484,1126,1645,3018,3941,4510,8783,322,2944,766,1511,7279,272,7107,7280,8066,7086,7096,8055,8065,7932,7077,7154,7931,8076,8087,7941,8064,7943,8053,8077,8208,8063,7081,7071,7263,7121,8453,7106,7664,7115,7250,7250,7262,7656,7084,8450,7092,7671,7116,7096,7152,3830,7289,7245,7106,7272,7119,7117,8269,2932,7296,7089,5148,7271,7906,7268,8056,4860,7572,8385,8395,7258,8086,7104,7151,8287,7276,7675,7115,7068,7094,7084,4796,7124,8282,8361,7107,7304,7943,2992,7714,3860,1537,8230,7646,8365,7118,7246,8450,7083,7671,8058,8055,8473,7151,7295,7897,7647,8463,7675,7967,7107,8526,8109,7288,8903,7118,7663,7246,7291,7666,7124,8365,7104,7096,8083,7277,7089,7155,7246,7083,8739,7287,7261,4769,4769,3913,7250,8268,7080,8211,8080,7020,3850,182,4936,1371,1351,6774,6733,2029,6547,223,6795,6562,6575,1016,7110,7125,7087,7086,7088,7117,7123,7101,7116,7124,7079,7153,7069,7121,7258,7249,7106,7276,7074,7096,6712,7252,7247,7253,7084,7278,7272,7291,7096,7247,7275,7091,933,3302,7840,7878,7241,8056,5305,8070,7879,7937,7254,3860,7279,8055,7147,7289,7245,3698,7238,6740,7943,7913,7238,7572,4216,2399,7280,7263,7992,6559,8386,7270,3550,906,7932,3380,8670,6832,8471,8408,8087,714,8770,8053,8681,8736,7106,8698,8045,5098,6239,5435,6819,1616,2024,3384,8063,8473,3385,4555,8439,9578,7654,8402,1453,2992,408,1663,2520,5827,7069,7123,7115,788,5806,7591,7576,7833,382,6189,6742,6582,8268,8401,8401,365,8267,4861,8580,8580,217,7548,8790,3036,8394,8390,8390,8891,5882,8251,7897,9011,8839,8839,8438,2992,2992,9028,2992,8793,9139,8426,8077,8418,7271,8472,8396,8067,8419,8368,8086,8712,8427,7285,7085,7280,8741,8206,8658,8282,7102,8711,8794,7931,8740,8567,8891,7114,8742,8892,8052,8079,7655,7092,7281,9058,9059,8206,8891,9091,9140,9158,9160,9056,8467,9157,8045,9204,9205,8059,9247,9261,9148,9225,7248,9302,9262,9264,9313,9141,9138,8415,8768,9368,9367,9401,9443,9445,9400,7931,9529,9530,9133,9572,9132,8240,9577,9619,9621,9650,9622,9620,9370,9441,3860,9662,7671,9660,8417,8644,9815,9816,7646,7904,7674,3169,8063,7252,7992,5719,3754,7265,8213,4079,2052,4152,8208,8193,8290,8206,8434,7903,6178,4395,7272,7278,8229,7976,8206,8393,1142,3702,2521,8220,7272,8918,8050,7261,7261,7264,9148,8770,7262,7264,8462,8460,8034,8034,7155,7121,8445,7112,8040,8050,8048,4683,7111,8036,8369,7123,8033,7675,8034,7278,7113,7118,7082,7649,7647,8378,8472,7261,7283,7265,7081,8792,8431,7574,8036,7287,8253,7266,8466,7250,7572,8361,8429,8473,8385,7245,8452,8456,7105,8055,7244,8455,8444,8393,8768,8080,8446,7943,8769,8084,8414,8474,7069,8741,8998,7268,8461,8415,8743,7080,8712,8721,8474,8086,8722,8426,7111,9204,8908,8635,9207,9187,8045,7096,8366,8930,8641,7663,8070,7093,9225,8269,9201,8642,9139,7264,9148,7931,8652,7975,9444,9445,9447,9446,9398,9443,9400,9401,9446,9560,8044,8058,9580,9203,8363,8642,8046,7262,9247,8470,9583,7288,8034,8036,7112,8443,8033,8082,7574,8430,8742,7671,2023,7291,7659,7115,7671,7291,7291,7281,7118,8771,9539,7644,8087,9529,7655,7655,7655,7106,8431,8070,9148,7659,7152,8368,9819,9741,7118,9795,8381,9719,9259,8709,9049,9049,8071,8071,8380,9563,7100,7068,9312,9312,7114,8282,7115,7089,7646,9053,7297,7119,7096,9564,8047,8055,7241,7292,7572,7121,7660,8058,7280,7272,7278,8401,7117,7111,7106,7069,7112,9132,7079,3702,8863,8863,8861,1770,3889,3889,1765,1765,1765,7674,7106,7971,8050,7665,9205,7152,7115,7116,7272,7932,7096,7245,6726,7125,7241,7897,7106,217,7266,7084,8055,8071,7270,7671,1029,7672,8079,4597,8087,4770,8062,1402,4662,8384,7668,421,7675,8269,7657,3550,8019,8077,8657,8053,8363,8202,8739,8052,8081,7668,8468,7931,8418,8084,8056,7071,8471,8422,8641,8087,9148,8736,9053,7671,8475,2573,2328,2388,8450,3297,8438,8477,130,5915,8385,8041,8288,7656,8045,8042,8068,8407,8782,8065,8057,8060,8069,8067,8282,7660,8058,8051,7095,7666,7669,9160,8359,9054,9055,8367,8419,9573,9574,9575,9578,8476,9577,9561,10022,8467,9539,10074,9793,9580,10077,9999,8235,8642,10009,10023,10051,9158,9565,9998,10075,9572,10186,10027,8082,8078,7076,7081,7108,9443,9445,9510,9581,10024,10026,9562,10076,8364,10185,10022,8767,8410,8085,8507,8528,6879,7628,10272,8411,8412,8398,8397,10275,9793,8396,10186,10690,10659,8286,10629,10624,10689,10030,9225,8439,10630,8408,10675,10770,10773,10691,8644,10811,10807,10774,8405,10625,6896,10835,10843,10889,10891,10852,10853,9187,9204,9206,9218,10881,10906,10692,10862,10863,10834,9206,9219,9263,9262,9261,9264,9875,9876,10270,11066,10271,11062,8567,8473,9292,9313,8201,8207,7290,8569,9314,10965,8206,8537,9367,9368,11045,9316,8468,11027,10586,11187,10450,10405,10401,10890,11336,11224,11333,10572,11368,11370,9294,7275,8229,11331,8474,10694,8383,8929,7289,9399,9400,11376,11500,11501,11502,11507,11506,11503,11513,11542,11614,11538,11540,11528,7239,1349,9028,7276,8876,7900,8284,7872,7903,217,5513,4023,1741,156,7088,6664,9304,7815,7086,9308,8877,4796,8880,8477,7088,4535,9299,8889,4019,9561,8369,8460,9581,8772,8071,7674,8636,7285,8286,9910,9922,9959,10022,8184,4765,9817,9819,9818,9526,2032,8169,6769,8106,9125,6872,6889,4563,7144,5052,1142,8430,5053,5056,10116,9666,9212,9991,9800,9377,10008,2122,5420,7037,10081,10754,8092,9554,9036,7830,6805,10312,11021,9758,8915,9492,7987,1369,11129,11103,2288,10412,7285,5688,10847,11334,11338,10022,984,7666,7175,9438,365,380,376,8172,5903,11554,11630,11753,8891,9956,7086,11757,7935,11370,6632,6593,4438,3865,1302,3337,6183,7666,7664,7092,7100,7268,6798,6548,7245,7112,1173,6715,6102,2417,8044,6127,7074,3248,2342,374,385,7085,8205,7271,7123,8198,8469,7089,8438,6807,8740,8577,8640,1296,8418,8447,8447,368,6076,8568,8362,8362,7251,7251,8424,6614,8203,7095,8395,8251,6082,7656,8201,8201,7068,8408,8207,8199,8471,8646,8537,8282,9203,8724,8396,7660,5872,5872,7101,8768,7944,7944,7659,9158,9158,9199,8570,8737,8737,9658,8058,8269,8269,10185,10185,10185,10051,10051,8268,7932,9889,7103,10451,10399,10400,10401,10228,7105,9140,7296,10212,10008,10212) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC