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,1766,2727,3402,4834,5551,2685,986,231,1730,6145,6146,4614,6311,1398,5756,3189,6214,6497,6489,5093,6223,6496,1234,946,6212,5947,3302,2776,6261,3479,6214,1741,2677,6221,6501,6212,8000,6496,1245,2696,8023,7638,8233,7304,3904,8485,8220,1645,8628,8306,8783,8933,8361,3287,9030,9153,9152,7117,446,7117,4079,4796,7548,9600,8933,7155,7107,9750,7917,446,9849,9206,7985,9264,10039,8648,7080,10265,10556,8910,11291,8062,1988,11236,11812,1173,11497,10591,11497,8995,9838,11690,11736,9647,11656,11770,11714,11905,11782,6151,215,6152,5996,3263,3277,6719,6763,6764,4614,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,7116,7295,7151,7105,7246,8365,8070,7096,9081,8064,7081,7102,8798,1245,6381,6743,323,6388,5386,388,3515,858,6503,7107,5909,863,7654,7654,7713,7072,7155,7105,7644,7650,6796,380,7020,726,1250,1165,979,8085,4490,6521,6719,6761,864,5691,6527,1165,6522,6518,6538,6520,6218,4282,397,6985,6719,1767,1704,4298,1685,7576,1084,979,3442,2951,6800,4121,6376,6768,4296,858,397,3875,4286,4289,1967,3863,4121,857,6985,5297,1411,735,8245,6521,6527,397,7201,7599,8243,6261,6512,8314,8318,8317,6359,8334,8320,3875,8582,4931,8249,8490,7365,3510,7751,8729,8694,8692,2779,7300,2828,5635,2783,2826,2827,8597,2815,4804,7180,7184,2803,2805,2806,2808,6222,8654,8655,8816,8696,6521,3828,6542,6381,344,8531,681,6376,2876,8355,8353,9343,8874,9129,6444,6409,8698,2218,1266,6276,9041,8324,7721,810,2208,3337,6540,8882,382,1084,3327,9949,10037,10034,7721,10032,10263,7204,2169,7697,1704,7693,7840,10696,3327,8490,8507,10698,10579,6925,8156,1084,7721,7966,10983,6988,6922,582,6929,6925,11406,11407,10324,11677,10742,11427,6373,6750,979,388,4079,6371,6372,6740,6512,8241,7751,8245,1029,8337,6538,8331,3889,6493,8323,3890,7840,7879,7878,7897,3913,6264,659,8319,6193,8323,5420,6520,8317,8341,6372,9030,713,4299,4292,1371,5484,4297,6103,6519,6518,6103,6518,8584,8585,9552,7870,7546,1770,9300,1765,3702,8222,7303,2992,4769,1656,545,6382,6390,6527,6521,6261,7631,6212,726,510,542,528,512,6869,7770,3515,6513,526,6198,2696,6498,4614,6497,6199,6223,4289,4293,4286,4282,6197,4292,4291,532,4290,842,5903,6546,1266,1165,6359,864,3247,1685,1616,3384,540,5066,3380,543,8244,8249,7189,7184,6042,7180,6201,3581,6652,3879,6733,6653,6223,6218,7176,1245,7179,7187,5332,714,4426,2917,5096,4490,7170,7172,510,7598,7596,7637,7636,8278,549,7188,8599,8329,8246,8328,8342,548,8597,8598,8320,8317,5635,4386,8337,6654,5576,6583,1207,3385,3384,8693,8694,7599,4784,1967,4714,7187,5046,8665,1685,9137,3037,8071,7273,7660,8429,8034,10007,9795,9563,9873,7280,7278,8709,9225,8386,7674,8909,7265,9053,7272,7278,9611,9610,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,7122,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,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,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,6371,6521,6527,6372,6523,6223,6519,6531,5864,6518,6218,6216,6215,6496,8167,6497,6386,6197,6145,4931,8333,8241,8337,8883,8327,8245,8591,6607,6604,8700,3442,7160,3850,5947,1738,7605,4320,840,5362,8150,9425,8531,8674,6144,7599,3358,6971,8345,6997,650,9602,455,9063,665,6382,8744,6151,223,6961,3090,6197,452,9453,452,9453,452,9453,6469,372,9883,860,2490,9989,1296,8683,7241,3499,6718,6691,3455,5927,3898,6751,7705,7703,6715,3336,3702,7048,6587,3337,3337,6584,6584,6367,587,587,525,525,6604,6604,6612,8583,7870,8618,6503,8586,7546,1770,673,8520,2605,9030,9030,1402,1402,9084,8947,840,8826,8730,8814,9104,3598,9060,9319,7295,2520,8815,6700,6700,8949,6631,7273,8922,8922,4598,8326,7270,7270,7374,7374,7374,4121,4121,8154,7639,1746,1557,3073,6688,3071,8824,7670,6138,6138,778,778,1653,7095,7572,7118,7108,3860,7967,6832,6832,7213,7897,7897,5996,5996,7661,7661,6523,389,5165,2992,8268,1537,7104,8055,7263,7602,8033,7258,8087,8087,6388,7082,7252,7076,7079,7705,6521,6212,6223,7698,9781,9591,9592,7844,9312,9590,6220,6497,6498,6222,6496,6216,6501,6215,6218,6221,6214,6499,1770,1765,1771,1767,1769,4298,4304,6928,6932,6934,6938,6936,6935,6604,9088,7195,7199,7198,7162,7191,8825,1730,6596,5961,4292,9067,4259,2084,8168,6491,8387,8582,8352,6967,6966,4614,6970,7966,6965,6415,6968,1557,6272,6385,14,6450,3380,8831,3247,5882,8490,4501,7816,6396,6383,6076,7904,8232,1663,8821,9631,1616,3358,7632,9767,6787,8542,7195,3898,9156,8988,7199,9409,8882,6928,9173,9172,8700,9408,9176,9536,6768,8971,1730,8387,8858,9146,9145,9147,9144,9143,8881,9150,9190,9191,240,9411,9151,8987,9192,9767,8986,8654,8656,9592,8530,8529,536,535,7694,7695,7696,7697,3881,3884,3888,7868,3890,3883,8531,3882,3895,3893,7196,7198,7702,6937,7196,7198,8655,8665,8581,9993,8879,9088,9178,7705,6270,9633,3896,3894,9177,9175,1765,5386,6985,9217,8168,2856,7870,9154,9892,10100,9155,9792,392,386,9891,10097,10099,9894,9906,9891,4305,8242,9903,9951,8274,3887,3885,10136,10147,10102,9909,9908,9950,379,10193,3889,3892,9535,8329,9535,8329,2779,1990,2781,2783,2783,2783,2783,8585,9522,3336,9518,3881,10565,3893,3895,7986,7985,7987,9084,8618,8584,10238,8244,7293,7087,7104,7269,7279,7108,7273,7116,7281,7119,7276,7154,7244,7289,6925,7703,7262,8395,7654,7071,7241,7241,8644,8425,8425,8576,8402,7599,7599,8400,1557,6388,6191,7106,8404,8401,7152,8576,6191,6151,8268,8085,9308,8407,8782,8782,9593,7666,7659,6928,9734,7655,9441,9441,9441,7268,9816,11060,8439,7693,6424,6423,8011,810,9852,6968,6377,979,390,6962,10201,9592,9733,8011,6424,6423,6740,6191,6931,6928,6938,9089,6936,653,6388,8387,9733,7703,6271,9734,6414,8349,9932,9735,6517,9850,6375,9852,6989,9729,9811,6234,6191,6531,8523,6519,2720,6372,726,6396,6966,6995,6376,9408,8244,6518,7196,9165,6371,7200,9909,9903,7845,6968,6604,9520,10194,7190,6383,10201,9905,10218,10264,9734,6937,6934,6423,6359,1616,979,8824,9892,6422,6519,6768,1266,7808,5297,1165,1411,810,2720,6518,5864,9149,10045,9165,9500,10044,6372,9432,1967,4714,9120,9119,10336,10332,3625,10323,6146,1730,8243,10324,8341,9175,6151,7191,7610,10115,3542,1521,7610,7311,6371,5691,7697,7694,9499,10419,10431,6989,7567,6271,7569,10330,10426,7614,9904,9220,10244,7985,10323,3885,3884,3893,3897,6493,3894,7695,10325,9592,10147,7696,10327,6740,24,9593,10333,6519,6372,7868,10645,6518,6371,10642,3442,6517,10103,10647,10328,10330,3515,4282,10563,6234,6375,7238,10637,10728,1704,10726,7608,8881,7693,6989,6082,6272,9846,10036,6272,57,10279,923,3823,3385,10279,1616,3712,5063,10176,2342,10218,10379,6215,10438,9394,6538,1296,9342,6373,10305,6512,10369,10631,10687,8710,7916,10436,4842,10676,8565,4227,7216,8115,6593,10678,10775,8292,10703,9865,3954,10676,8191,6801,10678,10932,6804,10809,8524,10874,6728,10932,10984,10402,10987,10676,10984,8565,3823,10676,1296,6503,1979,11323,2005,8565,2342,5145,11444,11399,6743,10072,7898,365,8651,9555,9437,9859,9767,368,8542,10333,11658,8816,11242,8713,8713,8737,9832,8241,10545,5332,6216,6501,6214,6220,6497,6499,6215,8310,3892,10644,6898,10520,6496,6212,6222,6223,6221,6498,7100,7091,6218,7698,8361,3898,8232,6359,10827,7660,10941,10942,1327,9649,11047,1770,1765,11013,1771,9184,8883,8314,1769,9906,8161,5059,11167,11137,9632,10251,10924,2522,11194,10213,10256,10102,9907,9970,11269,10255,10043,11032,10254,11030,8241,8585,9189,9903,8666,726,6533,11247,11296,10645,10641,979,10179,7605,8729,8435,9767,7107,8946,8512,10471,8109,8230,9300,8903,10751,10056,9525,6971,11587,10474,1616,8526,10867,8816,10803,7815,10074,7751,5454,961,7091,10942,11655,11714,11600,11658,10273,11228,11602,10836,11395,7694,11269,6898,4555,11167,374,11299,8232,7697,2520,2522,11425,6076,11247,11252,11091,8980,8982,8981,6607,8232,10822,5065,10921,10044,10045,10500,10386,10389,10612,7891,6854,6220,10387,6419,11390,11079,7702,6426,8342,4714,6936,979,4614,7569,9909,810,11562,11493,11564,10596,10045,11394,11590,5383,6426) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC