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,10203,1250,10478,10670,2658,10687,10940,8139,9866,11412,8302,4716,1250,4401,1809,3455,10649,10940,9739,9738,9313,10863,10890,10609,11315,11352,10608,10027,10738,10111,8477,9577,9959,4199,11106,11135,10892,8856,10002,10773,10774,1173,8052,10889,9293,7006,10741,10863,7095,10733,7092,10914,10362,10782,10737,11513,10400,3115,3719,9293,6631,7894,11515,10039,11443,6779,10587,9189,11528,9660,8477,7267,9148,11220,393,11116,7269,11543,9495,8573,7903,11332,11543,10942,7296,8070,11556,9072,7143,8463,10890,2875,1378,10617,10248,9821,10403,8268,8658,11511,4665,11509,10175,10889,10648,8858,10608,10495,9828,11224,11684,10744,9189,10026,11741,7269,10779,9581,9675,10400,11633,11794,10623,11802,10495,10464,11754,10027,10451,9874,11511,11797,10910,11801,9799,10674,9872,11508,11805,11753,10674,11671,8724,11540,10906,11572,10399,11916,11883,11741,11892,11914,11479,11917,554,11914,8359,11534,8547,11652,11651,10027,11265,10687,1782,9546,7639,9546,7639,11480,9125,11487,11479,11487,11479,11101,5435,10339,10916,3863,7385,10631,7456,10687,10687,11023,10687,3327,10844,9863,10687,9863,10579,10211,10526,7385,9300,4985,1993,6740,8220,10278,4639,10056,10228,11264,9865,10940,8358,6367,11690,11366,223,9946,11662,8302,1741,10687,8947,4769,1770,10314,11298,2749,11328,9949,10940,10809,11023,9866,11497,10687,11444,3327,11263,10937,11298,11326,51,11298,6892,10649,9044,8290,11373,10687,8290,11101,6740,8220,8434,8137,1988,10687,11053,10496,9687,10687,9709,7792,9686,9696,3830,6197,3989,4580,275,4860,1165,4234,3860,5535,726,393,2882,2160,4730,6154,1537,4131,5996,6545,1137,543,397,6138,6040,6559,4023,725,6686,6679,6197,7879,7840,7143,7878,8220,5764,7903,8183,3784,3263,215,8222,6750,7998,7638,5995,3761,2467,419,6981,1506,501,2706,8306,3059,971,1215,4178,1257,7833,3134,3368,8542,8616,8488,7840,7879,7878,4259,8529,8306,5143,466,252,6204,6539,7631,7870,7582,4136,3542,8434,4788,7896,8611,8615,3413,2261,7641,7837,7615,7903,7834,9144,8983,6713,9300,8842,9130,7910,9547,6023,10119,9220,9807,10548,10244,9752,9770,10523,10526,9924,10300,36,10688,11733,11346,10569,10892,10734,9811,10674,11325,9831,11101,10687,11749,11215,11311,10228,8290,2555,2555,1993,10339,4349,7273,7291,10185,10510,7289,9138,8794,7543,7400,7419,7472,7541,8868,7491,7563,7390,7449,9853,9025,7290,11201,11477,11479,11480,11476,1624,820,6801,10677,10817,6803,10985,2538,11053,11215,10707,3105,3108,7383,7409,7408,7406,1774,11638,10599,11582,11578,9430,10560,10559,9587,11687,9865,9589,8323,11216,317,11519,11307,11908,11900,10649,4985,8831,10668,11701,10682,11809,11808,11310,9094,10339,11310,9094,10351,9350,9946,1993,10466,10631) ORDER BY , is_available DESC,(total_rating/no_of_ratings) DESC,title ASC,publisher ASC,active DESC,author ASC