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,6151,215,6152,5996,3263,3277,6719,6763,6764,4614,6656,7100,7072,6612,6751,7091,7109,6744,7075,7294,653,6521,6388,6391,1746,2992,240,7087,7258,8087,7263,7675,7675,8049,7089,6385,7300,7106,7069,7276,7125,7117,7117,7117,1927,7120,6656,7116,7295,7151,7105,7246,8365,8070,7096,9081,8064,7081,7102,8798,7294,2780,7072,7261,7286,7068,7094,7108,7107,7104,7283,7266,7081,7121,7154,7119,8240,8228,7946,8349,8207,8406,8396,7967,7279,7715,8790,7106,7278,8360,8439,8423,8423,7599,8404,7658,6382,7946,547,8371,8459,7070,1769,1967,9076,8208,8362,8380,8463,8832,7076,3883,8050,7665,8201,7932,8394,4769,8362,585,7238,182,1145,4947,7124,7083,7666,7115,7268,7115,7100,7094,7152,7246,7119,7072,6432,4399,7493,7476,7476,7535,7420,7977,8514,8514,7243,7074,7092,6190,7280,7269,1242,7113,7574,7091,7118,7109,8087,8909,7085,7572,7095,7666,7252,8401,7241,8213,8080,7245,7281,7246,8384,7654,8452,8909,7251,8362,8208,7713,7243,8772,8736,8736,9133,7714,8782,9132,9622,9747,8395,9620,9621,8768,9610,9058,9059,8419,8087,8085,9611,7280,9205,7275,8240,8081,9458,9748,9876,9875,10029,10077,10030,10075,7238,7083,7654,7094,2989,7124,4769,2677,5995,7670,7666,7594,7647,5647,446,7642,2632,3964,7114,7661,4406,7662,7081,4082,5602,7359,4936,7279,7272,4944,7648,7093,275,6743,6390,4659,6133,6821,1167,2263,6633,6209,6240,5566,3425,3896,5883,860,6382,6749,1970,6907,6904,5822,3882,3883,3891,7293,7270,3884,7124,3888,3888,3892,7124,7251,7292,3890,7094,1366,6493,7155,3891,7095,3893,7083,3889,7087,7072,7100,7082,3884,6600,7971,7985,7107,8071,3890,3897,7647,7089,3892,4724,6821,7277,7251,8197,7986,7247,8393,1626,7088,8384,8449,8384,7663,8439,8577,8085,8386,8206,8205,8401,7940,3895,8646,8412,8772,8080,8240,8368,8274,7649,7653,8737,4805,6209,9056,7713,3881,3883,4220,8269,5454,8468,7671,9053,6863,8461,4233,8271,4209,9132,9402,458,5484,3894,4519,8893,4800,7985,9481,5777,4690,450,1569,9322,8257,9418,3244,9915,9934,8268,8644,7108,9417,9793,9367,8229,10078,5484,8398,4424,3531,7295,7657,7101,8287,7654,8382,7118,7295,7100,7294,7082,7075,7076,7665,7647,7666,7109,7266,7124,7647,7094,7092,7155,8063,7246,7281,6832,446,7151,51,6178,8084,7083,8402,8212,7928,8042,7250,8404,8569,4178,8706,8408,7251,8576,8403,8208,8361,8083,8576,7671,8407,8365,8818,7270,8425,7153,8228,8942,7277,8939,8939,8832,8832,8782,1257,9189,8412,9138,2590,5322,566,6130,2677,4452,2615,3908,215,6255,1370,6633,7113,5188,6119,7095,7117,6175,6310,6103,409,524,7295,7082,7238,7023,5995,979,5066,2261,2520,2522,4614,6701,1746,5331,6740,2605,5386,1016,6957,6702,6957,867,7646,7118,7649,1411,3609,3698,810,7076,7081,7116,5763,7106,7109,7087,4390,7153,7114,1165,7653,7599,5297,1685,6272,1266,6623,8080,8042,7291,7269,7285,7101,6709,7096,3550,7808,5332,3754,7932,8049,7643,8281,8077,7245,7931,7906,8444,7967,7605,8541,8552,8304,8480,7658,8088,8435,7903,8542,2389,8283,7154,8721,6870,7284,8706,8389,8266,5371,8628,7068,6359,6890,8290,7262,7124,7294,7289,6656,2521,3644,3359,7110,8207,7661,7675,6332,6855,3725,7089,7276,7248,3014,427,8306,7282,7084,7249,7019,7761,8222,8793,7280,9195,4659,735,7283,6364,7094,9338,7247,1998,4185,7254,7293,7671,8047,8284,8064,8079,8052,8053,8063,6381,9552,9137,8578,9149,8434,3380,6263,1685,1266,8459,8449,8580,8824,8972,4555,180,7904,9743,9793,1257,7588,7721,9614,9800,9888,9868,8166,9959,7239,8581,9931,9933,9030,9386,8725,4639,9936,9950,9349,8922,223,10040,9951,9973,8566,10026,10088,9547,10087,7704,9879,9989,9536,10086,9534,10239,8202,10089,10090,10265,10008,10260,10257,10292,10247,1645,10237,10044,9892,8087,9785,10362,10321,10061,10272,9824,5053,5056,5052,5056,10320,10520,10526,6656,10574,10575,10574,10212,10297,10505,10650,7816,10229,6977,10211,10176,8780,5064,10222,10811,7910,10814,4765,4535,10302,10546,10913,10546,10965,10821,10938,10914,10827,10131,11027,7815,10512,10011,11072,10113,11121,10114,6898,7206,6240,10881,10519,10839,10840,3863,5903,358,6349,834,924,7104,6947,713,6350,2573,5927,3549,3549,7920,7920,7920,7150,7499,7291,7975,7154,7107,8033,8228,7247,7654,7100,7967,7155,6718,7298,7906,8205,7106,7103,7251,8361,8580,7297,8208,389,7270,8381,8425,5936,7674,7967,7294,7079,8203,8828,8407,9049,7096,9158,8047,7266,8207,8203,7642,8413,9141,8980,8879,8981,8982,8983,8498,7704,9146,9882,9794,9892,6744,6749,6751,8410,6746,6386,9176,9762,8581,9177,10097,10098,9821,10189,10095,10078,9733,9088,6854,3894,3893,8784,387,392,6082,372,365,8530,8529,8201,6076,9217,4305,10161,5995,7913,10263,10213,8882,8788,8786,8451,7877,7897,7124,6561,7079,7079,7985,7985,7913,8171,4079,8438,8438,8498,8090,7884,7884,7884,7665,5923,7499,4742,7272,7368,7501,8406,8406,7105,7304,5897,2041,7388,10572,10572,10211,10211,7086,7080,7119,3874,7385,2179,1324,7108,7292,7292,7096,8050,7104,8061,7298,7642,8060,7297,1366,7106,1366,7107,6740,7238,8220,7124,8431,7607,7094,8470,7108,7077,7293,8443,7250,7655,7288,8033,7574,8444,9300,8469,8768,8395,7932,4801,7971,7674,7105,7082,8472,8740,8424,8568,8445,10056,7262,8085,1250,7281,501,7072,7020,8047,4224,7282,6388,8057,8166,4234,8430,8050,7082,8208,7083,1746,8055,8368,8463,8409,8202,3885,3890,7270,3889,4861,4947,7105,7110,7110,7124,7093,7093,7105,2992,7076,8782,8382,8371,8768,8768,7261,9610,7261,7286,9608,9611,9793,9793,9743,7714,7714,8228,8449,8450,9560,8782,8782,10026,9950,9573,8363,8363,10022,10022,7671,10292,10292,4558,3891,1766,3892,4419,3881,1685,6195,4769,5255,4178,7548,6726,7647,7897,8390,8036,8033,8491,9055,7115,1662,9213,8368,7083,7716,8423,8709,8832,8438,8386,7775,7775,7926,7926,7776,6904,7022,7244,7107,8402,7647,7647,8208,8737,7668,7669,8201,7293,8425,8058,9401,8080,7080,9580,8424,8424,9160,9444,7154,8415,8743,9445,9400,9443,10075,9293,9660,10185,8477,8417,8414,2380,925,956,6990,1600,360,470,1575,744,2974,2151,650,652,243,1487,3645,1237,6885,7029,6563,4008,7063,8289,6564,925,1098,1869,943,8148,7053,7047,6576,6570,6573,1727,5947,6569,6574,2331,947,6883,650,6998,6678,7228,6562,5961,7105,7124,8942,6362,7050,7175,8182,5735,186,4131,6575,6795,6669,7757,7237,7232,7227,9321,9982,9531,7057,6571,8726,9487,1856,10205,7647,7094,1050,3165,7363,6310,8681,1591,6354,2841,4178,8839,7187,8225,5917,8085,4798,4639,6102,9322,1073,9258,7068,8070,3891,3892,7113,3882,3897,3885,659,374,310,389,546,540,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,7124,7107,1500,7094,801,1265,2145,2145,915,9274,5936,8171,7666,7666,7666,8582,8566,8229,7286,8824,7286,7084,7100,7102,7068,7072,7116,7077,7069,7123,1398,1398,6714,6714,6663,6133,6310,1085,7096,7272,7106,7106,7269,7241,7114,7250,7076,7280,7275,7125,7261,7266,7647,6569,6550,7106,7932,7105,8406,7674,8065,8055,7070,7255,7654,8201,2749,6691,6691,6691,5961,6929,7971,7576,8981,6926,6933,6650,8879,6742,7703,6744,6936,8700,7104,7646,397,6144,7150,7297,9174,6743,7099,8980,8982,2856,6749,6349,6751,1730,8983,6750,546,9500,6935,2992,8570,7261,7261,8366,8366,8366,2594,7104,7099,9022,9022,9264,7273,7107,8709,7124,7931,7241,8076,8547,7087,8055,7116,8077,7656,7280,8066,8770,8358,8832,8386,8053,7675,9161,7267,8358,8571,8087,9031,7087,8398,553,8770,7125,6130,7086,7124,9293,9793,10075,7111,7931,7107,7094,7124,7124,6740,8739,7087,7087,9660,9574,8739,7656,9083,7657,10409,10475,10475,10074,10591,10588,10592,10774,10691,10609,10692,10889,10694,7287,7121,8211,7110,8084,8087,7096,8047,8366,8063,7084,7658,7268,7655,8080,7714,8065,8452,8652,7659,8456,8998,8068,8268,8713,8064,8401,9560,7273,8891,8892,8393,8378,7670,9053,9594,8058,8362,8049,8425,8050,8406,8201,8640,7674,8373,7662,8641,8476,8430,8766,8443,9564,9738,8712,9740,8428,8570,8646,9508,9741,9442,8737,9562,10025,8467,7665,7266,8081,8080,9573,7674,7287,7971,7125,9055,8449,8770,8449,7655,7715,10401,7286,7280,7714,10475,7662,10272,7265,8571,7660,8451,7281,9148,8288,11692,8308,970,5386,9182,8310,9593,9431,8874,8342,8340,8337,8333,8315,1765,8248,8326,8244,8241,8311,9889,8700,9839,9879,1771,3071,3073,1765,10229,1771,1266,1769,8946,1411,1165,1767,9149,1769,1266,3066,6778,2605,7083,10522,7933,7124,26,6768,2555,7258,7115,1988,6578,7551,1296,6984,1085,9469,9467,9784,3169,9633,9847,9524,9845,9494,8200,8365,7642,9451,9843,9796,9846,8266,9995,9972,9665,9129,3071,9842,9350,9855,8203,314,9806,8228,7105,7104,7107,7103,6689,9854,9867,7155,9794,9580,9498,7070,9632,10238,10053,6242,9880,9622,9205,10176,7120,9563,10254,8450,10256,10095,4121,9134,8732,9621,1768,10232,9259,1616,9204,10077,7632,9539,8047,3358,10037,9933,7121,6898,6272,7111,3889,7125,5769,9529,6613,6582,8048,6579,7256,5051,8965,7119,9084,9578,8201,7152,7117,7116,8739,8053,993,9975,10510,10571,7895,9563,7675,10239,10544,10590,10612,10640,512,7087,10587,10659,10690,510,8824,10592,8770,9054,8644,9134,9563,9055,10586,8053,9055,9134,7088,7096,7086,8055,7106,7083,8034,7297,11212,11189,7243,8240,9622,11187,9746,11188,11196,7298,8499,9206,10588,9563,9620,8407,10272,10692,8438,8404,8208,10614,11150,8928,8236,10615,10689,10587,8410,9813,10869,11108,8782,9609,9608,7668,7669,9611,10565,10328,10975,9610,7247,7672,11096,8573,9748,3863,10831,10211,11263,916,11247,11115,11116,8854,7806,4979,11218,10976,9006,11214,10438,11713,11262,10945,11472,9820,8740,10506,9873,9874,11803,11804,10511,10629,11794,7931,7659,9875,7971,8240) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC