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,10041,10031,9963,10021,10060,9963,4405,9968,308,10072,9988,9978,10061,9941,10056,10125,10121,10125,10183,10182,10163,9652,6348,9917,9917,10220,9967,9918,8214,10228,10261,10111,9307,10269,9967,10129,10267,10412,10113,10362,9701,10114,10312,10512,10313,6889,9835,10550,10538,10527,10547,8290,10553,10240,10003,10541,10182,10674,10667,10649,10650,10566,9448,10656,10741,10668,9979,10814,7774,10820,10480,10785,8515,9790,10935,10910,10786,10934,10938,10679,10905,6809,10976,10679,10905,10976,10679,11026,11027,9465,10303,11026,10673,9872,11090,7602,8268,8571,11094,11089,5688,11103,9093,10000,6769,11129,11127,10518,11121,11090,7970,10048,9336,11120,10229,11136,11200,11199,11222,11217,2913,10979,4254,10314,10778,11271,11169,11266,11280,11282,10184,11315,3647,11201,11338,11352,11324,11382,6646,11351,8517,3574,11436,11435,11447,11424,11417,7828,11447,11480,11496,7009,11494,11359,11477,11494,11488,8884,10873,8281,2063,9950,11112,11554,9950,11603,5688,11112,11554,11603,5688,11195,11608,11680,11679,11682,11717,9989,10294,10338,11736,11446,10875,11719,11800,11850,11851,11825,11855,11478,3913,11895,11879,11344,2615,11900,11904,11923,11902,11290,11905,236,10910,11010,8280,8299,7988,11829,11664,11978,12001,11860,12002,11980,11603,12016,12014,11371,12025,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,10499,10528,10048,9832,9945,10543,10021,9126,10735,10375,10665,10208,10266,9212,4234,10290,10935,2639,10938,10541,10990,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) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC