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,8064,7083,7840,7878,7879,7104,7099,7082,6110,7096,7278,7249,7107,8065,7110,8049,7094,5770,8070,7960,2635,6544,8452,8384,8381,8393,7931,7895,8406,6131,7105,7654,7247,8407,7112,8349,7124,8041,7266,7106,7261,7717,8084,7246,7100,8461,8464,6968,8409,8407,7670,8408,8644,8641,8394,7277,8396,7153,8083,7266,8203,7251,7112,9053,7286,7666,8406,7258,8430,8404,8782,8473,8072,1343,2658,8683,9247,7082,8470,8644,8047,7085,9259,8034,8460,9225,8398,8462,7252,7095,9205,8832,8431,7943,7115,8475,7084,8395,8082,9573,9578,9579,7253,7272,8033,8473,8370,7589,8635,9204,7147,7655,7123,8066,7093,7076,7254,7280,5947,2934,5719,7708,8909,8053,10659,10586,8407,10675,10690,9386,11124,10573,10859,1990,10773,8781,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,7097,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,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,8445,8514,8460,5961,8424,6817,7655,7077,8289,8439,4774,8423,7605,8386,8398,8034,6,8400,8395,8423,8384,5996,7304,5996,5576,2869,7261,834,7079,4405,5371,7666,8361,7115,7106,7897,8463,7286,8251,7286,8251,7287,7287,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,8365,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,7294,2780,7072,7261,7286,7122,7068,7094,7108,7107,7104,7283,7266,7081,7121,7154,7119,8240,8228,7946,8349,8207,8406,8396,7967,7279,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,7107,7150,7104,7150,7118,7120,7297,7099,7155,7105,7107,7246,7103,7298,7151,7118,7083,7107,7094,7650,7671,7298,7297,7671,8240,8450,7649,7650,7654,7291,8961,8269,4224,8645,9032,7935,8048,8064,8430,7115,8450,9189,9148,9132,9132,7671,7671,7666,8240,7068,7245,8049,8470,8055,7115,7104,7112,7069,7094,7089,7666,8287,8365,8450,8417,8050,7115,7111,7288,8084,7096,8047,8743,8212,8406,8736,8644,7244,8080,8084,7261,7646,8266,8450,7124,8048,7671,7572,7075,7103,7152,8529,7654,8771,7243,8365,7115,7155,7110,8364,7125,7083,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,7255,7290,7646,7099,7099,7099,7099,8236,8236,7150,8034,8961,8365,8450,7650,7671,8460,9225,9338,4234,8063,9082,9362,8644,3884,7121,8615,6134,8412,9264,7280,9398,2677,7984,7932,8306,8423,9662,9382,7661,7759,9658,9464,7662,9148,9659,5179,9844,7108,4947,7023,1533,3493,9563,1461,2995,2417,7986,4046,4769,10076,3863,8891,6781,8449,10026,10051,9220,10212,10077,10126,9821,2644,2455,10025,5454,10185,6209,3875,10270,6986,1370,7280,10275,10273,4906,956,7149,9444,10436,10063,9787,10506,9325,10149,10314,8782,9543,10523,9741,450,9533,10271,10578,9822,9747,180,4724,8972,8762,10768,9492,3891,1370,10767,7985,4762,10257,10890,8071,10854,9373,10882,9993,10888,10302,10881,8783,6102,10554,9608,6876,10887,7251,10190,3863,10789,10702,11130,9793,10078,10938,5251,8743,10965,10991,11025,11027,11188,11224,10823,5331,11212,11268,11189,4778,11278,11196,11281,10670,10701,11038,11262,11329,11187,11337,5454,11108,11376,9795,10274,10412,10187,11402,11336,7913,8474,11215,10862,11455,9199,8423,11228,11524,9417,9308,11331,10839,4645,7261,7792,4791,10615,11449,10072,11511,4355,11633,8721,11302,7986,9817,9481,11628,11484,11700,9993,11038,9649,8366,7363,7094,11117,10818,11629,11760,4401,11797,3883,11758,11444,10891,11776,1371,2677,10360,11553,5331,11793,11327,2658,11105,11763,11101,9398,6904,721,11712,9554,585,8460,10716,2331,9300,801,7654,9488,8082,7110,3913,9897,8947,7283,7283,7674,7674,7713,9049,9049,8575,7079,7273,9189,7111,7121,7084,8401,7286,7244,7280,7986,8395,7262,7109,7714,9314,8577,7713,9082,9623,9370,9199,9743,8772,7096,8086,8722,7671,8207,9793,8712,9446,8423,9441,7251,8049,8034,9816,8766,8041,8791,8770,7275,8537,9819,9457,9818,9205,9508,8383,9738,10030,9560,9563,8439,10077,9053,8406,8386,9817,8767,8203,8085,9083,10026,10186,9999,8394,10789,11631,11376,11045,11508,11555,9509,11654,8081,11746,8087,11712,8424,8740,8568,7268,7245,7088,10575,8413,8720,11367,11531,9057,11096,11692,11693,7264,9095,11668,11188,11189,8470,8383,11225,11332,222,2387,3625,4362,1257,6104,223,5995,7083,7078,435,5251,1207,7143,7833,5371,1533,4784,4046,7966,4983,7751,7972,7972,7599,7973,7973,4791,7033,7033,5143,1439,2989,7261,8377,7659,8406,8406,7100,7644,7266,8288,7076,7091,8404,3327,3327,6609,6609,6616,6603,6603,6603,7655,8251,7089,10406,9793,8791,8646,8412,9441,8428,10851,8462,7077,8721,8206,8537,10615,3702,8475,8080,9573,7674,7122,7287,7971,7125,9055,8449,8770,8449,7655,10401,7286,7280,7714,10475,7662,10272,7265,8571,7660,8451,7281,9148,8288,11692,6898,272,8820,6388,7311,7610,6600,6416,7922,8944,7881,9679,10232,6416,9383,10427,9867,6386,10232,10431,8566,6377,545,3887,537,7703,14,6200,7166,9902,8885,8693,8732,726,810,10613,10386,9172,10387,10098,9734,10420,9905,9735,10638,10383,9601,10429,9909,9087,10643,8011,10645,8696,8232,10432,10644,10640,365,1411,4614,10421,10637,10334,2701,6332,10389,10433,9733,10520,10443,6381,6380,10431,7192,7190,10213,10222,10162,10725,9892,6385,7014,6382,7040,2287,6933,9591,8665,10238,9903,10565,10044,2605,4178,6519,10561,5995,10043,10649,5790,10632,10690,11027,2736,2761,11104,9959,2137,3100,6103,9543,6740,11103,10784,11128,11126,11142,11202,11217,11112,11235,11237,3908,11123,10951,11222,8214,4079,3728,5013,4665,10127,3346,9810,10355,10269,10870,8010,7990,6622,10611,2615,6348,11220,11349,10937,6633,11423,10125,11136,11226,8144,9757,10976,11065,11281,8763,8626,11041,9546,11129,11094,11352,9479,11288,11258,11105,11107,11604,10085,11491,11598,11495,11595,11498,10971,10668,11480,11132,11230,10655,11496,11521,11658,4950,3197,4724,11733,9406,10569,10786,11127,4882,11439,11747,11449,11492,9539,9541,9602,11550,11787,2092,6264,9132,9797,8439,7297,9552,9741,9739,9740,9738,10869,7987,8071,7714,8530,4399,1122,10379,4769,2843,8034,7674,9118,6895,4406,2179,10269,10056,8477,9813,7280,7084,8393,7271,8394,8876,7913,9562,7103,8474,9261,8415,8417,8394,8208,9161,10185,7250,7660,9594,10356,7115,8282,9370,9956,9821,10507,7298,8892,8891,10025,10570,10577,10508,10576,10629,10272,10574,9999,10623,10625,9744,9873,10767,9875,10399,9877,10077,10882,10881,7971,8411,9509,10965,10302,8468,10630,9148,9316,10833,9609,8071,7933,7241,7108,10076,9259,8567,9264,9563,8474,7295,10811,11108,9053,9225,11124,8282,10625,11125,7271,8736,8794,9662,7270,9650,10451,8285,9574,11262,7243,9577,10906,9293,7261,10773,10835,7092,10011,11331,9756,9755,8370,9053,8571,10451,7656,7657,9659,11376,11274,11273,10475,9660,7298,8411,9876,9797,10855,10854,9367,11275,10022,11472,11515,11516,9141,10271,11532,11534,11508,9302,11693,11692,11711,11573,11711,9398,11535,11536,8743,8415,11540,11539,7250,11108,8087,11671,9058,9059,11700,11777,8052,7271,8238,11472,11534,11279,9610,9609,11262,8892,8891,7281,11628,8460,11629,8711,8580,7088,8735,7086,9572,7289,8052,11881,9187,8087,11892,11889,11890,11513,11882,11887,6134,9056,11063,8517,10887,10887,8418,10507,8418,9205,8384,10887,7265,11065,8472,11336,11045,11334,8358,6103,11385,7610,11052,7311,11365,11251,11421,11130,11419,11422,7892,11013,7697,3997,10981,7696,5635,1927,9555,10906,11187,11463,3997,11116,11269,6653,11063,11376,788,4386,7172,11402,3442,7186,7286,10272,8228,10980,10850,8364,7176,11370,11431,8280,11515,9082,9473,4558,11539,11497,9500,10433,11556,7890,5763,7269,9959,11496,6873,8965,10655,176,2145,10655,176,2145,10655,10805,7178,10480,11365,11795,1016,11780,2791,7179,11150,11768,10526,11746,7374,1327,11063,11130,10789,7280,8395,7944,9509,9205,8577,10077,8770,9134,8384,8395,9563,8644,8407,8408,8406,8404,10510,10675,8783,8082,7933,7674,8394,7281,8423,8771,11125,8737,9793,11370,11511,10869,11332,11124,11508,8580,9539,8212,9529,7280,10887,9817,7285,9578,7660,9134,11553,10768,11131,11331,10906,11671,10767,9795,7088,7086,8423,11758,11693,9540,11692,10869,8832,11188,10272,11096,11795,8709,8741,9816,11634,8740,11402,9259,11472,8763) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC