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,7238,546,6658,857,5742,5733,4716,4437,2041,3863,550,8220,6381,553,7539,529,7149,8440,532,539,323,313,397,860,6386,549,8542,5853,6769,526,7704,538,528,525,7704,5853,540,551,864,544,1730,545,531,543,391,535,541,387,536,382,1271,4769,376,524,377,365,376,374,6270,384,2856,8787,368,6066,6082,385,394,6197,8858,372,6076,317,3913,317,3913,6382,6523,8165,375,8496,3879,7588,8989,8530,8160,1380,3823,6854,6391,8159,8157,7300,7605,4701,8785,6144,9437,9435,8244,9438,8340,3879,8699,8874,5770,8316,9146,9414,9409,8700,8245,9436,9425,9408,9184,8883,8329,8247,9182,9415,8332,8318,8324,8326,8319,8241,9592,9183,9428,8248,9431,9894,9150,9143,9534,9190,9908,10045,6768,9300,7632,9154,6396,4501,10056,9792,9891,9155,9156,9217,10202,9156,10198,9854,9217,9502,10193,9502,10193,10197,10195,9147,8333,8335,10099,10102,9151,8330,10218,10147,10333,10322,10323,10217,9412,10102,10336,10332,10334,10101,10331,10100,10324,10140,9433,10213,3892,3890,529,6371,6175,2467,6151,1738,4289,7741,5691,5904,1462,6212,7913,6742,391,3885,4512,8700,5386,6953,2164,8388,2455,4701,8780,4769,9391,3515,1116,8247,8980,4424,6832,735,8896,2989,222,7178,6181,3036,223,8899,2389,8242,5567,7186,6444,961,6377,452,6523,9692,6652,8825,7189,9559,9631,7764,8279,8816,2778,9996,7762,7570,4437,9949,9970,9338,9792,9880,1245,7725,9763,9665,9616,1770,9950,9492,52,1765,7,9906,9951,1771,9480,9880,10219,6115,9424,3913,10102,10199,9835,5484,8432,450,10154,8257,8727,1250,9669,9782,2780,4701,10188,10110,7751,8151,4639,10155,7972,7973,9670,9892,10155,961,9671,9033,9131,8822,9672,9673,5175,576,9168,6119,9473,6003,1766,4500,5769,4349,2605,4338,979,5678,10156,151,9473,4800,9720,3081,9722,4901,10281,2467,10071,8566,8967,10655,11097,10187,10991,11025,11116,11105,11135,10974,11104,9,4424,11052,11072,10554,9959,8173,10886,11092,6181,7205,2079,6820,8507,11306,10550,1774,7048,5531,4510,11118,11260,8970,10718,2169,11045,10483,11053,11279,11482,8565,8721,2056,11099,11449,10941,1887,10947,11283,11253,6267,6118,10133,8946,9846,3327,7888,961,11638,11886,10477,11622,10682,11328,9390,11908,1265,11853,3105,3081,6821,10886,11749,4580,11744,11603,9505,11854,7214,8303,11439,10211,12001,11676,788,2748,11776,11720,9062,11452,9649,9865,10844,10667,6218,9288,9149,3889,3891,3892,2331,5947,1967,381,7599,6788,7808,1411,810,1349,6200,8935,6198,4282,9197,4291,4304,4297,4287,7697,7694,7695,7868,6212,7693,6521,6520,4652,4386,6654,7182,8896,7189,7185,7178,7179,6652,7184,7181,7183,8897,7188,6653,7176,6214,7180,6497,6499,6216,6501,6498,6222,6218,6215,6220,6221,6212,6223,6511,6531,7845,7844,6510,6509,6508,6513,6514,6515,1165,6507,7843,1266,1685,5297,1349,9248,1767,1768,1765,1769,7170,7172,7174,7173,4473,7165,7164,7167,7187,6512,3073,6354,3071,6689,3070,6688,7753,7752,8088,8627,9037,8946,7186,7166,9383,9867,8943,8944,8945,7881,7599,9679,1368,7636,848,4121,5064,5053,1765,1770,9911,9912,7972,7751,7973,8276,8275,8278,8888,8728,9343,9722,9721,9720,9723,8816,8946,9669,3359,2951,1371,6743,6523,6141,6141,6396,4519,1746,5602,5602,2677,924,924,6149,6377,3895,6622,6622,4788,1398,7670,7670,5995,1764,1764,4079,7593,7593,6151,1730,8220,8220,7072,8067,6809,7082,7082,8233,1198,3803,7068,1992,5998,4770,8326,8244,3850,8245,8268,8329,8247,3392,1234,8246,1049,6659,7093,4519,4519,7878,7878,7656,7656,9425,6521,9381,9381,7108,8002,8002,7761,7761,8793,8793,9548,9548,6146,6800,5997,3872,9189,9554,9376,9376,9558,9558,9537,979,8340,7194,6386,7196,6191,9111,8599,8248,9165,8244,8883,9114,6146,8246,8881,1266,858,9119,9120,8341,8307,6375,8247,8311,8699,3891,8700,8242,8873,9425,9424,8337,9433,9432,9431,8334,9534,9536,1462,8326,3402,9592,5770,9114,9414,9411,8342,9518,9427,9144,9522,9517,9426,8332,8335,1990,8598,9412,8249,8317,8328,9409,6382,8245,380,8596,9436,9386,9428,9480,8874,6139,9500,9183,9535,6371,9590,381,9591,8333,3883,9588,3891,3882,3884,3892,3881,3890,3896,3893,9587,3894,8168,8597,8323,8243,8241,9589,9588,9416,8326,8325,8319,8316,8329,9434,9408,9412,8324,9908,8330,10102,10101,9868,10096,10099,10137,10139,10140,10147,10136,10138,10152,10153,10151,10198,10200,10195,10199,10202,10213,10217,10214,10216,10201,10215,4294,10194,10218,8649,10197,4296,4291,4292,10280,4282,4293,10098,4293,9633,10098,10333,10331,10330,10333,10331,10332,10323,4305,10324,9429,6201,10336,6199,9631,10322,10193,10100,10551,10328,10557,10560,10563,10607,10555,10556,7189,10326,10327,10562,10335,10103,1770,1767,1771,1769,1768,1766,10646,10643,10753,10647,5756,8894,10645,10639,10641,10752,10640,9880,10644,8887,5863,6820,6727,10874,10962,11073,9514,1768,7256,3073,3070,6689,3071,7753,8088,7752,8627,9037,1771,3897,9665,10053,9856,3884,7986,3887,7985,2787,2824,7567,9493,7569,7762,6534,2801,6505,6532,4282,6514,6212,735,6496,2786,6216,810,4298,4293,4305,6222,4294,4944,4942,4945,4941,4940,10531,4943,4939,4938,8478,2183,8343,7697,8154,7694,8002,4298,4289,6354,10327,8584,3070,8649,7546,10519,8618,7843,8682,9084,1704,7870,9407,7844,10238,7631,4121,7845,9920,9632,7695,9920,9633,6197,6199,6200,6493,7986,9631,6198,7985,6201,7987,8272,6260,3884,3883,3892,3897,8154,9905,3881,9909,9119,8260,6520,6521,6373,6503,6523,10924,6504,10920,9903,8321,8241,10324,10563,10331,10329,9522,10333,10331,10329,8244,10323,10921,10922,4293,4282,4294,7963,4287,5792,3442,7696,6855,10565,10827,10750,7698,1766,6214,6499,6218,6221,9920,10238,6212,1766,9517,6496,6501,9515,8154,6216,6223,6497,6215,11069,6222,8586,11067,9084,9522,11252,11190,5383,11192,11194,11243,10797,11245,7610,11246,9407,8584,11181,11191,11251,6538,6503,8703,7172,11177,7567,11176,7170,6537,11175,7174,6536,7173,6535,11186,6596,6534,7165,11354,6506,7164,510,10639,10752,9518,9521,10753,7168,8917,3719,10637,7167,11320,11321,11461,11493,8585,11218,11466,10849,9520,10923,3894,11019,11422,11431,11459,11407,11240,8247,8242,10606,8703,11191,11193,3070,11375,11432,3073,6354,3071,6689,8088,7752,7753,2780,2789,2812,2791,11464,1589,11493,5792,2779,6896,2787,6688,4512,9129,7751,7972,7973,8946,7184,11148,11147,510,11146,11722,7770,7772,11656,11405,11615,11419,11618,11465,10278,8436,11723,4282,3997,11792,11421,10332,11677,11792,3327,11799,11696,11697,10522,7938,510,4294,10325,11617,11186,11419,11176,11251,11252,11429,11575,11194,9232,11245,11244,11243,11574,4305,11190,11246,7972,3874,4146,11068,11878,11899,11081,11425,11031,11032,11037,7770,7772,510,7771,3282,3719,4580,11051,11033,11080,510,3719,6879,3115,11458,11922,979,11935,8174,11876,11355,7808,9149,11877,11759,9624,3559,3115,933,9986,344,11015,10868,8596,8324,11139,11047,11054,10139,11008,4301,9590,10920,2820,2824,2808,2816,2821,10963,2778,6489,735,2951,9378,4405,6441,554,7300,3073,9418,7024,8627,8088,6688,3883,573,3884,10228,10336,7985,549,550,6386,539,551,9483,7987,10072,10649,1765,8971,1771,5839,1767,7704,7706,1765,9949,2605,1769,11028,3877,10607,1768,1766,531,10044,9502,2822,6489,10963,2779,2785,2786,2791,2778,3359,2799,8192,2816,2522,7698,6596,510,4146,10067,9633,10922,10923,10924,10433,11017,8582,2808,2812,2781,8154,11071,11068,11067,9555,9554,8241,8244,3784,2817,6354,3070,3073,3071,6688,6689,7752,7753,8627,8088,11161,9037,11238,2820,6521,2794,2789,3891,3877,4305,2818,9665,10053,10544,10975,524,11221,526,9383,9867,529,6855,10232,8943,11407,8316,8944,9418,7881,10644,11390,11393,10640,8878,10645,374,11422,11109,11406,6538,11320,525,6537,538,6536,535,6535,542,6534,540,11321,6506,6505,6533,6532,4599,4598,8727,382,735,9184,9679,8596,6442,2824,7999,7998,10857,10866,11523,11131,10930,10931,6520,6199,6200,9632,9631,10098,6197,10433,9885,6198,6201,6522,7610,6527,7311,6995,6234,6517,11182,11037,7694,11184,6376,11185,11249,6499,11181,11183,10426,10812,11430,7697,11420,11431,7179,7180,7178,7187,5635,11069,11177,7695,7868,3385,6800,7986,10828,7903,9614,6527,2720,4294,9905,5383,1765,11055,8971,6517,4293,389,6263,1511,11156,6521,1769,6146,8584,11218,10332,9908,381,11241,11242,11022,2522,3888,5576,2869,3883,1351,834,3884,7019,8274,8222,7761,8271,9195,8793,7987,9925,9552,3890,8573,3897,6520,766,6521,3882,7672,3893,11429,3881,3896,3887,11430,3894,7286,11750,3891,6521,11121,9609,7244,6493,3884,7280,11650,10920,10938,3895,8268,3888,10921,11427,3893,8343,8741,10921,11425,6521,10923,10834,9905,5383,9199,9909,535,9658,11186,3892,6520,3997,653,11212,4282,7086,7285,4305,4298,11370,554,4301,9082,524,10827,6596,525,10888,526,11188,4293,1379,8581,4614,4304,11695,11690,4292,4289,527,532,528,4294,531,529) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC