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,10726,10728,10555,8244,11042,2709,9416,8917,11082,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,11137,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,10335,8326,10099,10555,10322,10218,9119,10332,10323,10325,10326,9592,10326,10327,10193,8649,8872,8873,9113,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,11082,10159,9410,6354,3070,3073,3071,6689,6688,9679,8943,7753,7752,8088,9037,8627,8944,9665,10053,10975,10544,8946,8727,10930,10844,7881,8563,8945,10927,10926,10931,11082,7870,8586,10930,10975,10928,9522,9515,9517,9520,9518,10379,9521,10522,11109,2643,10521,10346,10546,10463,10436,10402,10750,10612,10827,10545,11011,9762,653,10604,4805,8292,7042,778,10336,3511,11216,11568,10107,2145,10600,10600,10598,10601,10596,9067,10612,6840,11091,8168,11069,11080,11075,11079,11076,11078,545,549,548,11077,9189,9076,9794,4989,4997,970,2137,11095,8782,8771,6740,9052,8940,7175,11948,6376,6517,6989,6743,6750,6746,4614,7610,7103,6768,11082,8582,6199,6198,6200,9632,9631,11297,10445,3898,10981,6201,10948,9150,10947,8346,8345,7311,11429,9794,8228,1704,9076,4804,8771,7697,3515,7694,1666,7608,3442,7696,7646,7150,7868,11295,10801,11036,367,9588,11254,6745,10560,385,8878,9591,4302,11028,4301,11228,10751,4297,4286,8816,4305,9078,9257,4294,9483,9258,2998,4639,4296,4287,10764,3913,11082,10672,6354,8933,3070,8681,3073,11439,3071,11438,6689,7753,10039,11476,7752,11324,8088,173,8627,10236,9037,10053,11477,9665,11101,10892,9037,9665,8816,11658,10053,10975,10544,11221,11359,2989,9383,3327,6616,3898,4199,4512,9116,11822,510,4316,10893,6271,10561,3889,10994,7987,6928,7986,8695,3884,6527,8656,9149,8655,11082,10999,979,11391,10433,9144,11011,11297,11249,368,8693,8692,8694,6359,8656,7703,6271,726,9734,7199,11081,379,6520,11429,8655,11393,8585,11181,8696,367,11238,6744,8855,6270,10167,11390,11080,11181,7704,8982,10613,10169,6491,8655,375,11460,11069,6925,8154,6922,8002,8267,11067,10390,11071,9088,6800,6426,11068,8156,11182,11183,11184,4558,11181,8943,8944,6932,6354,3070,3073,3071,7881,8945,6689,6688,7753,8946,7752,8088,8627,9037,9665,10053,8946,6689,10544,10975,6768,11221,1303,6926,11355,11354,11356,11461,11357,4785,11082,9383,9867,9473,10232,8203,9633,9632,8362,11357,11356,11109,6198,2779,6443,2806,6197,9669,6200,8693,4512,4316,8692,11581,8694,8656,8654,8696,8695,8200,11578,8203,8655,4645,11579,3719,11582,3115,11580,11583,3559,11354,6520,11355,8203,11356,8656,11357,8696,8306,10331,1257,10332,5995,10328,10327,8241,9624,10326,8705,10323,507,11242,9626,10330,8704,11759,10333,8174,4046,10325,4512,11677,11320,11050,10326,10637,10646,7808,8943,10641,10645,8944,11723,7881,6354,10647,10644,3070,10642,3073,10639,8946,9383,10643,10637,9867,10752,10232,10519,6689,10521,10324,3071,10643,10645,6689,10640,11432,11183,9418,11922,9533,11322,11246,11069,7311,535,547,6800,10822,3358,10555,8002,11071,11068,6800,11459,11067,11466,1768,1766,1767,1769,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,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,11665,4520,11666,11667,8175,10823,10278,7922,6354,6503,6523,11425,5383,11429,10387,10489,10432,653,10520,10594,6417,10444,6388,10696,6393,7917,10797,6628,10796,10795,10794,10793,10791,3896,3889,7986,10790,11602,11204,11206,11207,1770,10753,9407,10687,1765,7631,1771,10644,10642,9520,1767,9084,1769,10647,8586,1768,11321,11427,9217,1766,379,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,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,3887,3883,3882,11375,1765,9137,979,9149,8824,1770,1765,1767,1771,6354,4,3070,979,6800,10483,8584,9156,11082,9084,3071,9949,737) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC