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,2261,8586,10821,8341,10638,9517,10797,10827,9920,10645,510,7178,10467,10820,3023,10796,10176,7179,9534,10795,10640,10257,675,10321,11019,10970,10647,10642,10977,10646,2451,3334,10637,1210,9418,9907,10643,4791,2677,947,3803,10552,2736,3392,5459,10938,1533,1425,7772,4645,7770,956,7771,1741,1370,511,512,173,7637,4535,10278,9493,11043,5251,11121,2995,4029,11138,4779,4762,28,3564,5431,1198,4731,11149,11218,11183,11184,11181,11037,11182,11185,11219,9880,7019,57,7238,6740,11240,11241,11321,11320,10822,11242,10742,11324,10840,10579,6354,3070,3073,3071,6689,4146,11387,11239,2506,7752,11115,8088,11455,7019,7761,8222,8793,8088,7636,8627,1368,11493,9037,5053,8943,1762,8793,9993,8816,8946,5576,10337,11677,11644,3875,10725,9259,10920,10923,10561,7119,9206,10214,10563,6270,9148,10216,8339,7933,9905,10194,10195,10922,10862,10333,10821,11048,10921,11139,8729,10200,9587,5635,11146,10199,10925,10201,10328,11147,8897,11013,10558,10330,10329,4386,11015,10331,10098,11014,11016,10323,10443,11022,11154,11148,7186,7187,10215,10607,7176,7180,2799,11157,7179,11160,7182,7181,7183,7185,9590,11156,7178,8596,10139,6654,10557,10560,7189,10800,9535,7184,11152,11153,6652,11051,7188,11240,11138,11247,8878,6653,8880,10335,11269,10551,8243,11167,11242,11033,10253,11241,10153,9970,10043,11031,9907,10256,8330,11296,11294,10728,10519,10799,9492,1245,10336,10970,5096,8248,11030,9410,10254,8327,10176,10218,11301,10100,8336,11022,6688,10803,6689,8946,3071,3073,6354,3070,6689,8088,7752,8627,9037,8727,10805,11221,6212,6215,4714,11238,11318,11317,11405,11406,10828,9880,10822,8343,11427,11431,374,11426,9903,11421,11422,6271,11419,9905,1250,11420,11418,5383,10804,3359,9679,10840,6689,9473,11464,11463,11252,11430,11466,11493,9806,11241,10558,10559,8243,8241,10556,8246,10333,10555,10546,7599,10563,10521,1685,1411,10327,10522,8249,8308,8312,8313,8315,8316,8320,8326,1266,810,10502,10565,9920,9407,6425,6424,10325,8618,8584,7870,8586,7546,10238,8682,9084,10488,9867,7631,8333,8329,8331,10336,10561,7638,5332,10519,1556,10328,10489,2605,9383,10545,10821,3875,1770,1768,1771,1765,1766,1767,8007,8159,2932,8825,10427,10612,10866,10931,7676,7600,10930,1768,10929,10799,10800,10963,10928,10840,7676,10927,10926,10828,3889,3890,3891,3892,3893,3894,3895,3896,3897,10725,10216,10159,1769,10849,1766,8585,10637,9679,11069,11019,11049,11047,10526,11008,8002,11071,8154,11048,10526,11055,7810,8971,9165,735,1730,11139,11046,11138,11057,11203,11192,11191,11186,11185,11183,11181,11182,11175,11184,11177,8311,11221,11229,11243,9665,11244,10544,10053,8162,2488,11221,10975,11245,7734,11246,11241,11218,4752,8703,11190,11193,9278,11406,11407,11161,11242,10326,11046,11151,11153,11154,10560,9424,9425,9426,9428,9431,9434,9432,9435,8324,10562,10201,10139,8162,8161,11156,11405,11160,11240,10329,10330,10331,10324,11695,11696,11697,11617,11050,11677,11320,11321,11357,11356,11355,11694,11722,11356,11467,11318,11319,11723,7610,7608,7868,5691,7693,11317,7311,848,7580,3442,3515,1704,7697,7696,7695,7694,11611,11354,11618,11836,6800,8002,11068,11067,8154,11071,11799,11069,10640,10641,10642,10643,10644,10639,10645,10646,10752,11252,11251,11461,11493,11228,2677,10726,10728,10555,8244,11042,2709,9416,8917,11082,11085,2743,3613,8260,11050,10522,6600,1762,1681,11050,8336,9792,10606,9231,5656,10970,10607,8319,3613,8874,7370,6485,5516,8599,11050,10324,8875,10799,11055,8598,11139,8699,9112,11009,10963,8193,11008,11149,11048,11047,11151,2826,6442,11054,11157,2827,2825,11057,8242,11160,11159,9409,11138,11161,6489,2815,2823,9184,9410,11158,2822,2821,2824,11156,11240,2816,2817,2820,2818,9407,10565,11218,2806,2808,2807,2812,11139,11173,11037,11174,11182,10924,11155,2787,10466,10920,7171,10922,11186,10829,11138,8272,10828,10519,11178,8232,10827,10546,10520,4390,5332,5297,1685,9149,10522,9137,8274,5383,10925,3884,3881,3073,11375,947,3885,3890,7631,1730,11461,1766,8585,1768,1769,1767,7884,7374,11459,9906,8161,5059,11167,9632,10251,10924,2522,11194,10213,10256,10102,9907,9970,11269,10255,10043,11032,10254,11030,8241,6656,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,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,10217,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,10322,9430,11048,308,8325,10970,10908,10555,10336,8247,10215,10607,10729,11121,6740,10728,11149,7238,8220,11009,10250,11057,547,549,550,7592,551,6042,536,537,539,510,8820,9438,9437,10354,542,541,540,548,543,10607,553,532,531,529,528,525,524,8247,533,11242,554,526,11049,527,4486,4473,4470,7168,4464,4463,7677,7167,7163,7166,7165,7164,7174,7173,11254,1770,10545,1765,10522,8316,1771,8327,1767,10520,9435,11241,3888,11050,11242,11019,10159,11375,11240,9633,11317,11149,10923,8321,10921,3885,1768,10924,1769,6197,10330,6198,11221,6354,10822,10975,10981,8627,6689,7752,11242,10522,6199,10327,6201,6197,8856,3073,9412,11240,5297,11138,11149,11204,11301,11587,10232,8585,8584,4293,10828,10836,11690,7610,6834,10232,9867,9522,10292,10159,10331,9432,6354,3070,6688,6689,3071,3073,7753,8946,11393,11050,4520,11422,11425,11241,11576,11016,11667,4536,510,10332,10194,10323,11570,9734,10335,7772,11625,7753,8334) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC