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,8712,9257,9758,9614,9674,4800,8240,9888,9889,2032,9870,9959,9132,8081,9556,10003,9933,8460,10050,10125,8914,10175,8302,8278,8276,10234,10230,10267,9538,10179,9325,10269,9205,10261,10315,9133,8275,10472,9813,10538,10624,8199,10625,10021,10673,10513,10672,10741,9645,11717,12020,6743,6270,6191,6426,10381,10383,10613,10173,8340,7199,10487,10729,8967,6545,6423,10549,6925,947,9910,10128,9941,10148,972,10063,10116,10283,10227,231,10284,10039,10188,6700,8139,10303,10319,10268,10473,4023,9406,10306,10526,10548,2841,10547,10569,5175,9031,10362,10268,10368,9900,10002,10528,10048,9832,9945,10543,10021,9126,10735,10375,10665,10208,10266,9212,4234,10290,10935,2639,10938,10541,10990,10723,10289,10919,10783,10653,10912,10895,10116,10904,10880,10871,10894,11021,3787,10892,11226,11202,2393,10115,11233,11135,10657,10715,11163,972,10778,1268,11136,10085,11220,2390,10683,11104,11287,11314,10739,11353,10740,10823,1181,11379,11172,9922,3482,10663,9249,11201,7869,10627,11324,11443,11377,11361,10653,11439,10130,11442,11388,11474,10893,4217,4527,9629,9354,9630,9939,11213,9235,5692,10085,10879,11285,4652,9666,10341,10864,9391,10649,3070,10704,10673,10905,10830,7910,10910,10668,9951,9258,9547,10649,8628,7861,2253,9864,961,7775,8780,126,11135,11043,8517,10061,11588,7693,10922,4614,10921,10790,11207,810,11591,9424,11458,8241,10606,8232,10822,11586,11291,7546,11904,8316,11906,8584,10649,9892,6102,6423,11254,11269) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC