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,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,6526,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,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,10158,7986,10218,8342,3897,10324,7985,4282,10324,9920,7172,1411,7987,1770,3893,3897,1765,3884,1771,6768,1685,735,1767,6200,4769,4931,240,6143,10194,1770,8910,10254,6538,9406,10215,9601,379,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,9114,9592,9410,8329,8245,8323,8242,8599,8320,8332,10153,10200,3442,8700,7696,9424,9407,8334,8682,7546,7631,9084,8874,8318,8584,8316,6496,8317,8597,8335,10214,8598,9114,10216,10215,10336,10101,8584,10213,8586,9182,8310,8307,8314,8244,8307,8311,8308,4305,979,10521,9729,10545,8313,10334,8309,8312,8336,10335,10607,10522,3070,6354,11069,8154,11071,8002,11067,9720,10868,10526,7752,7753,6688,8946,8088,10486,6426,6854,6545,6425,6423,6421,9087,6922,10489,8267,6426,6424,10486,11817,9535,10200,10139,10201,10197,10215,1768,8387,381,380,10199,375,7188,394,372,376,176,9430,10322,4390,10545,1411,9137,4512,10521,10562,9587,10556,9589,9588,1266,8334,8337,10559,8342,10558,10557,10607,9429,10463,14,8341,10555,9593,10194,10561,9431,6066,9426,9436,10552,10551,10218,384,10330,10332,10331,4304,390,4684,9424,9425,9483,9433,9427,10563,4302,10606,4286,4287,4291,4305,10728,7963,10519,1557,7698,7844,7311,7608,7610,6498,9631,7693,7694,7695,7845,7843,7696,7868,9536,4804,6653,7176,7179,7180,7182,7187,6652,7176,7178,7179,7181,11015,11014,7183,11013,7189,4386,6654,7184,7185,7186,11016,5635,8899,10796,10797,10926,10975,10930,7600,11109,10928,10927,7676,11082,10931,8681,6221,8698,6223,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,6526,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,9412,10102,10336,10332,10334,10101,10331,10100,10324,10140,9433,10213,1770,9536,8245,10045,7610,10194,379,10335,10334,10429,6151,10336,10199,9408,9588,9589,9903,7570,10218,1766,10334,10215,8879,6749,1770,8244,10325,10323,10328,9951,10326,10324,10331,10158,10330,10329,10333,11007,10546,11050,10560,10555,10327,10159,10137,10138,10218,10563,8873,8700,10728,10099,9894,10198,9435,10322,9436,10140,6359,10330,9434,11138,10136,8649,10202,8872,10331,10323,11049,10324,10329,10333,10326,11137,11324,510,8824,7058,7752,10731,10305,7753,8088,4320,9951,11602,11601,7374,11320,11588,10305,11611,11723,11784,10646,11321,10752,4512,7751,7972,8681,7973,10647,10364,10822,10920,840,5380,1371,10238,11218,7631,8729,9920,8586,8307,10101,11138,10333,8875,8329,9114,8242,9182,8341,10334,9436,10336,10555,9412,8585,10728,8649,7114,10102,8872,9424,8241,10158,9055,11601,11247,10214,11240,10099,11217,11226,8873,9113,10728,8322,11291,10324,8244,9111,10151,10159,10152,8883,11617,11285,9119,9426,10555,10323,11238,9908,11167,10322,9970,10640,9426,8333,11161,10332,10325,11759,8244,8339,8243,9427,11138,8246,10329,11615,10323,11242,10158,11050,11677,9434,5389,10333,8649,9435,10326,10327,10330,10202,10324,9425,8249,8597,8241,10195,10551,8585,8242,10607,10218,10969,10799,10970,11137,11617,11240,8598,11618,8245,10336,11624,11406,10561,10558,11817,6800,10336,10216,10331,11138,10326,10096,10551,10152,10198,9520,535,10565,9407,7631,7546,7569,10100,8618,8244,10522,10827,10546,10521,10556,10797,10606,8241,11240,11050,11759,11677,10322,11049,8319,10099,8310,6261,735,8599,8598,8249,8243,11242,8308,10099,10159,10323,10325,8316,10096,10324,10922,11149,11618,8311,11759,11932,10726,11137,10326,11161,11405,8312,8313,8248,8245,10799,10970,11617,8584,10828,10427,11294,8308,8247,8317,8315,8246,11407,11933,11934,11697,6381,4287,1767,11049,10551) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC