thisMySQL 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,8584,10251,6023,10193,7917,7054,10332,10562,9429,10139,3071,10559,8618,10557,10726,10215,10325,10326,10327,10322,10218,10328,10334,10330,10331,10333,10329,8943,8944,11019,8885,7752,11033,9970,11047,4923,8787,9555,9522,510,694,681,391,8880,378,365,372,385,9231,389,8878,381,6066,9150,9143,1769,7881,380,11022,11057,11247,11269,10176,11238,11254,11296,11051,11239,695,9031,8244,10555,694,10801,6540,9429,6544,11157,10199,11218,10556,10251,9970,8784,9906,11151,8882,8881,10463,11207,8343,10214,11154,10558,8883,6270,10216,9184,549,393,10800,384,11407,11392,9587,8323,10561,11299,9147,9154,9155,11078,9156,9792,10957,9217,9151,9146,11405,387,9191,8858,8789,386,8788,375,382,11209,11052,11294,11320,11461,11406,368,461,7861,4259,11077,4251,6788,11081,11079,3895,3893,3891,3887,3894,3890,3888,3884,8272,6493,3897,3896,3892,3889,3885,3883,8618,8682,9084,7172,9407,10238,11019,9920,10565,9084,7631,11218,7184,11016,5635,4386,7179,7189,6652,7178,7182,11240,510,8897,7770,7180,7772,7771,511,512,8946,6654,11013,6688,9473,11014,7181,7183,11354,7176,6653,7188,11419,11421,11422,7187,11418,11420,9407,9084,8682,10565,10238,9920,11146,11147,11148,11015,11082,11392,9437,11019,7998,4386,9129,11218,9671,9670,9669,8946,7186,11464,11493,11463,8172,10750,11431,8007,6596,9233,10433,11017,8971,11430,11414,11429,11321,6836,11498,8610,11446,5988,11521,10472,6521,11181,11487,11495,11427,1347,5339,5545,9084,9920,8682,11362,8681,11109,9958,8698,11468,848,9492,6216,10864,11269,11649,11349,11664,6497,11377,11378,11678,11069,8154,10042,9638,9220,10941,11493,11647,11349,11724,10895,8900,9638,9220,10569,10787,10856,10042,9904,9086,252,5373,11126,11678,6713,11237,51,4082,7550,8837,5193,3018,10367,8780,4401,10824,24,9896,11355,1770,7184,8306,6713,7185,11016,11647,11463,11464,7176,11488,11664,5255,11876,6800,28,10942,9492,11093,524,543,553,539,535,529,532,554,7124,7078,9933,11592,7107,3888,11624,10482,9439,9290,11349,10354,9601,9334,8902,11724,11981,9888,8542,8434,10442,6740,11121,11690,9300,10056,8541,8922,1190,6836,9233,11622,8582,6240,11442,8819,2294,156,3080,5817,3894,11376,1685,11376,4301,11318,11376,7610,11181,11427,11375,11037,8586,11375,11268,9084,11179,4386,9407,9903,10811,11254,11297,7186,11418,9920,11251,7870,7188,10821,6200,9632,4463,11493,7267,10890,7546,11431,10565,11192,8451,7182,11321,11016,10642,10639,11245,11218,7185,11320,10646,11463,10752,11422,9633,11191,11193,10643,10612,10644,7176,7172,11570,11650,11019,1557,11011,11032,11354,11723,11252,8362,735,6596,8200,10502,8253,11183,7698,8885,8566,11697,11519,11797,8436,11176,3066,11099,11799,10877,11801,11125,11926,11712,11525,9232,7669,10807,10889,10647,11893,11465,9518,9520,9521,8340,11220,11205,10687,8241,8139,8249,11206,10606,11203,11050,10139,8318,8247,11007,8248,8310,11055,11009,9416,2780,9415,5297,4390,51,10325,8824,10522,8332,8262,11021,11402,10227,10323,10828,10227,10323,10828,11207,11209,11204,11149,10606,8327,9182,8699,11646,3073,9402,11148,9625,9626,8314,8586,11722,11218,10565,11493,9424,10327,11419,9624,9625,10797,11013,7188,7178,11464,11463,7189,11421,7185,11014,11493,11218,11722,10238,9407,8682,11019,11759,10565,11218,7870,7546,9920,11493,6654,10238,1765,8585,11206,9522,11899,10332,10327,11463,3895,3893,10329,10333,3888,11050,3897,3885,11242,10330,3883,8639,10331,3882,10323,1768,1766,11624,11759,6493,11931,3889,11932,11156,11406,11407,11154,10139,11405,11153,10556,10201,4938,4936,8924,9590,10328,9350,8325,11161,7877,10324,9949,10563,11151,9303,10560,4941,8596,7819,9949,8478,9430,9350,9589,10199,11009,10200,9303,7877,11055,10727,11008,11618,10562) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC