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,4769,7118,388,7119,820,4989,6381,1557,3897,6270,3893,4452,6600,3884,3894,8034,3889,3891,3892,7117,8047,7693,7975,7100,7155,7654,6272,6195,8050,7096,3881,7304,374,1664,6719,7437,858,857,397,1537,5910,376,382,6743,6144,4614,6751,388,6082,380,4302,391,376,377,382,385,390,3090,6742,3728,5371,381,386,6076,385,377,394,386,8168,387,376,8165,6750,393,384,375,388,6270,6066,372,390,3893,7199,6082,368,3879,7238,409,6749,3036,365,8168,1557,392,389,8788,8785,8786,4639,8882,223,7923,4395,8878,2989,8787,6103,6746,367,2117,8877,6493,3428,8881,7239,8982,5770,8983,6204,7175,8358,6785,6144,6538,8856,6386,4714,386,8789,8880,8858,8855,9192,378,7300,6491,8651,3889,3896,3883,3885,4302,7214,3888,979,810,1165,8824,8857,8358,6359,5386,5297,9149,7599,7808,1266,1411,1685,4289,6527,6521,4293,6218,3891,3890,4294,3895,6532,3892,7693,3894,3882,8271,3897,8272,3893,3881,3884,3888,3883,8274,8273,8981,8982,546,554,6537,8980,6381,3885,8879,2701,6377,9698,9713,9709,9708,9710,9711,1766,9718,9435,8241,8246,9593,9592,8310,9684,8598,8249,9427,8243,9425,8339,8242,8597,8245,8247,8248,8318,8317,9428,8319,9435,8319,9424,8320,9436,9426,8328,9591,4286,6199,9891,1768,6519,6523,5864,1766,6532,2720,6498,6507,4300,6222,6497,6515,1767,2795,6200,4301,4936,6503,4305,6371,6529,4301,2720,4293,2780,2785,6504,2783,2778,2781,2779,2782,2784,2786,4290,4298,2787,6530,4300,4282,1766,1769,2818,2824,1764,1767,6263,222,3071,2789,6489,6531,4286,6354,3070,2823,1245,6198,6201,6199,6200,1767,1766,6354,3073,7137,511,7299,7300,7134,1767,2808,2803,3888,3885,2791,2820,2801,2802,2805,2807,2806,2794,6546,1769,2826,2827,2828,6514,1245,5576,1351,2869,834,3884,3882,7160,6515,6456,3891,3893,3896,3892,3890,7567,3897,6493,6271,6507,2720,7300,2677,2995,510,6523,6371,6743,3029,7548,6218,6199,6373,6223,6527,6201,810,2522,6354,6546,3070,7751,6689,3073,3071,1769,6750,7599,6746,7870,6749,2018,7753,6751,3889,3882,6599,374,810,391,387,6066,384,378,382,375,394,376,6082,1266,7215,7054,3898,1250,4178,5647,7752,6354,1766,7598,7600,7676,7137,7631,6809,4445,4827,4512,6354,3070,3073,3071,6689,550,7677,7168,7167,7170,7165,7163,7173,7164,7959,7922,7054,6985,7752,1767,1765,1769,1766,6168,7986,2522,1741,6354,8233,8232,6880,3071,3521,2389,3070,8272,2822,2823,2826,7238,8245,2728,2893,8294,7787,8432,344,8316,8220,8313,6509,6508,8307,7238,1767,6197,8520,8514,8315,8318,1769,5909,6520,8233,8246,8334,6521,8331,6513,6514,6507,6515,8358,4639,4535,5576,2869,834,1351,1741,8481,6505,6261,3913,3085,8698,8681,3850,5647,8682,6534,6537,4178,6535,8730,8520,8333,8649,601,2170,2390,3610,8342,6641,8596,8691,8814,8817,8815,8520,5996,8142,567,7634,7635,5551,8617,8719,2520,8591,8717,2522,8681,2522,8681,8780,8944,8817,7881,9041,8683,2253,4535,8826,8682,8945,6168,223,9030,4639,311,8358,8698,4834,2992,8175,6691,8727,2925,8232,8551,8681,3913,3172,9390,1232,3165,4178,5068,9736,10297,9390,9951,10364,10238,6971,9334,3646,10353,6209,9934,8514,3731,10164,9084,223,4639,6250,10527,7554,7592,4218,8555,6712,5567,8290,10505,10656,3646,10547,10531,7910,7756,10339,9669,10364,9670,1257,4178,446,5376,222,9543,10865,10654,10877,6611,10296,10786,8306,7636,6766,7158,2029,783,7249,6004,2006,7834,7903,7998,4046,6971,8204,8204,6894,3824,7081,8087,7659,7149,8206,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,8365,8067,8067,7074,9349,6806,8995,8995,6270,6270,2122,8787,392,8858,8786,8784,391,9481,7082,9418,1537,418,7096,7268,7089,7121,7125,7084,7288,6751,6750,6517,6076,6377,6742,6743,382,7278,7278,7287,7287,6151,6604,6742,388,6918,1557,6745,7123,7123,7123,3889,7264,7971,7971,3890,7107,7647,7245,6540,6970,7282,217,7100,8055,7649,1666,8641,8050,8047,9229,7304,9797,7124,7099,7150,7150,7150,7105,7104,9796,7155,9794,6963,6174,378,378,6388,6880,6880,6386,6386,6388,6760,6988,6082,6750,6749,3222,3222,3222,3222,3222,3222,3222,3222,8598,8317,8336,1704,4289,8874,5691,7693,6376,8241,6517,6375,6989,6995,6234,6419,6388,8387,7610,7697,7694,7695,7696,3442,7608,3515,8244,1665,6175,7054,3891,1765,6270,8246,382,6995,8788,388,6076,6768,3892,6223,381,391,387,6376,6375,378,8878,376,387,392,393,385,6271,726,5864,6373,6527,6522,9182,8340,8325,6529,6530,8324,8242,8599,8322,8335,8334,6534,6536,6538,6532,8300,5827,6266,8315,8320,8319,8317,8318,8248,8971,6533,6505,6000,385,7067,7067,3840,375,380,8880,8787,8881,8771,8771,8939,8882,8832,8832,381,374,8878,6270,6066,393,9076,390,389,381,8877,8878,372,372,6151,1327,458,6616,3549,6103,464,3428,5334,3997,5882,6798,6840,6763,1663,6157,2998,3449,3069,6427,3389,6491,3898,452,222,4913,6600,6855,6388,2507,4765,3254,3169,6151,2684,6905,6129,464,4659,6181,2164,735,393,6894,6146,2737,1049,397,7195,7199,8656,9088,6523,3327,8387,6545,8305,6604,8592,6616,6719,6700,9151,9190,3879,8097,6521,7400,9502,9647,9502,8566,8883,3883,385,8882,380,8878,378,8329,6204,6517,382,393,8858,8788,9767,389,7588,372,375,8435,9882,384,390,386,8542,7388,381,9899,10054,1666,7037,7587,9229,7587,9229,391,9856,391,9856,391,9856,9438,8273,6493,6204,3897,8878,4659,7607,713,8861,8861,8866,8866,393,382,6381,6381,9692,9692,376,391,8858,390,3898,375,6076,6076,7631,9119,9588,9592,7696,7868,9907,9906,9407,9501,6688,8946,8682,9084,9501,9665,8883,9184,9144,9145,9920,7546,9147,9424,9434,9665,8878,9590,9589,9587,9535,8943,4304,4301,9522,9518,8323,8325,9522,9518,8596,9182,8246,8244,2827,2826,9433,9428,9515,9520,9521,3897,9593,10043,9432,9891,3897,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,6656,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,10193,3889,3892,9535,8329,9535,8329,10194,1770,8910,10254,6538,10217,9406,10215,9601,6354,7020,3070,6536,3073,6533,4305,3071,4282,6689,10158,510,10333,1768,1769,10332,10323,1771,7610,10188,7311,7753,5691,6354,7697,7752,4300,8088,1770,9536,8245,10045,7610,10194,10335,10334,10429,10217,6151,10336,10199,9408,9588,9589,9903,7570,8983,8981,6743,3883,10222,1730,9165,9601,3898,9534,8982,6742,10167,6744,6746,6749,979,6359,7599,6768,5386,8879,9217,6750,390,8241,8334,10334,10336,10335,9920,10238,10194,10200,10263,8877,382,8330,8320,8339,8337,9891,9908,9113,10202,9111,8242,8873,8872,8649,10152,9112,9120,9431,8318,9114,9119,8326,8310,8247,8313,8309,8308,9633,5691,1685,5386,6195,1765,10546,10545,7845,9633,9903,9905,6533,2605,5386,1769,8824,10546,9909,9137,8824,1685,5784,10522,9137,9149,1770,8917,1771,1765,10925,8824,8489,7869,1967,9031,5770,4714,10645,10646,10750,11167,10925,10922,9985,10466,8592,5810,390,8784,8788,8881,10613,11051,11248,11247,8882,7134,7877,2071,9303,9350,2506,11239,4714,11022,375,8787,372,376,368,381,6066,387,8858,385,380,393,375,391,386,6082,378,8784,394,6270,8880,392,365,8878,8786,8789,10896,11088,11327,11329,11182,11231,11249,6375,11178,6271,6076,6537,11173,11176,11175,5332,1411,810,10521,11183,10827,1266,6535,11229,11174,11186,11252,11185,10921,11238,11519,11295,11296,6505,11318,11294,11239,11254,11301,11251,11585,11571,4923,10731,6600,11085,11665,4520,11666,11667,11085,8175,10823,10278,7922,6354,6503,6523,11425,5383,11429,11085,11249,368,8693,8692,8694,6359,8656,7703,6271,726,9734,7199,11081,6520,11429,8655,11393,8585,11181,8696,367,11085,11238,6744,8855,6270,10167,11390,11080,11181,7704,8982,10613,10169,6491,8655,375,11460,1770,10753,9407,10687,1765,7631,1771,10644,10642,9520,1767,9084,1769,10647,8586,1768,11321,11427,9217,1766,6354,11432,11218,3073,10645,3070,6689,3071,8618,10639,10752,6688,10463,10643,11320,9633,10641,10332,10323,365,9231,10325,9665,10053,10957,11650,10975,10544,11221,10326,9144,10331,7753,7752,11677,9792,9147,10327,9217,10328,8627,8088,9156,9679,9037,10232,10329,9867,9383,10232,9867,9383,10232,9867,9144,8944,8943,10463,11085,10637,10333,4701,11677,9912,9911,11723,9232,11618,10330,11493,11799,11050,9147,11354,8727,11069,11836,6800,554,11001,9473,11878,11877,11101,11587,4282,11898,11899,11876,10098,6388,9144,9468,368,365,386,6076,8880,11568,6270,387,376,10431,10332,11694,11898,11467,9184,8596) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC