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,8248,8314,8339,8320,8336,8313,8598,8338,8271,8272,8335,5297,8088,8727,8003,7881,8627,8260,8873,8872,8946,9115,9112,9111,9114,9119,9120,8872,8088,3719,3115,3559,8705,8704,8174,3115,3719,3559,8946,8003,8333,8309,6371,8699,6372,8317,8332,8330,8328,8312,3559,8704,8174,3719,9625,5995,9592,8306,9411,8088,1257,9410,4947,3493,2033,2915,9383,6710,9661,6986,6876,9910,10102,10101,8031,6779,1881,9749,10227,10229,1520,8681,8698,8817,1308,1626,1215,8314,8246,8316,8315,8318,8334,8244,8322,6743,8326,8330,8307,8649,8313,8311,8319,8335,8331,8249,8308,8873,8872,8585,8586,8682,7546,7631,8585,8584,7870,8247,8335,8317,8329,8332,8339,9114,9111,9154,9156,8308,8309,9119,9120,8583,8618,9115,8341,9112,8598,9183,9114,8699,8340,8342,1411,9137,979,8824,8329,810,9154,9151,9155,9190,9084,9407,9433,9432,9431,9411,8328,8339,8583,8618,9416,9410,9520,9434,7187,9521,8349,6794,6391,8314,8245,8350,8316,2474,8317,8320,8315,6965,6396,8246,8249,8334,8243,6512,1726,8244,8319,8331,8335,6512,8356,6393,6939,8351,6807,7546,6967,6510,8357,6383,8354,6174,6961,3248,6607,1738,6527,8884,6966,6984,7964,6221,6511,8336,9159,8245,8328,9112,9119,6497,6216,9052,9145,6110,3076,6396,6965,8349,6962,9111,9156,1726,9120,9143,9150,9030,6646,9144,6383,7157,6961,1828,6963,8306,6806,9482,9407,1886,8785,9084,8682,1084,8618,8786,8788,8542,8389,1662,6787,8290,7027,1884,9507,3169,9547,9374,9090,9386,8435,8196,9729,9497,6520,9713,6171,6533,1770,1766,5692,1767,6263,1770,5743,124,9482,9868,9668,6538,8243,9431,8323,8249,8599,8333,8330,8337,9426,9183,9184,7693,1768,8307,8309,9416,8246,8335,8241,8315,8326,8700,9415,8312,8311,8316,8313,8322,8331,8327,8334,8336,8320,9424,9428,8317,8598,8245,8597,7546,8583,8584,8585,8329,8682,7631,9407,9517,9520,9112,9119,8247,8314,9409,8272,8872,9894,8342,8649,3359,9182,9407,1768,8088,3071,6688,8681,8817,8698,10753,4512,10232,9867,8944,9084,8586,8332,10645,8875,9114,9120,6794,6189,1738,5877,6971,7240,3277,1057,6145,2530,3131,3754,6563,6350,6596,2477,2571,4834,4769,6578,6727,1707,4422,9112,8873,4437,863,9111,8872,4860,8649,8872,9049,4920,8315,9182,8315,9182,8247,8340,8700,9408,9425,8324,8244,8329,8325,8246,9233,9587,9183,9426,9111,8249,8248,8245,8241,8873,8872,9427,9433,9436,551,8882,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,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,379,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,10332,10327,6197,10607,10328,1411,7567,2820,4297,10558,3515,10563,6201,10218,4299,8332,10158,5386,7569,10137,3442,10099,4292,10333,2826,9593,9430,10200,10560,7696,4293,4305,10322,9114,9426,9424,9409,4298,9112,8883,2824,10136,9894,9633,4304,10215,8662,9908,4294,6200,2825,10218,2823,8727,1765,9120,8326,8627,1771,9626,4296,1768,7174,9037,6689,1767,2808,1766,510,1771,9473,8944,9669,9407,7752,7677,8627,9920,8432,9474,10154,10725,10642,8971,10139,9665,9475,10155,9601,10298,10729,9493,10238,10522,9383,10637,9867,8586,10152,5576,10877,7636,10232,4386,848,1368,9687,10828,7580,9031,10641,11048,11008,6800,11046,7870,11088,11019,10329,10864,9854,9911,10645,11007,10565,9912,10463,10647,11047,10866,10923,10646,10154,4464,11014,9046,7019,7165,10155,7166,4486,8780,9215,4470,7761,10157,7677,10156,7551,8222,2818,10519,11051,8793,4855,2816,11109,11183,11184,11022,11192,10706,11193,9168,10053,11191,2780,11241,11231,11242,9690,11149,2791,10544,10335,8326,10099,10555,10322,10218,9119,10332,10323,10325,10326,9592,10326,10327,10193,8649,8872,8873,9112,9111,9120,10328,9414,10100,8320,8319,10551,2605,2605,10324,10329,10728,10331,10330,10334,10726,8312,10103,8313,8599,9183,9409,9411,11085,11082,10159,9410,9590,10563,10923,10140,10147,8308,10924,9435,9436,726,5864,6504,10594,10596,3066,10600,8885,7014,6381,10522,10922,8586,8682,9920,8618,7891,10612,6191,10996,10998,10193,10197,10195,10200,10597,10640,10641,11054,10645,10639,10838,10753,11139,10999,11011,11012,10993,9410,9411,9416,9429,9430,10139,10151,10153,10176,10637,10199,10642,11055,11138,9232,11049,10799,8875,9114,9182,11157,11158,11159,11160,11154,8662,11155,11057,11153,11156,10800,11008,9587,8325,8596,11152,10201,8324,10557,10556,10558,10559,10561,11161,10562,9589,9593,11242,11240,11046,10801,9588,10333,11238,11207,11151,11218,10727,11149,11241,9781,10646,11204,3784,7568,7569,7570,8330,8331,8336,8339,8341,9633,11209,11244,11245,10644,9087,10337,4804,6221,6497,6214,6220,6216,6501,6218,6215,6499,6212,2720,11203,11269,11205,9593,10323,11183,11178,11231,10326,10198,11184,9137,11301,11206,11176,10102,11009,8309,10096,10322,8872,8242,8327,9424,10334,9891,10218,8335,10214,8329,10920,10646,11320,11322,6538,6534,6532,6533,6536,6505,6506,11318,8883,1730,7169,10827,10828,10750,10829,9426,4714,11242,11167,11238,11295,10139,10752,810,1266,10725,10729,10522,11317,10557,9430,9592,9535,9894,10101,10102,10326,11405,11157,10556,11048,3896,3895,3893,3889,3885,3883,8272,6493,3897,3894,533,532,528,527,526,525,551,550,548,542,541,540,3892,3891,6042,553,539,531,524,3890,3888,3887,3884,11296,4510,6381,11430,7986,7987,537,8274,10137,11467,10321,8764,4558,8111,11432,3881,11407,10324,11022,6214,6223,10801,11247,10643,10647,8273,10466,8682,7546,11161,11405,4791,6223,11493,6518,6519,6535,6537,6372,6371,11294,6498,11254,6496,11139,10560,10201,6215,4555,9108,10822,11394,11584,11585,11586,11590,10216,10562,11574,11591,8335,8329,9412,9409,8332,9425,9427,9428,11617,11624,11625,9431,9432,11616,11615,11241,11589,11591,11601,11375,11650,11425,11575,11580,9905,11588,11592,11229,10921,11173,11174,6521,11429,553,551,550,542,541,540,539,537,533,532,531,528,527,526,524,545,543,538,535,529,554,549,547,9520,9521,9587,11321,11611,7546,11493,1768,1769,9880,1766,9920,11427,11697,8294,10321,3066,8294,6212,6501,6496,6214,6221,8883,6223,6222,6216,10216,11054,11156,11154,10639,11723,11618,11677,11759,8340,8334,6042,3883,6456,323,6453,6455,6454,6390,11650,6995,10371,10138,8331,8320,8327,11571,11030,11696,11031,11695,11032,11461,11460,11033,11406,10925,8273,11799,10520,8585,9149,4390,8154,11069,10257,10521,11078,11079,11080,11081,11077,11051,11791,6354,11576,7194,673,11075,10797,3070,3073,10053,10975,10544,11221,11587,11590,9037,8627,9434,8946,8944,9436,9383,9435,9867,10140,11242,11241,6484,10232,8649,10140,9665,8873,8872,10053,9112,5924,11677,4558,4121,10637,10644,11690,10983,11121,8585,6740,7238,11697,5942,8950,11181,11354,11037,4121,11182,11037,8111,8706,11183,7734,2488,5227,9692,9303,2071,9084,3874,4146,6354,3070,3073,3896,8946,6688,9665,10053,10544,9665,10053,10544,11203,11405,11583,11430,11209,9147,11207,11205,10487,3879,6425,11429,8873,10214,11080,11206,11204,11081,391,8649,8872,11582,9184,8883,11564,11581,10216,6521,11204,8696,11078,11079,9231,11406,9111,9112,10215,6424,8655,9588,11139,10152,10151,11076,11077,8665,9414,10158,10560,9587,9908,9119,11075,8649,7114,10102,8872,9424,8241,10158,10217,9055,11601,11247,10214,11240,10099,11217,11226,8873,10728,8322,11291,10324,8244,9111,10151,10159,10152,8883,11617,11285,9119,9426,10555,10323,11238,9908,11167,10322,9970,10640) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC