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,7270,3026,7895,1461,7265,7241,7941,7875,7939,7077,8070,8086,3933,6365,7992,2029,7946,7087,8078,7119,7093,7944,7121,7108,7589,7271,7268,2006,320,6204,7677,7096,7083,7071,7241,7095,8611,8688,4355,8404,8049,7281,8615,8819,8422,8227,8407,8404,8375,8908,7286,8049,8793,9027,7080,8084,8918,4209,8938,8561,7674,7117,7270,7096,7940,8460,8362,8641,7266,8438,8767,8447,8709,7108,8641,8836,3904,6103,8282,8047,7903,7124,7833,8077,8358,3728,6642,7143,7837,7125,8244,5995,8342,8306,1215,7834,7068,7245,8049,8470,8055,7115,7104,7112,7069,7094,7089,7666,8287,8450,8417,8050,7115,7111,7288,8084,7096,8047,8743,8212,8406,8736,8644,7715,7244,7078,7108,7101,7085,6750,7276,1086,7279,7574,7987,7986,6742,6749,7985,5454,7745,7741,6529,8237,8684,8818,8583,8753,3413,7118,7295,7100,7294,7082,7075,7076,7665,7647,7666,7109,7266,7124,7647,7122,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,8818,7270,8425,7153,8228,8942,7277,8939,8939,8832,8832,8782,1257,9189,8412,9138,7116,7096,7152,3830,7289,7245,7106,7272,7119,7117,8269,7097,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,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,7104,7096,8083,7277,7089,7155,7246,7083,8739,7298,3337,6584,7110,7072,7074,7251,8400,7252,7252,7252,8236,3896,3892,3891,8576,7083,7107,7674,6386,7100,4121,4121,7155,8085,8236,7118,8228,7291,7700,6768,4302,6842,3976,2118,7761,6842,6010,3532,3595,3169,8093,6713,6505,8185,2933,3542,219,8220,6314,1347,6264,8547,387,3823,7151,7019,7761,8222,7647,7151,8793,7109,7125,6192,7082,8816,8727,7080,7663,7550,2337,4455,4234,8923,8888,9038,9030,4566,2976,8222,8220,7879,8450,7258,7953,7879,8250,8615,8926,8995,8823,8990,421,8082,7953,9270,9271,7239,7281,9054,8084,7594,8361,9321,8083,7910,9315,9277,8222,8406,9469,9470,734,6168,8220,7238,6740,8998,931,8458,9527,9526,7070,7238,8401,6740,6740,8220,7238,7106,9552,8208,8891,8434,9302,9278,6386,3395,8439,1563,7022,3395,7904,8201,7256,3541,7944,8423,6731,1663,1663,1765,1769,5544,6740,1385,814,8423,10095,9261,9647,7907,179,3590,6828,178,10190,3380,5252,7094,10109,1645,8460,9571,3864,10584,4861,576,9058,7304,5996,5576,2869,7261,834,7079,4405,5371,7666,8361,7115,7106,7897,8463,7286,8251,7286,8251,7287,7715,7287,7715,6940,8450,8240,7938,8362,7671,5262,7243,1126,8644,7906,7072,2033,8469,8852,8891,7109,3882,8891,7270,3892,8438,7270,3893,7294,8769,7266,8724,8576,215,8569,8530,3890,8285,3989,8359,501,7959,8240,8798,8208,5070,5148,8470,5995,7935,3830,7638,8400,2951,735,8236,7125,7096,8641,8227,8050,8407,8396,8364,8396,8364,7265,4131,8422,7265,8422,4580,7297,8042,547,7115,547,7115,8085,9204,8771,7105,8792,1349,7675,8772,7354,8772,7354,9315,6315,9611,8909,9611,8909,9743,9744,9134,2706,9134,2706,6595,9053,6595,9053,5995,7155,5995,7155,5995,7155,8809,9877,8759,9745,8759,9745,510,1145,7665,9378,10320,9561,9564,9480,8832,9259,7261,7646,8266,8450,7124,8048,7671,7572,7075,7103,7152,8529,7654,8771,7243,7115,7155,7110,8364,7125,7083,7715,7765,7243,8082,9132,9148,8240,7291,7251,7665,8469,7107,7647,6794,9032,9205,7646,9047,9189,8446,8580,9259,9076,4973,7671,8768,8769,7247,7249,9134,8423,8852,9315,8439,8443,8083,7094,8060,7275,7666,8451,8034,7674,8770,8358,2643,7109,7268,9161,7104,8447,9314,7150,9537,7647,9133,9133,9573,9577,9619,9748,9622,9621,9747,9620,9560,9580,9746,9745,9876,9878,8085,9876,9877,9956,9138,7291,9744,9873,6151,215,6152,5996,3263,3277,6719,6763,6764,4614,6656,7100,7072,7122,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,8070,7096,9081,8064,7081,7102,8798,7255,7290,7646,7099,7099,7099,7099,8236,8236,7150,8034,8961,7715,7715,8450,7650,7671,8460,6766,7158,2029,783,7249,6004,2006,7834,7903,7998,4046,6971,8204,8204,6894,3824,7081,8087,7659,7149,8206,379,8290,8648,8648,8648,8547,8547,8547,8713,8706,7928,7928,8611,8948,8823,3066,961,8198,8948,9053,9053,8415,8743,7670,9128,2261,8023,7118,7151,7675,2024,8447,7245,8444,8460,8765,8460,3385,8067,8067,7074,9349,6806,8995,8995,6270,6270,2122,8787,392,8858,8786,8784,391,9481,7082,9418,8198,7280,8455,8197,8240,546,539,8085,8339,7238,8342,8332,6726,8338,979,7672,8404,3878,7903,730,7143,7546,8615,8586,7870,8584,4432,8460,512,7092,1461,7771,8583,5020,8398,8401,5995,857,7772,8044,8063,1927,5331,1917,1929,7833,3581,8334,7660,1928,7659,1268,4969,3701,3933,5362,6497,2244,5477,1536,7268,3875,4603,8332,4599,542,536,4600,539,5235,4602,6315,8215,529,320,553,3612,8724,3701,544,8275,8946,8343,547,9291,524,9301,9289,9337,4652,7666,7037,1349,9374,8044,9346,8573,739,9248,7270,8805,8934,7913,61,7261,7068,8915,1741,566,1210,1207,7580,7755,5143,5251,7756,8509,28,2677,7554,7927,7662,7906,7663,8071,8113,8439,7666,7266,8167,8164,8206,6796,4716,6728,7661,7642,7662,7286,8461,8363,7287,1250,8712,7096,8408,8425,6596,8386,7082,7109,7075,8412,8208,7294,8052,8767,8251,8721,8741,7647,7644,8891,8892,8950,8471,8832,8768,7290,7986,7125,7152,9148,3564,7107,8439,8406,6908,7280,7079,1983,8129,9620,9189,9141,7241,7088,8283,9076,8386,6961,9729,9492,9730,9481,4029,9537,7124,7107,26,6768,2555,7258,7115,1988,6578,7551,1296,6984,1085,9469,9467,9784,3169,9633,9847,9524,9845,9494,8200,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,7122,11108,8782,9609,9608,7668,7669,9611,10565,10328,10975,9610,7247,7672,11096,8573,9748,8443,9719,7646,7103,6733,7262,9513,9563,7654,7250,9370,8716,9564,8450,7294,8395,8449,9797,7288,7082,9745,9259,9581,8569,7666,9205,8404,10026,9622,7266,9573,9561,8891,8451,3327,7048,7671,9304,10258,10272,9880,9492,8,9189,9957,10303,10312,3893,543,528,538,8425,788,2023,7174,551,540,8404,532,6382,546,541,553,545,544,536,533,6493,542,531,6031,550,548,8212,8240,8529,7985,8771,547,391,2218,8832,2521,537,526,3881,3894,535,6204,6042,3889,7833,539,7816,8917,529,6788,2573,8274,8271,6650,6880,8273,8462,2521,546,2843,7815,529,542,3883,536,7075,7076,7666,4566,8839,7109,7118,8231,3908,7804,3829,9144,5732,9048,8716,9076,7175,573,3882,7647,540,526,7935,7150,7671,9132,3883,1557,2087,9744,9138,7642,7642,9794,9950,7649,9875,10026,9797,7082,7599,7118,8287) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC